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: (view raw, whole thread or download thread mbox)
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!


In response to


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-2017 The PostgreSQL Global Development Group