Обсуждение: 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