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

[Tatsuo Ishii]

Hi,

> 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
Japanese:http://www.sraoss.co.jp