Thread: rebuilding pg_xlog from base files

rebuilding pg_xlog from base files

From
"W. A. Sanchez"
Date:
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
werestill there and also in the pg_xlog file but i can't see them using psql. Is there a way to fix this like
rebuildingthe 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