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:[EMAIL PROTECTED] Sent: Tuesday, May 24, 2005 4:24 PM To: [EMAIL PROTECTED]; pgadmin-support@postgresql.org Subject: RE: [pgadmin-support] cannot access postgresql 7.3 via pgadmin III > -----Original Message----- > From: Amit Sharma [mailto:[EMAIL PROTECTED] > 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
