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.
Thanks in advance for all the help
Regards,
Amit
-----Original Message-----
From: Dave Page [mailto:dpage@vale-housing.co.uk]
Sent: Tuesday, May 24, 2005 3:36 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: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Amit Sharma
> Sent: 24 May 2005 12:02
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] cannot access postgresql 7.3 via
> pgadmin III
>
>
>
> Hi,
>
> I am trying to access postgresql version 7.3 using pgadmin
> III from windows
> 2000 OS but i always keep getting the error Fatal - password
> authentication
> failed for user root. i have allowed access in the
> pg_hba.conf file for all
> users to access all databases by the defined ip's but still
> whenever i try
> to access the database from pgadmin remotely i get the error Fatal -
> password authentication failed for user root. I have also a
> set tcp ip =
> true in postgresql.conf. Can you please give me some hints as
> to what could
> be the problem.
Do you have a PostgreSQL user called root? The PostgreSQL superuser
account is normally 'postgres'.
Regards. Dave.