Thread: PGADMIN III - authentication issue
<div class="WordSection1"><p class="MsoNormal"><span style="color:#1F497D">Hi,</span><p class="MsoNormal"><span style="color:#1F497D"> </span><pclass="MsoNormal"><span style="color:#1F497D">We are using PostgreSQL, we need to back upthe database and restore onto a different server. We re unable to connect to it because of password issue, the accountis IPS_Admin – Can you please assist on how we can recover the password. The version is 8.1</span><p class="MsoNormal"> <pclass="MsoNormal"><span style="color:#1F497D">Thanks,</span><p class="MsoNormal"><span style="color:#1F497D">Narayan</span><spanstyle="color:#1F497D"></span><p class="MsoNormal"> </div>
On 31/12/2014 10:42, Gopalan, Narayanasamy wrote: > Hi, > > > > We are using PostgreSQL, we need to back up the database and restore > onto a different server. We re unable to connect to it because of > password issue, the account is IPS_Admin – Can you please assist on how > we can recover the password. The version is 8.1 Hello there, First of all, you might have a better response if you post to the main PostgreSQL mailing list - this one is for PgAdmin, the administration tool. Secondly, PostgreSQL 8.1 has been end-of-life for many years; you really should consider upgrading if you can. The current version is 9.4, so there have been eight major versions and dozens of bug-fix versions since then. Having said all that, if you have access to the server, you can simply reset the password for the user: ALTER ROLE username SET PASSWORD TO 'new password'; I hope this helps. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie
On 31/12/2014 12:46, Raymond O'Donnell wrote: > On 31/12/2014 10:42, Gopalan, Narayanasamy wrote: >> Hi, >> >> >> >> We are using PostgreSQL, we need to back up the database and restore >> onto a different server. We re unable to connect to it because of >> password issue, the account is IPS_Admin – Can you please assist on how >> we can recover the password. The version is 8.1 > > Hello there, > > First of all, you might have a better response if you post to the main > PostgreSQL mailing list - this one is for PgAdmin, the administration tool. > > Secondly, PostgreSQL 8.1 has been end-of-life for many years; you really > should consider upgrading if you can. The current version is 9.4, so > there have been eight major versions and dozens of bug-fix versions > since then. > > Having said all that, if you have access to the server, you can simply > reset the password for the user: > > ALTER ROLE username SET PASSWORD TO 'new password'; > Whoops, sorry, just checked the docs[1] and this should be: ALTER ROLE username WITH PASSWORD 'new password'; Ray. [1] http://www.postgresql.org/docs/8.1/static/sql-alterrole.html -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie