[Pgpool-general] Does pgdumpall make writes to the database?

[Tatsuo Ishii]

> Hi! I have stopped pgpool, then gone to backend0, executed a pgdumpall.
> When I started pgpool back, I started register the next error in a exception
> from a JDBC application:
>   org.postgresql.util.PSQLException: ERROR: pgpool detected difference of
> the number of inserted, updated or deleted tuples. Possible last query
> was: " DISCARD ALL"
> In the logs of pgpool I hvae found:
>   Jul 16 14:49:16 vapp1a pgpool: 2009-07-16 14:49:16 ERROR: pid 901: kind
> mismatch among backends. Possible last query was: " DISCARD ALL" kind
> details are: 0[D] 1[C]
> 
> Is it known that pgdumpall would modify data in backend0?
> Thanks!

I would think that it would be possible for pg_dump creates a temp
table. If so, the oid counter would be different among DB nodes.

Can you identify what SQL your application sends to pgpool?
--
Tatsuo Ishii
SRA OSS, Inc. Japan