From: | "Merlin Moncure" <mmoncure(at)gmail(dot)com> |
---|---|
To: | "Simon Riggs" <simon(at)2ndquadrant(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | pg_standby testing notes |
Date: | 2007-01-11 19:20:08 |
Message-ID: | b42b73150701111120l532fe779s88cc2be0e4115b7d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am looking into using pg_standby (v3) in a warm standby system. I'm
going to double check it, but same machine replication seemed to work
ok. When I tried to do remote server log shipping however, I had some
issues.
Initial setup and launch is working ok, my archive command is:
'test ! -f /var/lib/pgsql/pitr/%f && cp %p /var/lib/pgsql/pitr/%f'
my restore command is:
pg_standby -m -t/raid/pitr/kill /raid/pitr %f %p
'/raid/pitr' is an nfs mount mounted from the primary to the standby.
I suspect the problem lies there, but I thought I'd ask. here is my
log on the standby following a fresh pitr load:
2007-01-11 07:40:37 EST : LOG: automatic recovery in progress
2007-01-11 07:40:37 EST : LOG: redo starts at 0/630000B0
2007-01-11 07:41:37 EST : LOG: restored log file
"000000010000000000000064" from archive
2007-01-11 07:41:38 EST : LOG: restored log file
"000000010000000000000065" from archive
2007-01-11 07:41:38 EST : LOG: restored log file
"000000010000000000000066" from archive
2007-01-11 07:51:44 EST : LOG: could not open file
"pg_xlog/000000010000000000000067" (log file 0, segment 103): No such
file or directory
2007-01-11 07:51:44 EST : LOG: redo done at 0/66FFFFC8
2007-01-11 08:01:49 EST : PANIC: could not open file
"pg_xlog/000000010000000000000066" (log file 0, segment 102): No such
file or directory
neither the primary or the standby are in production...the 3 restored
files were from me manufacturing work on the primary to generate
files. Is there anything obvious I should be checking?
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2007-01-11 19:20:25 | Re: ORDER BY col is NULL in UNION causes error? |
Previous Message | Marcus Engene | 2007-01-11 19:07:29 | generate_series with month intervals |