Обсуждение: PgPool Configuration Document required
Dear Sir/Mam,
Can I have technical documentation for configuration of PgPool?
http://pgpool.net/mediawiki/index.php/Documentation
http://www.pgpool.net/mediawiki/images/pgpool-en-3.3.0.pdf
Dear Sir/Mam,
Can I have technical documentation for configuration of PgPool?
--
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
![](http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif)
On 06/30/2015 09:05 AM, Jimit Amin wrote: > Dear Sir/Mam, > > Can I have technical documentation for configuration of PgPool? > http://www.pgpool.net/mediawiki/index.php/Main_Page -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack support, consulting and development. Announcing "I'm offended" is basically telling the world you can't control your own emotions, so everyone else should do it for you.
Dear Sir,
Sorry for this type of question, I have already configured PgPool but facing 3 issue. That's why I thought that I may have done wrong setup.
Issue faced
I have streaming replication setup 1 master and 1 read-only server and PgPool
1. I have already mentioned nextval in blacklistfunction but sometime PgPool fires nextval on read-only server. I have log file.
2. I am not able to see modified data updated by same transaction because
Begin;
Update .... ; --- master server
Select that data ... ; --- I am not able to see updated data by previous update because this select executed on read-only server
3. From application I am executing one procedure which returns cursor..
I am getting error like "unnamed portal " dose not exists, while checking log I got to know that exec procedure done on read-only slave server and fetch all in "unnamed portal " executed on slave server.
Thanks,
Jimit Amin
On 06/30/2015 09:05 AM, Jimit Amin wrote:Dear Sir/Mam,
Can I have technical documentation for configuration of PgPool?
http://www.pgpool.net/mediawiki/index.php/Main_Page
--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.
On 06/30/2015 09:35 AM, Jimit Amin wrote: > Dear Sir, > > Sorry for this type of question, I have already configured PgPool but > facing 3 issue. That's why I thought that I may have done wrong setup. > I would suggest the pgpool mailing lists. JD -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack support, consulting and development. Announcing "I'm offended" is basically telling the world you can't control your own emotions, so everyone else should do it for you.