Re: newbie postgresql question
What you need to do is log into the box as the postgres super-user
(generally username is 'postgres') and add the user:
su - postgres
psql
(if it complains that there's no postgres database, you might have to do:
initdb
)
then do:
CREATE USER username WITH PASSWORD password;
there are more options to CREATE USER outlined in the postgresql docs
which should be in your /usr/doc tree, or by typing:
\h create user
at the psql prompt.
Hope this helps.
----------------------------------------------------------------------
Andrew J Perrin - Ph.D. Candidate, UC Berkeley, Dept. of Sociology
Chapel Hill, North Carolina, USA - http://demog.berkeley.edu/~aperrin
aperrin@socrates.berkeley.edu - aperrin@igc.apc.org
On Thu, 1 Mar 2001, Charles Lewis wrote:
> Just installed postgresql 7 and went through the config files and everything
> looks fine. Log in with my user account and open up pgaccess to create a new
> database and get the following error:
>
> Tcl error executing pg_exec
> create database invoice
>
> is not a valid postgresql
> connection
>
> If I log in as user postgres, I can run psql, but if I try to run psql under
> another user I get:
>
> psql: FATAL 1: SetUserId: user 'chas' is not in 'pg_shadow'
>
> I imagine that I have to add myself to some group or something, but I have
> absolutely no idea where to start looking.
>
> I've read some postgres documentation, but debian apparently does things a
> little differently. Any suggestions?
>
> --
> Charles Lewis
> lewisc@delta.swau.edu
> 817-556-4720
>
>
>
> --
> To UNSUBSCRIBE, email to debian-user-request@lists.debian.org
> with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
>
>
Reply to: