pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpgpool
10+ messages / 7 participants
[nested] [flat]
* pgpool
@ 2006-07-06 04:57 adey <adey11@gmail.com>
0 siblings, 2 replies; 10+ messages in thread
From: adey @ 2006-07-06 04:57 UTC (permalink / raw)
To: pgsql-admin; postgresql-l <postgresql-l@Groups.ittoolbox.com>
Please could someone give me an idea of what pgpool is, and where I can
research it?
I have run a search on postgresql.org and found many references, but they
don't explain what it is, and it doesn't appear in the documentation index
of the v8.1 manuals.
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: pgpool
@ 2006-07-06 12:13 Guido Barosio <gbarosio@gmail.com>
parent: adey <adey11@gmail.com>
1 sibling, 0 replies; 10+ messages in thread
From: Guido Barosio @ 2006-07-06 12:13 UTC (permalink / raw)
To: adey <adey11@gmail.com>; +Cc: pgsql-admin; postgresql-l <postgresql-l@groups.ittoolbox.com>
http://pgpool.projects.postgresql.org/
from the site:
"What is pgpool?
pgpool is a connection pool server for PostgreSQL. pgpool runs between
PostgreSQL's clients(front ends) and servers(back ends). A PostgreSQL
client can connect to pgpool as if it were a standard PostgreSQL
server..."
G.-
On 7/6/06, adey <adey11@gmail.com> wrote:
>
> Please could someone give me an idea of what pgpool is, and where I can
> research it?
> I have run a search on postgresql.org and found many references, but they
> don't explain what it is, and it doesn't appear in the documentation index
> of the v8.1 manuals.
--
Guido Barosio
-----------------------
http://www.globant.com
guido.barosio@globant.com
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: pgpool
@ 2006-07-06 12:42 Christopher Browne <cbbrowne@acm.org>
parent: adey <adey11@gmail.com>
1 sibling, 0 replies; 10+ messages in thread
From: Christopher Browne @ 2006-07-06 12:42 UTC (permalink / raw)
To: pgsql-admin
After a long battle with technology, adey11@gmail.com (adey), an earthling, wrote:
> Please could someone give me an idea of what pgpool is, and where I can research it?
>
> I have run a search on postgresql.org and found many references, but
> they don't explain what it is, and it doesn't appear in the
> documentation index of the v8.1 manuals.
It's not officially part of the database, so no, it's not in the
database documentation.
<http://pgpool.projects.postgresql.org/;
It's a connection pool server implemented in C... The notion is that
you run your database on (say) port 5432, and then put pgpool in
between, on port 4432.
pgpool opens up some fixed number of connections to the database,
keeping them open, and your application connects to port 4432, as if
it were a direct connection to the database.
pgpool then manages the connections, basically keeping them open
irrespective of how your application handles connections.
This can be a big help to performance if your application is pretty
loose about opening and closing connections whenever it likes.
--
(reverse (concatenate 'string "moc.liamg" "@" "enworbbc"))
http://linuxdatabases.info/info/lsf.html
The real problem with the the year 2000 is that there are too many
zero bits and that adversely affects the global bit density.
-- Boyd Roberts <boyd@france3.fr>
^ permalink raw reply [nested|flat] 10+ messages in thread
* pgpool
@ 2011-09-23 07:12 Karuna Karpe <karuna.karpe@os3infotech.com>
0 siblings, 0 replies; 10+ messages in thread
From: Karuna Karpe @ 2011-09-23 07:12 UTC (permalink / raw)
To: pgsql-admin
Hello,
I am run pgpool and then create database bench. After that I run
following command :
pgbench -i -p 9999 bench
But I got following error :
2011-09-23 12:38:11 ERROR: pid 12697: pool_read_kind: kind does not match
between master(53) slot[1] (45)
2011-09-23 12:38:11 ERROR: pid 12697: pool_do_auth: failed to read kind
before BackendKeyData
Connection to database "bench" failed:
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
what can do for remove this error? please give me solution for that?
Regards,
karuna karpe.
^ permalink raw reply [nested|flat] 10+ messages in thread
* pgpool
@ 2018-10-29 19:17 arvind chikne <arvind.chikne@gmail.com>
0 siblings, 1 reply; 10+ messages in thread
From: arvind chikne @ 2018-10-29 19:17 UTC (permalink / raw)
To: pgsql-admin
Can any one suggest how to install pgpool....???
--
*Thanks & Regards*
Arvind rao chikne
9818979986
*Think Green!!!* Please consider your environmental responsibility before
printing this e-mail
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: pgpool
@ 2018-10-29 19:21 Alex Balashov <abalashov@evaristesys.com>
parent: arvind chikne <arvind.chikne@gmail.com>
0 siblings, 1 reply; 10+ messages in thread
From: Alex Balashov @ 2018-10-29 19:21 UTC (permalink / raw)
To: pgsql-admin
Not merely suggest, but extensively intimate:
# yum -y install postgresql-pgpool-II
On Tue, Oct 30, 2018 at 12:47:51AM +0530, arvind chikne wrote:
> Can any one suggest how to install pgpool....???
>
>
>
> --
> *Thanks & Regards*
> Arvind rao chikne
> 9818979986
> *Think Green!!!* Please consider your environmental responsibility before
> printing this e-mail
--
Alex Balashov | Principal | Evariste Systems LLC
Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)
Web: http://www.evaristesys.com/, http://www.csrpswitch.com/
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: pgpool
@ 2018-10-29 19:31 arvind chikne <arvind.chikne@gmail.com>
parent: Alex Balashov <abalashov@evaristesys.com>
0 siblings, 1 reply; 10+ messages in thread
From: arvind chikne @ 2018-10-29 19:31 UTC (permalink / raw)
To: abalashov@evaristesys.com; +Cc: pgsql-admin
Thanks Alex, but can you suggest how to configure it.
On Tue, Oct 30, 2018 at 12:52 AM Alex Balashov <abalashov@evaristesys.com>
wrote:
> Not merely suggest, but extensively intimate:
>
> # yum -y install postgresql-pgpool-II
>
> On Tue, Oct 30, 2018 at 12:47:51AM +0530, arvind chikne wrote:
>
> > Can any one suggest how to install pgpool....???
> >
> >
> >
> > --
> > *Thanks & Regards*
> > Arvind rao chikne
> > 9818979986
> > *Think Green!!!* Please consider your environmental responsibility before
> > printing this e-mail
>
> --
> Alex Balashov | Principal | Evariste Systems LLC
>
> Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)
> Web: http://www.evaristesys.com/, http://www.csrpswitch.com/
>
>
--
*Thanks & Regards*
Arvind rao chikne
9818979986
*Think Green!!!* Please consider your environmental responsibility before
printing this e-mail
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: pgpool
@ 2018-10-29 19:37 Alex Balashov <abalashov@evaristesys.com>
parent: arvind chikne <arvind.chikne@gmail.com>
0 siblings, 1 reply; 10+ messages in thread
From: Alex Balashov @ 2018-10-29 19:37 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
There are many possible suggestions, depending on which of the manifold,
expansive array of things that can be done with it you seek to
accomplish.
On Tue, Oct 30, 2018 at 01:01:38AM +0530, arvind chikne wrote:
> Thanks Alex, but can you suggest how to configure it.
>
> On Tue, Oct 30, 2018 at 12:52 AM Alex Balashov <abalashov@evaristesys.com>
> wrote:
>
> > Not merely suggest, but extensively intimate:
> >
> > # yum -y install postgresql-pgpool-II
> >
> > On Tue, Oct 30, 2018 at 12:47:51AM +0530, arvind chikne wrote:
> >
> > > Can any one suggest how to install pgpool....???
> > >
> > >
> > >
> > > --
> > > *Thanks & Regards*
> > > Arvind rao chikne
> > > 9818979986
> > > *Think Green!!!* Please consider your environmental responsibility before
> > > printing this e-mail
> >
> > --
> > Alex Balashov | Principal | Evariste Systems LLC
> >
> > Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)
> > Web: http://www.evaristesys.com/, http://www.csrpswitch.com/
> >
> >
>
> --
> *Thanks & Regards*
> Arvind rao chikne
> 9818979986
> *Think Green!!!* Please consider your environmental responsibility before
> printing this e-mail
--
Alex Balashov | Principal | Evariste Systems LLC
Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)
Web: http://www.evaristesys.com/, http://www.csrpswitch.com/
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: pgpool
@ 2018-10-29 19:42 arvind chikne <arvind.chikne@gmail.com>
parent: Alex Balashov <abalashov@evaristesys.com>
0 siblings, 1 reply; 10+ messages in thread
From: arvind chikne @ 2018-10-29 19:42 UTC (permalink / raw)
To: abalashov@evaristesys.com; +Cc: pgsql-admin@lists.postgresql.org
I would like to configure it for Hot standby (Auto fail over )
On Tue, Oct 30, 2018 at 1:08 AM Alex Balashov <abalashov@evaristesys.com>
wrote:
> There are many possible suggestions, depending on which of the manifold,
> expansive array of things that can be done with it you seek to
> accomplish.
>
> On Tue, Oct 30, 2018 at 01:01:38AM +0530, arvind chikne wrote:
>
> > Thanks Alex, but can you suggest how to configure it.
> >
> > On Tue, Oct 30, 2018 at 12:52 AM Alex Balashov <
> abalashov@evaristesys.com>
> > wrote:
> >
> > > Not merely suggest, but extensively intimate:
> > >
> > > # yum -y install postgresql-pgpool-II
> > >
> > > On Tue, Oct 30, 2018 at 12:47:51AM +0530, arvind chikne wrote:
> > >
> > > > Can any one suggest how to install pgpool....???
> > > >
> > > >
> > > >
> > > > --
> > > > *Thanks & Regards*
> > > > Arvind rao chikne
> > > > 9818979986
> > > > *Think Green!!!* Please consider your environmental responsibility
> before
> > > > printing this e-mail
> > >
> > > --
> > > Alex Balashov | Principal | Evariste Systems LLC
> > >
> > > Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)
> > > Web: http://www.evaristesys.com/, http://www.csrpswitch.com/
> > >
> > >
> >
> > --
> > *Thanks & Regards*
> > Arvind rao chikne
> > 9818979986
> > *Think Green!!!* Please consider your environmental responsibility before
> > printing this e-mail
>
> --
> Alex Balashov | Principal | Evariste Systems LLC
>
> Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)
> Web: http://www.evaristesys.com/, http://www.csrpswitch.com/
>
>
--
*Thanks & Regards*
Arvind rao chikne
9818979986
*Think Green!!!* Please consider your environmental responsibility before
printing this e-mail
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: pgpool
@ 2018-10-29 19:58 Jehan-Guillaume (ioguix) de Rorthais <ioguix@free.fr>
parent: arvind chikne <arvind.chikne@gmail.com>
0 siblings, 0 replies; 10+ messages in thread
From: Jehan-Guillaume (ioguix) de Rorthais @ 2018-10-29 19:58 UTC (permalink / raw)
To: arvind chikne <arvind.chikne@gmail.com>; +Cc: abalashov@evaristesys.com; pgsql-admin@lists.postgresql.org
On Tue, 30 Oct 2018 01:12:17 +0530
arvind chikne <arvind.chikne@gmail.com> wrote:
> I would like to configure it for Hot standby (Auto fail over )
Unless you have really good reasons, I would not recommend pgpool for auto
failover. Pick another existing project. It might be more or less difficult to
setup, depending on your setup and constraints though.
HA is a long process to have something clean and useful. Take as much time to
implement it as your data deserve.
> On Tue, Oct 30, 2018 at 1:08 AM Alex Balashov <abalashov@evaristesys.com>
> wrote:
>
> > There are many possible suggestions, depending on which of the manifold,
> > expansive array of things that can be done with it you seek to
> > accomplish.
> >
> > On Tue, Oct 30, 2018 at 01:01:38AM +0530, arvind chikne wrote:
> >
> > > Thanks Alex, but can you suggest how to configure it.
> > >
> > > On Tue, Oct 30, 2018 at 12:52 AM Alex Balashov <
> > abalashov@evaristesys.com>
> > > wrote:
> > >
> > > > Not merely suggest, but extensively intimate:
> > > >
> > > > # yum -y install postgresql-pgpool-II
> > > >
> > > > On Tue, Oct 30, 2018 at 12:47:51AM +0530, arvind chikne wrote:
> > > >
> > > > > Can any one suggest how to install pgpool....???
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > *Thanks & Regards*
> > > > > Arvind rao chikne
> > > > > 9818979986
> > > > > *Think Green!!!* Please consider your environmental responsibility
> > before
> > > > > printing this e-mail
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2018-10-29 19:58 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-07-06 04:57 pgpool adey <adey11@gmail.com>
2006-07-06 12:13 ` Guido Barosio <gbarosio@gmail.com>
2006-07-06 12:42 ` Christopher Browne <cbbrowne@acm.org>
2011-09-23 07:12 pgpool Karuna Karpe <karuna.karpe@os3infotech.com>
2018-10-29 19:17 pgpool arvind chikne <arvind.chikne@gmail.com>
2018-10-29 19:21 ` Alex Balashov <abalashov@evaristesys.com>
2018-10-29 19:31 ` arvind chikne <arvind.chikne@gmail.com>
2018-10-29 19:37 ` Alex Balashov <abalashov@evaristesys.com>
2018-10-29 19:42 ` arvind chikne <arvind.chikne@gmail.com>
2018-10-29 19:58 ` Jehan-Guillaume (ioguix) de Rorthais <ioguix@free.fr>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox