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