Problem with pg_dump - Mailing list pgsql-general

From znahor-news@netsync.pl
Subject Problem with pg_dump
Date
Msg-id Pine.LNX.4.64.0705221636000.2226@vix.netsync.pl
Whole thread Raw
Responses Re: Problem with pg_dump
Re: Problem with pg_dump
List pgsql-general
Hi!

I've got problem with dumping the database on the slave server.

Situation:

Master:
Running CentOS release 4.4 (Final) with PostgreSQL 8.2.4.

Slave:
Running CentOS release 4.3 (Final) with PostgreSQL 8.2.4 and slon
version 1.2.9

pg_dump on master works fine. On slave i've got error on start of
dumping:

-bash-3.00$ pg_dump -d -D my_database
pg_dump: failed sanity check, parent table OID 225893092 of
pg_rewrite entry OID 225893271 not found

Any ideas to solve this problem?

Best regards,

Piotr Konieczny


pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Lock table, Select for update and Serialization error
Next
From: Richard Huxton
Date:
Subject: Re: Problem with pg_dump