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(dot)wall(at)computer(dot)org
> <mailto:d(dot)wall(at)computer(dot)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