rebuilding pg_xlog from base files

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

Browse pgsql-general by date

  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