Re: pg_dump and pgpool

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