[Pgpool-general] pg_dump

[Tatsuo Ishii]

> I would like to dump the database through pgpool. I don't find any
> reported issue in the mailing list except some in 2004 and 2005. I do
> not think there will be a problem, and during my first tests, I don't
> notice any problem. But some questions are still there, and could be
> interesting for other people.
> 
> 1. Does pgpool have a special treatment of pg_dump?

No.

> 1.a If load balancing is enabled, are the SELECT commands of pg_dump
> also balanced?

Since pg_dump always starts a transaction, the SELECT commands of
pg_dump are always executed on the master.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> After checking the log in debug mode, I think the answers are "no" and
> "yes". Could someone confirm this?
>
> 2. Are there any known issues with pg_dump with pgpool-II 2.3.1?
> 
> Christophe Philemotte
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general