pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPITR wrm-standby startup fails
2+ messages / 2 participants
[nested] [flat]
* PITR wrm-standby startup fails
@ 2008-08-25 05:17 Bob Lunney <bob_lunney@yahoo.com>
2008-08-26 10:24 ` Re: PITR wrm-standby startup fails Simon Riggs <simon@2ndQuadrant.com>
0 siblings, 1 reply; 2+ messages in thread
From: Bob Lunney @ 2008-08-25 05:17 UTC (permalink / raw)
To: pgsql-admin
I'm trying to vet the PITR/warm-standby process so set up a primary and secondary server on two different Windows machines. (Yeah, I know, but I don't have a choice in the matter.)
The primary works fine and copies its WAL files to the archive directory. As long as the secondary is in recovery mode life is good. When I introduce the trigger file, however, to kick the secondary out of recovery mode it bombs, complaining that its looking for the next WAL file (which is never going to arrive, especially not in the local pg_xlog directory), then gives me an "invalid parameter" error. The relevent part of the secondary's log file is here:
2008-08-24 23:02:56 CDT LOG: restored log file "000000010000000400000088" from archive
2008-08-24 23:03:01 CDT LOG: restored log file "000000010000000400000089" from archive
2008-08-24 23:03:06 CDT LOG: restored log file "00000001000000040000008A" from archive
2008-08-24 23:07:02 CDT LOG: could not open file "pg_xlog/00000001000000040000008B" (log file 4, segment 139): No such file or directory
2008-08-24 23:07:05 CDT LOG: startup process (PID 1468) was terminated by exception 0xC000000D
2008-08-24 23:07:05 CDT HINT: See C include file "ntstatus.h" for a description of the hexadecimal value.
2008-08-24 23:07:05 CDT LOG: aborting startup due to startup process failure
My recovery command is:
restore_command = '..\bin\pg_standby -d -s 5 -t .\pgsql.trigger.5442 ..\data\archive %f %p %r 2>>pg_log\standby.log'
I found this on the forums. Could it be the source of the problem I'm experiencing?
Thanks in advance for the wizardly advice!
Bob Lunney
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: PITR wrm-standby startup fails
2008-08-25 05:17 PITR wrm-standby startup fails Bob Lunney <bob_lunney@yahoo.com>
@ 2008-08-26 10:24 ` Simon Riggs <simon@2ndQuadrant.com>
0 siblings, 0 replies; 2+ messages in thread
From: Simon Riggs @ 2008-08-26 10:24 UTC (permalink / raw)
To: bob_lunney@yahoo.com; +Cc: pgsql-admin
On Sun, 2008-08-24 at 22:17 -0700, Bob Lunney wrote:
> I'm trying to vet the PITR/warm-standby process so set up a primary
> and secondary server on two different Windows machines. (Yeah, I
> know, but I don't have a choice in the matter.)
>
> The primary works fine and copies its WAL files to the archive
> directory. As long as the secondary is in recovery mode life is good.
> When I introduce the trigger file, however, to kick the secondary out
> of recovery mode it bombs, complaining that its looking for the next
> WAL file (which is never going to arrive, especially not in the local
> pg_xlog directory), then gives me an "invalid parameter" error. The
> relevent part of the secondary's log file is here:
>
> 2008-08-24 23:02:56 CDT LOG: restored log file
> "000000010000000400000088" from archive
> 2008-08-24 23:03:01 CDT LOG: restored log file
> "000000010000000400000089" from archive
> 2008-08-24 23:03:06 CDT LOG: restored log file
> "00000001000000040000008A" from archive
> 2008-08-24 23:07:02 CDT LOG: could not open file
> "pg_xlog/00000001000000040000008B" (log file 4, segment 139): No such
> file or directory
> 2008-08-24 23:07:05 CDT LOG: startup process (PID 1468) was
> terminated by exception 0xC000000D
> 2008-08-24 23:07:05 CDT HINT: See C include file "ntstatus.h" for a
> description of the hexadecimal value.
> 2008-08-24 23:07:05 CDT LOG: aborting startup due to startup process
> failure
>
> My recovery command is:
>
> restore_command = '..\bin\pg_standby -d -s 5
> -t .\pgsql.trigger.5442 ..\data\archive %f %p %r 2>>pg_log
> \standby.log'
>
>
> I found this on the forums. Could it be the source of the problem I'm
> experiencing?
The way you are using this looks correct.
The startup process would not/should not fail in this way and there
should be additional messages between the log entries from 23:03 to
23:07. I don't see any reason for a 4 minute wait at that point,
especially since previous files took 5 seconds. Are you showing us the
whole log?
Please re-run this at DEBUG3 so we can see what else is happening.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-08-26 10:24 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-08-25 05:17 PITR wrm-standby startup fails Bob Lunney <bob_lunney@yahoo.com>
2008-08-26 10:24 ` Simon Riggs <simon@2ndQuadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox