Re: configure password

From: Douglas McNaught <doug(at)mcnaught(dot)org>
To: João Paulo Zavanela <joao_zava(at)globo(dot)com>
Cc: "T(dot)J(dot) Adami" <adamitj(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: configure password
Date: 2007-10-31 15:11:58
Message-ID: 87bqafqpxd.fsf@suzuka.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

João Paulo Zavanela <joao_zava(at)globo(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Douglas McNaught 2007-10-31 15:13:23 Re: Securing stored procedures and triggers
Previous Message Andreas Kretschmer 2007-10-31 15:07:15 Re: active connections