Re: Error connecting to postgres database: Thanks

1999-01-11 Thread Mario Bertrand
:-> If You can't login as user `postgres` try :-> login: root :-> su postgres :->> -- :->>Peter Thank you, It was so simple... after 2 days of readings and few hours of sleep :-) Mario Bertrand <[EMAIL PROTECTED]>

Re: Error connecting to postgres database

1999-01-11 Thread Peter Berlau
On Mon, Jan 11, 1999 at 01:23:09PM +0100, Peter Berlau wrote: > On Mon, Jan 11, 1999 at 04:37:33AM -0500, Mario Bertrand wrote: > Hi Mario, > > > > > Error connecting database > > Connection to database failed > > FATAL 1: SetUserld: user "mbert" > > is not in "pg_shadow" > eventually You've forg

Re: Error connecting to postgres database

1999-01-11 Thread Peter Berlau
On Mon, Jan 11, 1999 at 04:37:33AM -0500, Mario Bertrand wrote: Hi Mario, > > Error connecting database > Connection to database failed > FATAL 1: SetUserld: user "mbert" > is not in "pg_shadow" eventually You've forgotten to set the environment for postgres try # Settings for using postgres expo

Re: Error connecting to postgres database

1999-01-11 Thread Mario Bertrand
:-> What output did you get from createuser? $ createuser mbert Connection to database 'template1' failed. FATAL 1: SetUserId: user "mbert" is not in "pg_shadow" createuser: database access failed. It should have been something :-> like this: :-> :-> bash-2.01$ createuser mbert :-> Enter u

Re: Error connecting to postgres database

1999-01-11 Thread Oliver Elphick
Mario Bertrand wrote: >Hi, it's my first try in connecting to the database and have the following >message: > >Error connecting database >Connection to database failed >FATAL 1: SetUserld: user "mbert" >is not in "pg_shadow" > >I have read the docs and try to create the user "mber

Error connecting to postgres database

1999-01-11 Thread Mario Bertrand
Hi, it's my first try in connecting to the database and have the following message: Error connecting database Connection to database failed FATAL 1: SetUserld: user "mbert" is not in "pg_shadow" I have read the docs and try to create the user "mbert" with createuser but i have the same message. D