From: | "W(dot) A(dot) Sanchez" <wasanchez(at)lycos(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | rebuilding pg_xlog from base files |
Date: | 2002-11-07 08:35:22 |
Message-ID: | AEIDBKBHOKAGHBAA@mailcity.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi! We have a java program accessing a postgresql 7.1.3 db through a connection pool. this morning when i checked the db, a number of recent records were missing. however, when i did a search on the pgdata/base files, the recent records were still there and also in the pg_xlog file but i can't see them using psql. Is there a way to fix this like rebuilding the pg_xlog perhaps?
Thanks.
__________________________________________________________
Outgrown your current e-mail service? Get 25MB Storage, POP3 Access,
Advanced Spam protection with LYCOS MAIL PLUS.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus
From | Date | Subject | |
---|---|---|---|
Next Message | Florian Litot | 2002-11-07 09:04:12 | trace |
Previous Message | Achilleus Mantzios | 2002-11-07 07:57:20 | Re: [SQL] Problem: Referential Integrity Constraints lost |