On Tuesday 13 May 2008 12:48:38 Guillaume Lelarge wrote:
> Alvaro Herrera a écrit :
> > someone wrote:
> Can I shutdown Server B (backup/recovery postmaster) simply by
> killing the postmaster and restart it back in recovery mode to
> continue re-syncing where it left off? Or does s
Alvaro Herrera a écrit :
someone wrote:
Can I shutdown Server B (backup/recovery postmaster) simply by
killing the postmaster and restart it back in recovery mode to
continue re-syncing where it left off? Or does stopping Server B
while in recovery mode require any manual re-sync steps be
David Wall <[EMAIL PROTECTED]> writes:
>> IIRC, it works conveniently in 8.2 and up. Just do pg_ctl stop -m fast.
> Thanks, Tom. What about if the postmaster is just killed (kill pid, or
> kill -9 pid) or the server/OS crashes? Will PG 8.3 in recovery mode be
> able to come back up okay and r
Thanks, Guillaume. Can anyone confirm his answer to the question below
about restarting the backup postmaster?
IIRC, it works conveniently in 8.2 and up. Just do pg_ctl stop -m fast.
Thanks, Tom. What about if the postmaster is just killed (kill pid, or
kill -9 pid) or the serve
David Wall <[EMAIL PROTECTED]> writes:
> Thanks, Guillaume. Can anyone confirm his answer to the question below
> about restarting the backup postmaster?
IIRC, it works conveniently in 8.2 and up. Just do pg_ctl stop -m fast.
regards, tom lane
--
Sent via pgsql-gener
someone wrote:
>>> Can I shutdown Server B (backup/recovery postmaster) simply by
>>> killing the postmaster and restart it back in recovery mode to
>>> continue re-syncing where it left off? Or does stopping Server B
>>> while in recovery mode require any manual re-sync steps before it can
Thanks, Guillaume. Can anyone confirm his answer to the question below
about restarting the backup postmaster?
It seems counter-intuitive since the backup server is only waiting for
new WAL files to restore, it would seem it could be killed and restarted
at any time and it should just recover
David Wall a écrit :
[...]
During regular operations, Server A and Server B may independently need
to be rebooted or postgresql restarted, etc. Is there any sync-ing
between Server A and Server B I have to worry about when doing this?
That is, will Server B need to know anything about the fact
Just wanted to see if others would confirm my impressions about running
WAL archiving and pg_standby restore.
Server A (Primary): Runs PG 8.3 with WAL archiving enabled. Each WAL is
copied over the network to Server B. (A previous 'tar backup' of the
database along with the requisite psql co
