Re: Nu-B Question

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
>

In response to

Browse pgsql-general by date

  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