Postgresql refure to connect

1998-09-16 Thread Giuseppe Sacco
Hi, I have just installed the postgresql DBMS from debian hamm. I am trying to play a little with it, but at the first attempt I get this error: hsogso:~# psql Connection to database 'template1' failed. FATAL 1: SetUserId: user root is not in pg_shadow hsogso:~# uname -a Linux hsogso 2.1.120 #16

Re: Postgresql refure to connect

1998-09-16 Thread Nicolai Guba
Giuseppe == Giuseppe Sacco [EMAIL PROTECTED] writes: Giuseppe Organization: HSO Business Company Giuseppe X-Mailer: Mozilla 4.05 [en] (WinNT; I) Giuseppe hsogso:~# psql Giuseppe Connection to database 'template1' failed. Giuseppe FATAL 1: SetUserId: user root is not in pg_shadow Root is NOT

Re: Postgresql refure to connect

1998-09-16 Thread Giuseppe Sacco
Hi Nicolai, I thank you very much for explaining that I have to use the postgres user. I will. About the second problem you said thet I should delete the file in /tmp/.s.PGSQL.portnr but this file does not esists! This is the problem. I am not sure but I think that the /tmp directory is

Re: Postgresql refure to connect

1998-09-16 Thread Nicolai Guba
Giuseppe == Giuseppe Sacco [EMAIL PROTECTED] writes: Giuseppe Organization: HSO Business Company Giuseppe X-Mailer: Mozilla 4.05 [en] (WinNT; I) Molto grazie Giuseppe ;) Giuseppe About the second problem you said thet I should delete the file in Giuseppe /tmp/.s.PGSQL.portnr but this file does