Nu-B Question
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?
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.
laprice@efn.org | And the truth makes no sense." -chesterton
_______________________________________________________________
On Mon, 7 May 2001, Jorge Escalante wrote:
Show quoted text
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?