Re: cannot access postgresql 7.3 via pgadmin III

Hi Dave,

Yeah the output of select * from pg_user; returns two values.

1. root (usesysid - 100)with some password in encrypted form
2. postgres (usesysid - 1) with password in encrypted form

What is the password of the user postgres???, so i can try to connect via
this one and check.

Thanks
Regards
Amit

-----Original Message-----
From: Dave Page [mailto:dpage@vale-housing.co.uk]
Sent: Tuesday, May 24, 2005 4:24 PM
To: amit.sharma@wificom.com; pgadmin-support@postgresql.org
Subject: RE: [pgadmin-support] cannot access postgresql 7.3 via pgadmin
III




> -----Original Message-----
> From: Amit Sharma [mailto:amit.sharma@wificom.com]
> Sent: 24 May 2005 12:59
> To: Dave Page; pgadmin-support@postgresql.org
> Subject: RE: [pgadmin-support] cannot access postgresql 7.3
> via pgadmin III
>
> Hi ,
>
> I have a database called sabdb. I can use the pasql client
> from linux and
> connect to it via root, so i guess root access to the db is
> allowed. The
> only problem is to connect to it via pgadmin III on win 2k OS
> via external
> hosts whose IP's are already entered into the pg_hba.conf .
> Please view the
> attached files for your reference. I am a novice in
> postgresql and so i want
> to connect to the database via a windows tool and check the database.

What does "select * from pg_user" return? Is there a user called root in
the result set?

Regards, Dave