Re: cannot create new user in postgres

From: tolik(at)aaanet(dot)ru (Anatoly K(dot) Lasareff)
To: joydip(at)cal2(dot)vsnl(dot)net(dot)in
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: cannot create new user in postgres
Date: 2001-03-07 07:42:40
Message-ID: 86pufu58jz.fsf@tolikus.hq.aaanet.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

>>>>> "j" == joydip <joydip(at)cal2(dot)vsnl(dot)net(dot)in> writes:

j> Hi all

j> I have tried to configure the pg_hba.conf with

j> local all
j> trust
j> host all 127.0.0.1 255.255.255.255 trust

j> then i tried to run

j> psql -h localhost template1

j> but any of my domain failing to use postgresql .

j> They are showing error re no entry in pg_shadow.


j> though it was running in root ok with user postgres

j> Thanks in advance for the help

Who is postgres superuser? Suppose it is 'pgsql', then try

psql -U pgsql templateq

--
Anatoly K. Lasareff Email: tolik(at)aaanet(dot)ru
http://tolikus.hq.aaanet.ru:8080 Phone: (8632)-710071

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message mike 2001-03-07 08:37:04 Re: cannot create new user in postgres
Previous Message Sean Weissensee 2001-03-07 03:47:42 Using psql