Date: Wed, 11 Feb 2015 09:45:35 -0500
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)
Message-ID: <20150211094535.5f130601@hydrogen.roaringpenguin.com>
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>
Organization: Roaring Penguin Software Inc.
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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