Re: Change the postgres user password

How do I check that its set as TRUST?

Cheers
Noel

On Thursday 08 February 2007 12:47, Phillip Smith wrote:
> Assuming you still have TRUST authentication setup on the local server,
> open a psql session as the postgres user (you won't be asked for the
> password under TRUST authentication) to the database and execute the
> command:
>
> ALTER USER Postgres WITH PASSWORD '<newpassword>';
>
> Cheers,
> -p
>
>
> -----Original Message-----
> From: pgsql-novice-owner(at)postgresql(dot)org
> [mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Noel Faux
> Sent: Thursday, 8 February 2007 11:56
> To: pgsql-novice(at)postgresql(dot)org
> Subject: [NOVICE] Change the postgres user password
>
> Hi all,
>
> I set the postgres user's password sometime ago. Now I've forgoten it.
> How
>
> can I reset it?
>
> Cheers,
> Noel

--
Research Assistant / PhD Student
Department of Biochemistry and Molecular Biology
Monash University
Clayton, Victoria
Australia

Ph: +61 3 9905 1418
e-mail: noel(dot)faux(at)med(dot)monash(dot)edu(dot)au
website: http://vbc.med.monash.edu.au/~fauxn