Re: PgPool Configuration Document required

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" <jd(at)commandprompt(dot)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.
>