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-08 00:40:23
Message-ID: ELMPBHNGIEFJHBAA@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 Stephane Tessier 2002-11-08 01:03:07 Re: table growing
Previous Message scott.marlowe 2002-11-08 00:31:12 Re: Hardware estimation