> -Original Message-
> From: pgpool-general-boun...@pgfoundry.org [mailto:pgpool-general-
> boun...@pgfoundry.org] On Behalf Of Guillaume Lelarge
> Sent: Friday, August 19, 2011 9:30 AM
> To: Johnny Tan
> Cc: pgpool-general@pgfoundry.org
> Subject: Re: [Pgpool-general] connections not poo
Tatsuo Ishii writes:
>
> After recovering old primary(5432) can you connect to pgpool without
> problem? Then this is normal. Pgpool needs to restart all child
> process after recovery.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://w
es postgres 74 2010-06-15 07:19 0003.history
drwx-- 2 postgres postgres 4096 2010-06-15 07:29 archive_status
I can post full scripts, but don't want to swamp the mailing list if
there's no need.
Thanks for any advice.
Mark...
.html
So maybe everything is fine as it is. Any reassuring comments or
pointers of what to look at would be welcome.
Mark...
---postgresql.log---
2010-06-15 07:19:32 UTC LOG: incomplete startup packet
2010-06-15 07:19:32 UTC FATAL: the database system is starting up
rsync: link_stat &
question to ask given the
pgpool-II version used in the tutorial. If I know the tutorial works,
then any errors will be down to me. And I'd prefer to use the current
build and not 2.1.
Thanks, and no offense meant to Gerd,
Mark...
___
Pgpool-general
On Fri, Oct 9, 2009 at 12:06 PM, Jaume Sabater wrote:
> On Fri, Oct 9, 2009 at 3:41 PM, Mark wrote:
>
> >> Once the maximum configured number of connections is reached, it will
> >> start reusing them. What else would you expect?
> >>
> > Well, I expected
On Fri, Oct 9, 2009 at 1:46 AM, Jaume Sabater wrote:
> On Fri, Oct 9, 2009 at 5:44 AM, Mark wrote:
>
> > However, when I start one connection with psql, I see a pgpool and a
> > postgresql process for that connection. I leave that one open and start
> a
> > new con
On Thu, Oct 8, 2009 at 10:47 PM, Josh Berkus wrote:
>
> > However, when I start one connection with psql, I see a pgpool and a
> > postgresql process for that connection. I leave that one open and start
> > a new connection in the same way and now there are two pgpool processes
> > and two postg
ses with the same properties. How is that reusing
anything?
--
Mark
"Blessed is he who finds happiness in his own foolishness, for he will
always be happy."
___
Pgpool-general mailing list
Pgpool-general@pgfoundry.org
http://pgfoundry.org/m
Is
> > there a way to configure pgpool so that certain queries never hit the
> > master?
>
> At this point, no. However I'm curious why you need the
> functionality. And how do you specify "certain query"?
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
>
that certain queries never hit the
master?
--
- Mark Plutowski
___
Pgpool-general mailing list
Pgpool-general@pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general
ord = 'password'
>
> backend_hostname0 = 'backend0.local'
> backend_port0 = 5432
> backend_weight0 = 1
>
> backend_hostname1 = 'backend1.local'
> backend_port1 = 5432
> backend_weight1 = 1
>
> enable_pool_hba = false
> ___
> > [...]
> > checking for pg_config... /usr/share/postgresql-common/t/140_pg_config.t
> > ./configure: line 21942: pg_config: command not found
> > ./configure: line 21943: pg_config: command not found
> > checking for PQexecPrepared in -lpq... no
> > configure: erro
Hello,
We are having a problem with pgpool-II version 1.1.1(amiboshi),. We set up
PGPool to load balance all requests between slave and master database. We
verified the load balance is working by creating a table called 'LARRY'. On
server1 we inserted a value of 50. On server2 we inserted
14 matches
Mail list logo