Re: Starting with postgreSQL and pgaccess

[joost@topaz.mdcc.cx (Joost Kooij)]

On Wed, Jul 18, 2001 at 03:09:20PM +0000, Victor wrote:
> Joost Kooij [debian-user] <17/07/01 21:55 +0200>:
> >....Just create a valid user with your id, grant priviledges
> > to create new databases and then after that you can do most or all things 
> > as regular user. 
> 
> First of all, thanks Joost, it now works for the postgres superuser only, not for other users I've defined.
> 
> Now the problem of this absolute beginner is the definition of ID when
> using createuser. What exactly should I input at the prompt for it? My
> user ID as a linux user (the one I find in records in file
> /etc/passwd) or what else?

I'm sorry, I should have mentioned the appropriate tools the first time.
It is all explained in createuser(1).  Also interesting are pg_passwd(1)
and createdb(1).  Run createuser as the postgres admin user. 

Cheers,


Joost