I was still getting the pgaccess error when trying to create a new db, so I tried opening the existing template1 with success (after login). THEN I tried to create a new db and discovered I didn't have permission. Logged in as postgres and did:
ALTER USER "chas" CREATEDB; ...and they lived happily ever after... :) Thanks for your help. Now I'm off to learn some sql -- Charles Lewis [EMAIL PROTECTED] 817-556-4720 on 3/1/01 1:53 PM, Andrew Perrin at [EMAIL PROTECTED] wrote: > 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] >> >> > >