Re: PostgreSQL error ...

["Peter Berlau" <pberlau@muenster.de>]

Hi Nuno,
You must do some steps of configuration before psql You can
psql.

(sorry sitting on front of wintendo, so I can have a look to the
environment, but I'm sure You easilly will  find the rigth settings on Your
system, )
1. Einvironment-Variables-Settings:
Environment-Variables, e.g. (changes will be need to settings for Your
system here)
PGHOME   /var/lib/pgsql
PGDATA     /var/lib/pgsql/data
PGLIB        /usr/lib/pgsql/lib
PGPATH    /usr/bin
2. login as user postgres

start:
postgres$ createuser nemanuel
Enter user's postgres ID or RETURN to use unix user ID:  600 ->
Is user "nemanuel" allowed to create databases(y/n)   y
Is user "nemanuel" allowed to add users (y/n)             y
createuser: nemanuel was succesfully added
postgres $

after the above changings in dependencies of Your system
You will be able to run psql


-----Ursprüngliche Nachricht-----
Von: Nuno Carvalho <nemanuel@student.dei.uc.pt>
An: <debian-user@lists.debian.org>
Datum: Samstag, 9. Januar 1999 15:58
Betreff: PostgreSQL error ...


>Hi,
>
>   I'm trying to run psql but without success! :(
>
>  I get the following message:
>
>------ cut here --------
>nemanuel@cavern:/usr/lib/postgresql/bin$ psql
>Connection to database 'template1' failed.
>FATAL 1:  SetUserId: user "nemanuel" is not in "pg_shadow"
>------ cut here --------
>
>  What should I do !?
>   Should I add nemanuel user to pg_shadow !? How can I do it ?
>
> Doing: "postgres template1" works fine.
>
cYa
Peter