Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] pg_dump 8.3.3 ERROR: invalid page header in block2264419 of relation "pg_largeobject" - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: [GENERAL] pg_dump 8.3.3 ERROR: invalid page header in block2264419 of relation "pg_largeobject"
Date
Msg-id 20170525071456.xrufev5dbxaqpezl@hermes.hilbert.loc
Whole thread Raw
In response to Re: [GENERAL] pg_dump 8.3.3 ERROR: invalid page header in block 2264419 of relation "pg_largeobject"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
On Wed, May 24, 2017 at 07:18:14PM -0400, Tom Lane wrote:

> If possible, I'd take a physical backup (e.g. with tar) of the entire $PGDATA directory,

Make sure the backup goes directly to a different physical
volume in case the underlying hardware is bad.

Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: Steven Chang
Date:
Subject: Re: [GENERAL] Current best practice for maximum shared_bufferssettings on big hardware?
Next
From: Karsten Hilbert
Date:
Subject: Re: [GENERAL] pg_dump 8.3.3 ERROR: invalid page header in block2264419 of relation "pg_largeobject"