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