From: | João Paulo Zavanela <joao_zava(at)globo(dot)com> |
---|---|
To: | "T(dot)J(dot) Adami" <adamitj(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: configure password |
Date: | 2007-10-31 11:56:12 |
Message-ID: | 47276A4300001FF7@mail04.sc2.he.tucows.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>> Hi,
>>
>> How I configure password to postgres user in Linux?
>> I'm using trust, but I needing configure password in database.
>>
>> Thanks!
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 9: In versions below 8.0, the planner will ignore your desire to
>> choose an index scan if your joining column's datatypes do not
>> match
>
>For database roles, you can change the password by ALTER ROLE command.
>For example, change the pwd for user postgres to 123 :
>
>ALTER ROLE postgres PASSWORD '123';
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!
Thanks!
From | Date | Subject | |
---|---|---|---|
Next Message | Joao Miguel Ferreira | 2007-10-31 12:19:16 | Re: strange message from pg_dumpall |
Previous Message | Thomas Pundt | 2007-10-31 11:52:00 | Re: strange message from pg_dumpall |