Skip site navigation (1) Skip section navigation (2)

Re: configure password

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 (view raw or flat)
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!



In response to

Responses

pgsql-general by date

Next:From: Joao Miguel FerreiraDate: 2007-10-31 12:19:16
Subject: Re: strange message from pg_dumpall
Previous:From: Thomas PundtDate: 2007-10-31 11:52:00
Subject: Re: strange message from pg_dumpall

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group