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 <[EMAIL PROTECTED]> 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 -------- >[EMAIL PROTECTED]:/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