| Greetings: I am running into a problem during a failover recover of a particular 8.2.4 database running on SunOS 5.10 box. For complete divulgence of information, I am also using the pg_standby utility from the 8.3 contribs to handle the replay of the logs on the standby server. What I am finding, is that if I only allow it to replay up to a particular WAL file (specifically, 00000001000000180000008A), I am able to trigger the system to change out of recovery mode and it successfully comes online in a bit as expected. I also tried stopping it at each of a few prior WAL files and experienced the same results. Relevant log lines are as follows:
Now, if I include one more WAL file in the recovery, the additional WAL file appears to be successfully restored, but when triggering the system to come out of recovery mode it fails to fully come online and proceeds to shutdown a few minutes later. I also tried stopping it after each of a few additional WAL files and experienced the same results. Relevant log lines are as follows:
I checked the original server logs around the times that these WAL files were originally archived, but could find no problems being reported. Note that for the sake of absolute consistency, all of my tests were done against a pristine restored base backup. If any of this doesn't make sense, please let me know and I will do my best to explain myself better. I have been banging my head against this for many hours so it is certainly possible that I may, unbeknownst to myself, be a bit incoherent at this point. Any suggestions? Thanks. Cheers, -craig --- Craig A. McElroy Contegix Beyond Managed Hosting(r) for Your Enterprise |
