Postgres Pro
Downloads
Home   >   mailing lists

pg_upgrade - Mailing list pgsql-admin

From Rainer Leo
Subject pg_upgrade
Date
Msg-id 1862034146.20150622111438@workfile.de
Whole thread Raw
Responses Re: pg_upgrade
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Venkata Balaji N
Date:
Subject: Re: Does VACUUM FULL need ANALYZE ?
Next
From: Jan Lentfer
Date:
Subject: Re: pg_upgrade