From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | "Gopalan, Narayanasamy" <Narayanasamy(dot)Gopalan(at)hawaiianair(dot)com>, "'pgadmin-support(at)postgresql(dot)org'" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: PGADMIN III - authentication issue |
Date: | 2014-12-31 12:48:24 |
Message-ID: | 54A3F098.4080807@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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(at)iol(dot)ie
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2014-12-31 12:51:42 | Re: Cannot define privileges for login roles |
Previous Message | Raymond O'Donnell | 2014-12-31 12:46:32 | Re: PGADMIN III - authentication issue |