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