Re: Change the postgres user password
От | Phillip Smith |
---|---|
Тема | Re: Change the postgres user password |
Дата | |
Msg-id | 006201c74b23$17cce130$9b0014ac@wbaus090 обсуждение исходный текст |
Ответ на | Change the postgres user password (Noel Faux <noel.faux@med.monash.edu.au>) |
Ответы |
Re: Change the postgres user password
|
Список | pgsql-novice |
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@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Noel Faux Sent: Thursday, 8 February 2007 11:56 To: pgsql-novice@postgresql.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.faux@med.monash.edu.au website: http://vbc.med.monash.edu.au/~fauxn ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings *******************Confidentiality and Privilege Notice******************* The material contained in this message is privileged and confidential to the addressee. If you are not the addressee indicated in this message or responsible for delivery of the message to such person, you may not copy or deliver this message to anyone, and you should destroy it and kindly notify the sender by reply email. Information in this message that does not relate to the official business of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta. Weatherbeeta, its employees, contractors or associates shall not be liable for direct, indirect or consequential loss arising from transmission of this message or any attachments
В списке pgsql-novice по дате отправления: