Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-29 Thread Craig McElroy
Teodor: That's great news. Thanks for the followup. Cheers, -craig --- Craig A. McElroy Contegix Beyond Managed Hosting(r) for Your Enterprise On Oct 29, 2007, at 2:29 PM, Teodor Sigaev wrote: Thank you a lot for your report. Bug fixed and fixes are committed in CVS. Thanks for the fo

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-29 Thread Teodor Sigaev
Thank you a lot for your report. Bug fixed and fixes are committed in CVS. Thanks for the followup. We will be upgrading this system to 8.2.5 in the next day or so and will test it on that anyways just to be sure it isn't related. Let me know if there is anything else we can provide to hel

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-26 Thread Teodor Sigaev
Craig McElroy wrote: Teodor: Thanks for the followup. We will be upgrading this system to 8.2.5 in the next day or so and will test it on that anyways just to be sure it isn't related. Let me know if there is anything else we can provide to help track down the bug. We will be keeping th

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-25 Thread Craig McElroy
Teodor: Thanks for the followup. We will be upgrading this system to 8.2.5 in the next day or so and will test it on that anyways just to be sure it isn't related. Let me know if there is anything else we can provide to help track down the bug. We will be keeping this base backup and

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-25 Thread Teodor Sigaev
#0 0x080b8ee0 in entrySplitPage () #1 0x080baccf in ginInsertValue () Corrupted stack? gin_xlog_cleanup() doesn't call ginInsertValue() directly. #2 0x080b81b7 in gin_xlog_cleanup () #3 0x080af4ce in StartupXLOG () #4 0x080c04ca in BootstrapMain () #5 0x08186b2f in StartChildProcess () #6

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-25 Thread Tom Lane
Craig McElroy <[EMAIL PROTECTED]> writes: > Core was generated by `/usr/local/pgsql/bin/postgres -D /pgdata01/data'. > Program terminated with signal 11, Segmentation fault. > #0 0x080b8ee0 in entrySplitPage () > #1 0x080baccf in ginInsertValue () > #2 0x080b81b7 in gin_xlog_cleanup () > #3 0x

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-25 Thread Alvaro Herrera
Craig McElroy wrote: > Alvaro: > I just tried, but I only get "No symbol table info available." after each > line of the trace. Well, we have two possibilities: 1. you send us a complete, reproducible test case, 2. you recompile with debugging enabled (configure --enable-debug) to get a more

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-25 Thread Craig McElroy
Alvaro: I just tried, but I only get "No symbol table info available." after each line of the trace. Cheers, -craig --- Craig A. McElroy Contegix Beyond Managed Hosting(r) for Your Enterprise On Oct 25, 2007, at 7:57 AM, Alvaro Herrera wrote: Craig McElroy wrote: Tom: Thanks for your

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-25 Thread Alvaro Herrera
Craig McElroy wrote: > Tom: > Thanks for your help on this. The trace details are as follows: > > Core was generated by `/usr/local/pgsql/bin/postgres -D /pgdata01/data'. > Program terminated with signal 11, Segmentation fault. > > #0 0x080b8ee0 in entrySplitPage () > #1 0x080baccf in ginInser

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-25 Thread Craig McElroy
Tom: Thanks for your help on this. The trace details are as follows: Core was generated by `/usr/local/pgsql/bin/postgres -D /pgdata01/data'. Program terminated with signal 11, Segmentation fault. #0 0x080b8ee0 in entrySplitPage () #1 0x080baccf in ginInsertValue () #2 0x080b81b7 in gin_xl

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-24 Thread Tom Lane
Craig McElroy <[EMAIL PROTECTED]> writes: >> Can you get a stack trace from the core dump reported here? > Certainly, how can that be obtained? $ gdb /path/to/postgres-executable /path/to/core-file gdb> bt gdb> quit If you don't find a corefile in $PGDATA (or wherever your system puts core fil

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-24 Thread Craig McElroy
Tom: Certainly, how can that be obtained? Cheers, -craig --- Craig McElroy Contegix Beyond Managed Hosting(r) for Your Enterprise On Oct 24, 2007, at 7:12 AM, Tom Lane <[EMAIL PROTECTED]> wrote: Craig McElroy <[EMAIL PROTECTED]> writes: Now, if I include one more WAL file in the recovery,

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-24 Thread Tom Lane
Craig McElroy <[EMAIL PROTECTED]> writes: >Now, if I include one more WAL file in the recovery, ... >> Oct 23 22:22:29 db01b postgres[92]: [ID 748848 local0.info] >> [5706-1] LOG: archive recovery complete >> Oct 23 22:27:06 db01b postgres[91]: [ID 748848 local0.info] [1-1] >> LOG: start

[ADMIN] Problem with PITR Past Particular WAL File

2007-10-24 Thread Craig McElroy
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. Wha