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 happil
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
Charles Lewis wrote:
> 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
> litt
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 opt
4 matches
Mail list logo
