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