Re: [ADMIN] all postgres users do not exist

2006-11-16 Thread Will Cameron
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

Re: [ADMIN] all postgres users do not exist

2006-11-16 Thread Tom Lane
Will Cameron [EMAIL PROTECTED] writes: 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? No, I mean stopping the postmaster, running a

[ADMIN] all postgres users do not exist

2006-11-15 Thread Will Cameron
Hello, We are using (PostgreSQL) 8.0.1 for Solaris. Apparently ourpostgres users were wiped out somehow, for I cannot even log in assuperuser "postgres". Our pg_hba.conf settings are as loose as possible("trust"). This problem started mid session after we ran a .sql scriptto upgrade a DSpace

Re: [ADMIN] all postgres users do not exist

2006-11-15 Thread Tom Lane
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