Skip site navigation (1) Skip section navigation (2)

Re: cannot access postgresql 7.3 via pgadmin III

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <amit(dot)sharma(at)wificom(dot)com>, <pgadmin-support(at)postgresql(dot)org>
Subject: Re: cannot access postgresql 7.3 via pgadmin III
Date: 2005-05-24 12:42:48
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E490E076@ratbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support
 

> -----Original Message-----
> From: Amit Sharma [mailto:amit(dot)sharma(at)wificom(dot)com] 
> Sent: 24 May 2005 13:38
> To: Dave Page; pgadmin-support(at)postgresql(dot)org
> Subject: RE: [pgadmin-support] 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.

I have no idea - it's your system :-)

Try setting the password using ALTER USER root WITH PASSWORD 'password';
(http://www.postgresql.org/docs/8.0/interactive/sql-alteruser.html).  My
guess is that no password is currently set, so you cannot login remotely
because one is required.

BTW, you might want to change the password entries in pg_hba.conf to md5
as well - this will prevent plain text passwords being sent over the
wire.

Regards, Dave

pgadmin-support by date

Next:From: owDate: 2005-05-24 14:30:24
Subject: Can't build wxWigets/pgadmin3 on Debian sarge
Previous:From: Amit SharmaDate: 2005-05-24 12:38:23
Subject: Re: cannot access postgresql 7.3 via pgadmin III

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group