Re: newbie postgresql question SOLVED

[Charles Lewis <lewisc@delta.swau.edu>]

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
lewisc@delta.swau.edu
817-556-4720

on 3/1/01 1:53 PM, Andrew Perrin at aperrin@socrates.berkeley.edu 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
> 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
>> 
>> 
> 
>