Re: Error connecting to postgres database: Thanks
:-> 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
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 environment for postgres > try > # Settings for using postgres > export PGHOME=/var/postgres > export PGDATA=/var/postgres/data > export PGLIB=/usr/lib > export PGPATH=/usr/bin > or similar, > after that You must login as user `postgres` > and run the createuser similar to : > postgres $ createuser mbert > Enter user's postgres ID or RETURN to use unix user ID: 600 -> > Is user "mbert" allowed to create databases? (y/n) y > Is user "mbert" allowed to add users? (y/n) y > createuser: mbert was successfully added > postgres $ > after that postgres will run: > If You can't login as user `postgres` try login: root su postgres > -- >Peter > > > -- > Unsubscribe? mail -s unsubscribe [EMAIL PROTECTED] < /dev/null > -- Peter
Re: Error connecting to postgres database
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 PGHOME=/var/postgres export PGDATA=/var/postgres/data export PGLIB=/usr/lib export PGPATH=/usr/bin or similar, after that You must login as user `postgres` and run the createuser similar to : postgres $ createuser mbert Enter user's postgres ID or RETURN to use unix user ID: 600 -> Is user "mbert" allowed to create databases? (y/n) y Is user "mbert" allowed to add users? (y/n) y createuser: mbert was successfully added postgres $ after that postgres will run: -- Peter
Re: Error connecting to postgres database
:-> 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 postgres ID -> 1003 :-> Is user "mbert" allowed to create databases (y/n) n :-> Is user "mbert" allowed to add users? (y/n) n :-> createuser: mbert was successfully added :-> don't forget to create a database for mbert :-> :-> createuser must be run by the user postgres How to do that? (or by any other user who :-> is allowed to add users - at first installation there will not be any :-> such). :-> :-> Any users successfully created will be in pg_shadow, so the error you :-> report indicates that createuser failed in some way. :-> :-> -- :-> Oliver Elphick[EMAIL PROTECTED] :-> Isle of Wight http://www.lfix.co.uk/oliver :->PGP key from public servers; key ID 32B8FAA1 :-> :-> "Enter into his gates with thanksgiving, and into his :-> courts with praise. Be thankful unto him, and bless :-> his name." Psalms 100:4 :-> :-> Thanks Mario Bertrand <[EMAIL PROTECTED]>
Re: Error connecting to postgres database
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 createuser but >i >have the same message. Does anyone already gone true that? What output did you get from createuser? It should have been something like this: bash-2.01$ createuser mbert Enter user's postgres ID -> 1003 Is user "mbert" allowed to create databases (y/n) n Is user "mbert" allowed to add users? (y/n) n createuser: mbert was successfully added don't forget to create a database for mbert createuser must be run by the user postgres (or by any other user who is allowed to add users - at first installation there will not be any such). Any users successfully created will be in pg_shadow, so the error you report indicates that createuser failed in some way. -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver PGP key from public servers; key ID 32B8FAA1 "Enter into his gates with thanksgiving, and into his courts with praise. Be thankful unto him, and bless his name." Psalms 100:4
