[pgpool-general: 8119] Re: Sync tables oid between multiple piggy pools

Tatsuo Ishii ishii at sraoss.co.jp
Tue May 3 21:31:28 JST 2022


> In case I am using multiple piggy pools with central memcached. How piggy
> pools share the table oids which stored on specific piggy pool?

Assuming all the pgpool processes are forked off by the same pgpool
parent process, they share the table oids under
log/pgpool/oiddir/<database oid>/<table oid>.

See the source code comment for pool_get_database_oid().

Best reagards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

More information about the pgpool-general mailing list