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 30 Jun 2015 21:52, "Joshua D. Drake" <j...@commandprompt.com> wrote: > > 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. >
