From: David F. Skoll <dfs@roaringpenguin.com>
To: pgsql-admin@postgresql.org
Subject: Upgrading to 9.4 to get replication slots (was Re: Streaming replication and WAL archiving)
Date: Wed, 11 Feb 2015 09:45:35 -0500
Message-ID: <20150211094535.5f130601@hydrogen.roaringpenguin.com> (raw)
In-Reply-To: <54DB693A.7010705@gmail.com>
References: <20150210172139.237ffb0b@ollie.roaringpenguin.com>
<CABZWJif7cJ1xFpQaLUifgAGhgxs3=iyKG2p3wyr4BCUs6Krwpg@mail.gmail.com>
<20150211092743.460e6bfe@hydrogen.roaringpenguin.com>
<54DB693A.7010705@gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On Wed, 11 Feb 2015 09:37:46 -0500
John Scalia <jayknowsunix@gmail.com> wrote:
> I've had some issues with pg_upgrade and 9.4. For my test systems, as
> I didn't really have the resources to diagnose what was going on, I
> just used a pg_dumpall to unload the 9.3.3 instance and then just ran
> psql to load the output from pg_dumpall.
Dump/restore is not an option for me. It would mean many hours of
downtime which is unacceptable. I can barely get away with two hours
of downtime and that would have to be in the wee hours of Sunday
morning. People tend to get very cranky when their email stops flowing!
> The more wonderful part of installing different minor versions of
> postgresql, is that most O/S packages put the binaries and the
> default data directories in slightly different areas, so they can
> co-exist, just not necessarily run at the same time without
> specifying different connect ports.
I use Debian and the Debian packages are very good at allowing concurrent
installation of different versions, so that's a plus.
Regards,
David.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: dfs@roaringpenguin.com
Subject: Re: Upgrading to 9.4 to get replication slots (was Re: Streaming replication and WAL archiving)
In-Reply-To: <20150211094535.5f130601@hydrogen.roaringpenguin.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