Re: all postgres users do "not exist"

Will Cameron <novawcameron@yahoo.com> 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