[ADMIN] PITR wrm-standby startup fails

2008-08-24 Thread Bob Lunney
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 recover

Re: [ADMIN] restoring from dump

2008-08-24 Thread Tena Sakai
Hi Marcelo, > What happened to that clog file? was it deleted? I assume you mean 0088. I think it got created as a result of my executing (and failing) "dropdb" command. Judging from the timestamp, to say otherwise is not plausible. > where is 0086, 0087? I have no idea. We have had a series o

Re: [ADMIN] restoring from dump

2008-08-24 Thread Tena Sakai
Hi Jeff, Quagmire deepens, it seems... I tried: dropdb and it told me: dropdb: database removal failed: ERROR: could not access status of transaction 139602298 DETAIL: Could not open file "pg_clog/0085": No such file or directory. I went into pg_clog directory and issued: ls -lt | he