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. Does

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 mbert with

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 user's

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 export

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 forgotten to set the

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]