Problem with pg_dump

From: znahor-news(at)netsync(dot)pl
To: pgsql-general(at)postgresql(dot)org
Subject: Problem with pg_dump
Date: 2007-05-22 14:36:49
Message-ID: Pine.LNX.4.64.0705221636000.2226@vix.netsync.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-05-22 15:08:08 Re: Lock table, Select for update and Serialization error
Previous Message Albe Laurenz 2007-05-22 14:09:30 Re: Lock table, Select for update and Serialization error