you need to be a postgresql user, which is somewhat like being a unix user but different, you said earlier that you've got a debian system so, if you have a user account that is already registered as a postgres superuser login to that account and say: createuser jorge Otherwise, if you've just installed postgresql and didn't register you home useraccount while doing so. Try the following su -> (become root) su postgres -> (become postgres, you won't need a password) createuser <username> and then follow the prompts :-) Larry Price | "We have seen the truth. [EMAIL PROTECTED] | And the truth makes no sense." -chesterton _______________________________________________________________ On Mon, 7 May 2001, Jorge Escalante wrote: > When I typed 'psql -l' I get a message saying: > "Connection to database 'blabber' fail. > FATAL 1: SetUserId: user jorge is not in 'pg_shadow'." > Do I need to login to psql? if so, how do I do this? > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
