Re: Streaming replication and WAL archiving

From: "David F(dot) Skoll" <dfs(at)roaringpenguin(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: Greg Clough <greg(dot)clough(at)cwtdigital(dot)co(dot)uk>
Subject: Re: Streaming replication and WAL archiving
Date: 2015-02-11 14:27:43
Message-ID: 20150211092743.460e6bfe@hydrogen.roaringpenguin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, 11 Feb 2015 09:04:44 +0000
Greg Clough <greg(dot)clough(at)cwtdigital(dot)co(dot)uk> wrote:

> Have you investigated the "Replication Slots" feature that's new in
> 9.4. It sounds like what you want:

Yes, it is exactly what I want... thanks!

Now to plan the upgrade from 9.1 to 9.4... it's not exactly trivial.
The database is about 400GB which is large enough to be unwieldy and it
powers our anti-spam service... that means we can't be down for very
long. :( Time to re-familiarize myself with pg_upgrade...

Regards,

David.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John Scalia 2015-02-11 14:37:46 Re: Streaming replication and WAL archiving
Previous Message Greg Clough 2015-02-11 09:04:44 Re: Streaming replication and WAL archiving