From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | João Paulo Zavanela <joao_zava(at)globo(dot)com> |
Cc: | "T(dot)J(dot) Adami" <adamitj(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: configure password |
Date: | 2007-10-31 14:30:48 |
Message-ID: | dcc563d10710310730k1e5847dm7dbbaab1c2fa2009@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 10/31/07, João Paulo Zavanela <joao_zava(at)globo(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Filip Rembiałkowski | 2007-10-31 14:33:40 | Re: Updated .vim file |
Previous Message | David Fetter | 2007-10-31 14:00:43 | Re: Updated .vim file |