pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Will Cameron <novawcameron@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Re: all postgres users do "not exist"
Date: Thu, 16 Nov 2006 09:40:49 -0800 (PST)
Message-ID: <20061116174050.93090.qmail@web62414.mail.re1.yahoo.com> (raw)
In-Reply-To: <12936.1163658755@sss.pgh.pa.us>

    Hello,
       
                I'm not sure what exactly you mean by "starting a standalone
  postgres session and using it to recreate your SQL users".  Do you  mean running initdb on a new data directory and then trying to create  new users?  I'm fairly certain we already tried that.  Since  we cannot log into the postgres user at all we can't run  createuser.  We can start and stop the database but cannot log in  with any users.  We ran the script in this fashion:
  
  psql -f etc/database_schema_12-13.sql [DSpace database name] -h localhost
  
        The script just contains sql commands to  create tables and sequences within the database specified.  Again,  I don't know much about the template1 database but we did not touch it  (that we know of) if it does contain user accounts.  I'm thinking  perhaps since the local data directory actually just points to another  one which has the real data that psql might have been confused.
  
  /usr/local/pgsql/data
  
  lrwxrwxrwx   1 root      other         22 Apr 18   2006 data -> /home/local/pgsql/data
  
  
  /home/local/pgsql/data
  drwx------  10 postgres staff        512 Nov 15 14:10 data
  
  Thanks,
  Will
  
  
  
  
  
  
  
Tom Lane <tgl@sss.pgh.pa.us> wrote:  Will Cameron  writes:
>     We are using (PostgreSQL) 8.0.1 for Solaris.  Apparently our
> postgres users were wiped out somehow, for I cannot even log in as
> superuser "postgres".  Our pg_hba.conf settings are as loose as possible
> ("trust").  This problem started mid session after we ran a .sql script
> to upgrade a DSpace digital library database within the postgres system.

Better take a closer look at what that script did.

Meanwhile, you can probably get out of this by starting a standalone
postgres session and using it to recreate your SQL users.

   regards, tom lane


 
---------------------------------
Sponsored Link

   Mortgage rates as low as 4.625% - $150,000 loan for $579 a month. Intro-*Terms

view thread (4+ messages)  latest in thread

Message-ID: <20061116174050.93090.qmail@web62414.mail.re1.yahoo.com>
Permalink:  ../20061116174050.93090.qmail@web62414.mail.re1.yahoo.com/
Also on:    postgresql.org/message-id/20061116174050.93090.qmail@web62414.mail.re1.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: novawcameron@yahoo.com
  Subject: Re: all postgres users do "not exist"
  In-Reply-To: <20061116174050.93090.qmail@web62414.mail.re1.yahoo.com>
  References: <12936.1163658755@sss.pgh.pa.us> <20061116174050.93090.qmail@web62414.mail.re1.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox