On Fri, 2003-03-28 at 16:06, himansu biswal wrote: > hi, > i tried to execute psql template1.i got the problem > below.plz help me out. > > [EMAIL PROTECTED] /]# su jat - > [EMAIL PROTECTED] /]$ whoami > jat > [EMAIL PROTECTED] /]$ psql template1 > psql: FATAL 1: user "jat" does not exist
PostgreSQL users are not the same as local system users (a PostgreSQL server can be accessed from other machines, if you configure it so.) You need to create database users with the SQL command CREATE USER or the system command createuser. Look up their documentation to see how. You also need to look at access controls in $PGDATA/pg_hba.conf - see the Administrator's manual. -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "If we confess our sins, he is faithful and just to forgive us our sins, and to cleanse us from all unrighteousness." I John 1:9 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
