Re: [PERFORM] PITR Backups

[Dan Gorman]

No, however, I will attach the postgreql.conf so everyone can look at other settings just in case.

postgresql.conf
Description: Binary data

Regards,
Dan Gorman

On Jun 25, 2007, at 10:07 AM, Gregory Stark wrote:

"Simon Riggs" <[EMAIL PROTECTED]> writes:

WARNING: page 28900 of relation 1663/16384/76718 was uninitialized
WARNING: page 28902 of relation 1663/16384/76718 was uninitialized

WARNING: page 26706 of relation 1663/16384/76719 was uninitialized
WARNING: page 26708 of relation 1663/16384/76719 was uninitialized

an unapplied truncation.

Those two are interesting because we appear to have two valid pages in the middle of some uninitialized ones. That implies were not looking at

in the midst of others that are missing.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com

You don't have fsync off do you? That could explain missing pages at the end of a file like this too. And it would explain how you could have two written

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq