From: | Noel Faux <noel(dot)faux(at)med(dot)monash(dot)edu(dot)au> |
---|---|
To: | Phillip Smith <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Change the postgres user password |
Date: | 2007-02-08 02:10:28 |
Message-ID: | 200702081310.28476.noel.faux@med.monash.edu.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andrej Ricnik-Bay | 2007-02-08 02:14:37 | Re: Change the postgres user password |
Previous Message | Phillip Smith | 2007-02-08 01:47:29 | Re: Change the postgres user password |