Re: Warm standby (log shipping) from PG 8.3 to 9.3

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