Re: can you solve my problem

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.
>
> [root@linux2 /]# su jat -
> [jat@linux2 /]$ whoami
> jat
> [jat@linux2 /]$ 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                                Oliver.Elphick@lfix.co.uk
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