Will Cameron <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match