Postgres Pro
Downloads
Home   >   mailing lists

Re: Warm standby (log shipping) from PG 8.3 to 9.3 - Mailing list pgsql-general

From David Wall
Subject Re: Warm standby (log shipping) from PG 8.3 to 9.3
Date
Msg-id 53977011.2050700@computer.org
Whole thread Raw
In response to Re: Warm standby (log shipping) from PG 8.3 to 9.3  (hubert depesz lubaczewski <depesz@gmail.com>)
List pgsql-general
Tree view
On 6/10/2014 11:54 AM, hubert depesz lubaczewski wrote:
On Tue, Jun 10, 2014 at 8:13 PM, David Wall <d.wall@computer.org> wrote:
Is it safe to assume that my working PG 8.3 archive command on the master and recovery.conf (using contrib's pg_standby) on the standby will work the same under 9.3?

Yes, it will work just fine. Of course you can't load 9.3 xlogs into 8.3, or 8.3 xlogs into 9.3, but the commands are the same.

Thanks.  Yes, that makes sense as I'll update both DBs to the same version and we'll likely start with a fresh DB snapshot.

Do you know if there's a way to turn that warm standby into a hot standby (so I can query the standby during its ongoing recovery) easily?  Any docs that show the changes necessary to make that happen, or is that a bigger task?

David

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Warm standby (log shipping) from PG 8.3 to 9.3
Next
From: Brian Dunavant
Date:
Subject: Question about partial functional indexes and the query planner