On Jan 18, 2008, at 3:17 PM, Tom Lane wrote:
Erik Jones <erik@xxxxxxxxxx> writes:
I recently started up a server created using PITR (exact detail
below) and received about 125 of these type of errors spanning pages
in about 10 different tables:
2008-01-17 21:47:34 CST 7598 :WARNING: relation "table_name" page
5728 is uninitialized --- fixing
If you do a vacuum on the master, do you get the same warnings?
/me runs VACUUM VERBOSE on the two tables that would matter.
Nope. What worries me is, that since I have a verified case of rsync
thinking it had successfully transferred a WAL, the same may have
happened with these files during the base backup. Does that warning,
in fact, entail that there were catalog entries for those files, but
that the file was not there, and by "fixing" it the server just
created empty files?
Erik Jones
DBA | Emma®
erik@xxxxxxxxxx
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
