Re: [GENERAL] configure password

From: Douglas McNaught <doug(at)mcnaught.org>
Date: Wed Oct 31 2007 - 11:11:58 EDT

João Paulo Zavanela <joao_zava@globo.com> writes:

> Thanks, but I need configure password to connect to server!
> Now the pg_hba.conf is trust, I need change to passwd.
> Changing the file to passwd, I don't know how configure password to connect!

Set pg_hba.conf to 'trust', connect and use ALTER USER to set the password, then change pg_hba.conf to use 'md5' for your database.

-Doug

---------------------------(end of broadcast)---------------------------

TIP 2: Don't 'kill -9' the postmaster Received on Wed Oct 31 13:09:05 2007