Postgres Pro
Downloads
Home   >   mailing lists

Re: configure password - Mailing list pgsql-general

From Douglas McNaught
Subject Re: configure password
Date
Msg-id 87bqafqpxd.fsf@suzuka.mcnaught.org
Whole thread Raw
In response to Re: configure password  (João Paulo Zavanela <joao_zava@globo.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Craig White
Date:
Subject: getting list of tables from command line
Next
From: Thomas Pundt
Date:
Subject: Re: strange message from pg_dumpall