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 [EMAIL PROTECTED] - [EMAIL PROTECTED] 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 > [EMAIL PROTECTED] > 817-556-4720 > > > > -- > To UNSUBSCRIBE, email to [EMAIL PROTECTED] > with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED] > >
