pg_upgrade

From: Rainer Leo <leo(at)workfile(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_upgrade
Date: 2015-06-22 09:14:38
Message-ID: 1862034146.20150622111438@workfile.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

we are still using PostgreSQL 9.0.2 on Windows Server.

Now we are migrating to Windows Server 2012 R2 and we
would like to migrate PostgreSQL at the same time to
the current version 9.4.4-1

Which is the best way to migrate the data?

1. pg_dump on the old server
2. pg_retore on the new server
3. pg_upgrade on the new server

Is this correct or is there a "best procedure" to do this?

Regards,
Rainer Leo

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message apogoreliy 2015-06-22 09:44:13 Re: backup software for postgresql
Previous Message Venkata Balaji N 2015-06-22 00:30:57 Re: Does VACUUM FULL need ANALYZE ?