PgPool Configuration Document required

Started by Jimit Aminalmost 11 years ago5 messagesgeneral
Jump to latest
#1Jimit Amin
jimitamin9@gmail.com

Dear Sir/Mam,

Can I have technical documentation for configuration of PgPool?

#2Melvin Davidson
melvin6925@gmail.com
In reply to: Jimit Amin (#1)
Re: PgPool Configuration Document required

google search works fine for that:

http://pgpool.net/mediawiki/index.php/Documentation

http://www.pgpool.net/mediawiki/images/pgpool-en-3.3.0.pdf

On Tue, Jun 30, 2015 at 12:05 PM, Jimit Amin <jimitamin9@gmail.com> wrote:

Dear Sir/Mam,

Can I have technical documentation for configuration of PgPool?

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.

#3Joshua D. Drake
jd@commandprompt.com
In reply to: Jimit Amin (#1)
Re: PgPool Configuration Document required

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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#4Jimit Amin
jimitamin9@gmail.com
In reply to: Joshua D. Drake (#3)
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@commandprompt.com> wrote:

Show quoted text

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.

#5Joshua D. Drake
jd@commandprompt.com
In reply to: Jimit Amin (#4)
Re: PgPool Configuration Document required

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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general