Re: Default password

On Wed, May 6, 2009 at 11:30 AM, calibration <calibration(at)cargolux(dot)com>wrote:

> Dear Support,
> We have Postgresql 8.1
> It is the default database installed with our temperature datalogger
> LogWareIII from Hart Scientific.
>
> I have some troubles with this software and I have tried to enter in the
> PostgreSQL software. I have launch the application pgadminIII but it
> requests a Password. I have never installed a password so I think it's the
> default password. Could you please give me this information?
>
>

Your problem is not pgAdmin related which is what this list is about.
Anyway, Postgres doesn't have a default password. If your database runs on a
Linux server as root you can su to postgres user and then use psql to
connect to the database. Once connected you can change postgres password to
whatever you like in order to be able to login through pgAdmin.

ALTER USER postgres WITH PASSWORD = 'mysecretpass';

On Windows servers the postgres user password is required upon installing.
When lost it isn't recoverable.
Nevertheless there is a little trick to gain access to the database:

Modify file pg_hba.conf and add or change the line:
host all all 127.0.0.1/32 trust

Restart the postgres service and now login with psql or pgAdmin with user
postgres. None or any password will do as it will not be checked.
After changing the password modify again the line in pg_hba.conf to:
host all all 127.0.0.1/32 md5

Restart the postgres service and you are back on track.... hopefully.

Regards,
Fernando.