Warm standby (log shipping) from PG 8.3 to 9.3

From: David Wall <d(dot)wall(at)computer(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Warm standby (log shipping) from PG 8.3 to 9.3
Date: 2014-06-10 18:13:03
Message-ID: 53974AAF.9090606@computer.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

That is, under PG 8.3, my master server uses:

archive_mode = on
archive_command = '~/postgresql/bin/copyWAL "%p" "%f"'
archive_timeout = 300

(and copyWAL does an SCP to the warm standby's recovery WALs directory)

And my warm standby recovery warm standby uses recovery.conf:

restore_command = '~/postgresql/bin/pg_standby -l -d -t
~/postgresql/recoveryWALs/STOP_RECOVERY ~/postgresql/recoveryWALs %f %p
%r 2>> ~/postgresql/logs/pg_standby.log'

I'm getting ready to do a migration to upgraded versions to 9.3 and
wanted to know if I had to address this concern or whether it should
just work the same as in 8.3. We're not ready to try streaming.

I'll read up on what it means to do hot standby instead of warm
standby. We don't expect to need to use the standby for running queries
from our app, but it would sure be nice, from a comfort level, for
operations to be able to see updates in the standby. Is it really just
as easy as our current warm standby but just adding 'wal_level =
hot_standby' to the master's postgresql.conf ? Is there anything I can
read about moving from 8.3 warm standby to 9.3 hot standby?

It's a bit confusing because of the various options for standby mode.
Would it be better to use the new standby setup instead of pg_standby?

Thanks,
David

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2014-06-10 18:54:35 Re: Warm standby (log shipping) from PG 8.3 to 9.3
Previous Message Sandeep Gupta 2014-06-10 17:25:58 Re: slow query question: more indexes considered harmful