First log in as the postgres super-user (generally, username is postgres) and do:
psql create user nacho with password xxxxx createdb; which will allow user nacho to create databases. There's a lot of good documentation for postgresql in the postgres-doc package, or via www.postgresql.org. There's a new book by Bruce Momjian which is available online via the website. ---------------------------------------------------------------------- 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 Wed, 24 Jan 2001, Ignacio Más Ivars wrote: > > Hi!! > > I am having problems installing PostgreSQL in my potato. I have > installed all > the required packets, including the docs... and now I try to create a > database > with: > > createdb adad > > and my Debian answers with: > > ------------ > Connection to database 'template1' failed. > FATAL 1: SetUserId: user 'nacho' is not in 'pg_shadow' > > createdb: database creation failed on adad. > ------------ > > I saw a group called postgres in /etc/group, so I added my user 'nacho' to > the > group. It still does not work... I have even tried to issue the createdb as > root, having the same answer... I know that it must be a stupidity about > permissions somewhere, but I really do not find it!!! Could someone please > help me out? > > Please, make a Cc: to my e-mail, as I cannot receive all the traffic from the > list... > > Thanks in advance > > /Nacho > -- > Ignacio Más Ivars > Department of Teleinformatics - Royal Institute of Technology (KTH/IT) > Electrum, 204 S-164 40 KISTA (Sweden) > Office phone: +46 8 7521497 > Office fax: +46 8 7511793 > E-mail: [EMAIL PROTECTED] > http://www.it.kth.se/~nacho/ > > > > -- > To UNSUBSCRIBE, email to [EMAIL PROTECTED] > with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED] > >
