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: all postgres users do "not exist"
Date: Wed, 15 Nov 2006 11:31:07 -0800 (PST)
Message-ID: <20061115193107.64930.qmail@web62404.mail.re1.yahoo.com> (raw)

 Hello,

    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.
 This action should not have affected postgres users in any way.  We did
not modify the template1 database (which affects users?) or anything of
that sort.  The only other oddity of our installation I can think of is
that fact that the local data directory (/usr/local/pgsql/data) points
to another data directory at the root of the postgres unix account which
really contains the database data (/home/local/pgsql/data).  Is there
any way to reinitialize while preserving the existing data directory
(dbinit??)?    
   
  Thanks,
Will Cameron

clusterdb       droplang        pg_config       pg_resetxlog    vacuumdb
createdb        dropuser        pg_controldata  pg_restore
createlang      ecpg            pg_ctl          postgres
createuser      initdb          pg_dump         postmaster
dropdb          ipcclean        pg_dumpall      psql
bash-2.05$ psql -l
psql: FATAL:  user "postgres" does not exist
bash-2.05$ who am i
postgres   pts/5        Nov 15 00:18    (g83-sb1-1.csc.villanova.edu)
bash-2.05$ su postgres
Password: 
bash-2.05$ export LD_LIBRARY_PATH
bash-2.05$ LD_LIBRARY_PATH=/usr/local/lib
bash-2.05$ psql -l
psql: FATAL:  user "postgres" does not exist



pg_hba.conf:


# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                               trust
# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
# IPv6 local connections:
host    all         all         ::1/128               trust
host dspace dspace 127.0.0.1 255.255.255.255 md5

 
---------------------------------
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: <20061115193107.64930.qmail@web62404.mail.re1.yahoo.com>
Permalink:  ../20061115193107.64930.qmail@web62404.mail.re1.yahoo.com/
Also on:    postgresql.org/message-id/20061115193107.64930.qmail@web62404.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: <20061115193107.64930.qmail@web62404.mail.re1.yahoo.com>
  References: <20061115193107.64930.qmail@web62404.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