On Wed, 2004-12-29 at 16:11, Tom Lane wrote:
> Scott Marlowe <smarlowe(at)g2switchworks(dot)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.
What's happening is that there are two databases behind pgpool, and each
has managed to assign a different (set of) OID(s) to the table(s). So,
when pg_dump asks for an OID, it gets two different ones.
> > Looking at the SQL that pg_dump sends to be relying on object OIDs for
> > the dump.
> There is nothing wrong with that technique ...
What I'd want is for it to use a join IN the database so that at no time
are OIDs floating across the ether or seen by pg_dump.
In response to
pgsql-general by date
|Next:||From: Ed L.||Date: 2004-12-29 22:25:05|
|Subject: WARNING: group with ID NNN does not exist|
|Previous:||From: Tom Lane||Date: 2004-12-29 22:11:45|
|Subject: Re: pg_dump and pgpool |