This is discussed in the Postgresql documentation. If you have problems you are likely to get a better answer from the postgresql mailling list.
You need to add 'nemanuel' to the Postgresql system. I think the command is createuser or something similar. On Sat, 9 Jan 1999, Nuno Carvalho wrote: > Date: Sat, 09 Jan 1999 14:54:49 +0000 > From: Nuno Carvalho <[EMAIL PROTECTED]> > To: debian-user@lists.debian.org > Subject: PostgreSQL error ... > Resent-Date: 9 Jan 1999 14:55:41 -0000 > Resent-From: debian-user@lists.debian.org > Resent-cc: recipient list not shown: ; > > 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. > > Thanks in advance. > > Best regards, > Nuno Carvalho > > ¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨ > Nuno Emanuel F. Carvalho > Dep. Informatics Engineering > University of Coimbra > > PGP key available at finger > ¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨ > > > > -- > Unsubscribe? mail -s unsubscribe [EMAIL PROTECTED] < /dev/null >