configure password

On 31 out, 07:33, joao_z...@globo.com (Jo�o Paulo Zavanela) wrote:

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';

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!

On 10/31/07, João Paulo Zavanela <joao_zava@globo.com> wrote:

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!

First, connect with the pg_hba.conf set to trust. change the
password. then change the pg_hba.conf to md5 / password.

Note that if you're talking about a unix/linux type account that's a
whole nother kettle of fish.

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