From: Scott Whitney <scott@journyx.com>
To: ALEXANDER JOSE <aangelj@hotmail.com>
To: postgres admin <pgsql-admin@postgresql.org>
Subject: Re: Migration Postgresql
Date: Thu, 3 Apr 2014 21:38:54 -0500 (CDT)
Message-ID: <s6iy5f6qusdcm6x284ac14gs.1396579128137@email.android.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
PG9 and upwards all provide a sort of HA with replication available. I would recommend the latest 9.2 (9.2.8 I believe) or the latest 9.3 (if you need the 9.3 features). One advantage of 9.2 is that it's a little older and a little more tried-and-true, BUT THAT IS JUST MY OPINION (before I get flamed). Cascading replication works very nicely. In any event, you will likely want to do the pg_dump/restore dance on a new system with a new cluster rather than an in-place upgrade.
The replication stuff is well-documented and pretty simple.
If you have further questions, either let us know your specifics here, or email me directly, and I would be happy to advise. I danced this dance over 50 times in testing for our 8x -> 9x upgrade and another 20 or so for my SSD migration.
<div>-------- Original message --------</div><div>From: ALEXANDER JOSE <aangelj@hotmail.com> </div><div>Date:04/03/2014 8:28 PM (GMT-06:00) </div><div>To: postgres admin <pgsql-admin@postgresql.org> </div><div>Subject: [ADMIN] Migration Postgresql </div><div>
</div>I would like to help and I'm going to migrate postgresql version 9.0.4 to a higher, 9.3, which is the most stable?
High availability to place 2 postgresql servers, which would be the best settings to provide active active nodes.
alexander
DBA Postgresql
Venezuela
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott@journyx.com, aangelj@hotmail.com
Subject: Re: Migration Postgresql
In-Reply-To: <s6iy5f6qusdcm6x284ac14gs.1396579128137@email.android.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox