From: Sébastien WACHTER <sebastien.wachter@netasq.com>
To: pgsql-admin@postgresql.org
Cc: nicolas treels <nicolas.treels@netasq.com>
Subject: error with pgdump
Date: Thu, 14 Oct 2010 11:13:09 +0200
Message-ID: <4CB6C9A5.8070908@netasq.com> (raw)
hi all
im new user with posgres , we use a sofware solution based on postgres
sql to store database.
when i want dump database for backup
pg_dump -h localhost -b -Fc -U applicationdbuser application -f fichier.dmp
after a few time i have this error
EERROR: *invalid* page *header* in block 10 of relation "pg_toast_16610"
have you an idea to fix it ?
i have try to reindex , when i search on google or forum i have see this
solution for same case
with command
reindex index pg_toast.pg_toast_16610;
but i have this error
relation "pg_toast.pg_toast_16610" d'ont exist
thanks a lot
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sebastien.wachter@netasq.com, nicolas.treels@netasq.com
Subject: Re: error with pgdump
In-Reply-To: <4CB6C9A5.8070908@netasq.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox