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

David Wall <d.wall@xxxxxxxxxxxx> · Tue, 10 Jun 2014 13:52:33 -0700



    On 6/10/2014 11:54 AM, hubert depesz lubaczewski wrote:

    
          On Tue, Jun 10, 2014 at 8:13 PM,
            David Wall <d.wall@xxxxxxxxxxxx>
            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