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
Reply to: