Thread: PgPool Configuration Document required

Dear Sir/Mam,

Can I have technical documentation for configuration of PgPool?

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: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.