Re: [GENERAL] configure password

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.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly