From: | larry a price <laprice(at)efn(dot)org> |
---|---|
To: | Jorge Escalante <escalante(at)canada(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Nu-B Question |
Date: | 2001-05-11 16:42:05 |
Message-ID: | Pine.GSU.4.21.0105110935180.29389-100000@garcia.efn.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)efn(dot)org | 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-05-11 17:19:41 | Re: defunct postmasters |
Previous Message | Tom Lane | 2001-05-11 16:40:47 | Re: PL/Perl without shared libperl.a |