Re: Postgress installation...
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
aperrin@socrates.berkeley.edu - aperrin@igc.apc.org
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: nacho@it.kth.se
> http://www.it.kth.se/~nacho/
>
>
>
> --
> To UNSUBSCRIBE, email to debian-user-request@lists.debian.org
> with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
>
>
Reply to: