Re: pg_dump and pgpool - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump and pgpool
Date
Msg-id 18170.1104358305@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump and pgpool  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: pg_dump and pgpool  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
Scott Marlowe <smarlowe@g2switchworks.com> writes:
> I've noticed today that if one tries to pg_dump a database cluster
> running under pgpool, one gets the error message:

> pg_dump: query to get table columns failed: ERROR:  kind mismatch
> between backends
> HINT:  check data consistency between master and secondary

I would like to know exactly what pgpool has done to break pg_dump.

> Looking at the SQL that pg_dump sends to be relying on object OIDs for
> the dump.

There is nothing wrong with that technique ...

            regards, tom lane

pgsql-general by date:

Previous
From: Dave Smith
Date:
Subject: Advice on moving rows to history
Next
From: Scott Marlowe
Date:
Subject: Re: pg_dump and pgpool