Hi people,
We have a setup using Slony-I that currently consists of 1 origin server with 2
subscribers. I'd like to use pgpool to manage connections in Master/Slave
Mode, however looking at the docs (http://pgpool.projects.postgresql.org/)
theres not that much info on this.
The docs state:
master_backend_hostname is a directive name for pgpool(I).
I strongly
recommend to use pgpool-II.
Hi Tatsuo,
I can see now that I clicked the link to download pgpoolII then downloaded
pgpoolI by mistake.
Thanks for all the help.
Glyn
Send instant messages to your online friends
Is there a way to make it throw SELECTS only to the
slave/s.
backend_weight0 = 0
should do what you want.
I'm still confused about the md5 passwords in master/slave mode?
With just a normal pool everything is okay, however I get a message saying md5
is not supported in master/slave
--- On Thu, 11/9/08, Tatsuo Ishii [EMAIL PROTECTED] wrote:
In summary, it's an expected behavior.
Thanks.
___
Pgpool-general mailing list
Pgpool-general@pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general
Is it ok to have a pgpool controller running on a 32
bit machine
connecting to 64 bit hosts? This is for a
replicating/load balanced
pool. Are there any drawbacks?
I personally haven't tried yet, but think there should
be no
problem. Please let me know if you find something goes
Hi Chaps,
I'm about to setup a new connection pool server so I'm doing a little testing
with the latest betas. Good work btw.
So far everything is fine however I've hit a little niggle whilst playing with
pgpoolAdmin (I've never bothered with it before).
To get any kind of status it appears
, and works fine. I don't use system_db, so I
don't need a user
for it. It's a matter of having the users in the
backend engines, that's
all.
Daniel
-Original Message-
From: pgpool-general-boun...@pgfoundry.org
[mailto:pgpool-general-boun...@pgfoundry.org] On
Behalf Of Glyn Astill
Hi Tatsuo,
I'm using pgpool 2.2 in connection pool mode, and I see a similar problem with
the deallocate errors. I appear to get a deallocate error for every prepared
statement that the a particular client made. I've not done a thorough
investigation here however it appears to only be for
connecting afterwards would use 'ABORT; RESET ALL; SET SESSION
AUTHORIZATION DEFAULT' ?
--- On Thu, 26/3/09, Glyn Astill glynast...@yahoo.co.uk wrote:
From: Glyn Astill glynast...@yahoo.co.uk
Subject: Re: [Pgpool-general] Error in pgpool
To: nimesh.sa...@gmail.com, Tatsuo Ishii is...@sraoss.co.jp
Hi Tatsuo,
Great, I assumed some sort of internal table of prepared statements wasn't
getting cleared out. When you said it was expected behavior it confused me.
I'm trying to patch against the pgpool-II-2.2 source, either I'm either too
much of a cretin to apply it or pool_proto_modules.c
--- On Fri, 3/4/09, Tatsuo Ishii is...@sraoss.co.jp wrote:
I'm trying to patch against the pgpool-II-2.2
source, either I'm either too much of a cretin to apply
it or pool_proto_modules.c has other changes?
The patch was against CVS HEAD. Could you try included new
patch? It
was
From: Nimesh Satam nimesh.sa...@gmail.com
Subject: [Pgpool-general] Help in pgpool loadbalancing
To: pgpool-general@pgfoundry.org
Date: Sunday, 19 July, 2009, 4:04 PM
Hi,
Can anybody highlight how queries can be loadbalanced
in pgpool? How does backend_weight0 means and what happens
if
Hi Chaps,
We currently use pgpool-II purely as a pool/proxy, and one thing I did notice
when we first moved to 2.2.2 was that I'd get a segfault in pgpool if I took
down the postgres server it was connected to. I'm pretty sure it didn't happen
back in 2.1 (my memory of of going from 2.2,
Hi Chaps,
I've just had an odd occourance using 2.2.3. I had a pgpool backend that
appeared to be stuck in an infinite loop sending dealocate statements to the
postgres server, it was iniing the load avg up to 30 and I had to kill -9 the
pgpool backend to stop it.
The client was long gone so
--- On Wed, 23/9/09, Tatsuo Ishii is...@sraoss.co.jp wrote:
Hi
We applied the patch with the same result. After some
seconds child
processes go into DEALLOCATE state until pgpool gets
completly hang.
root
592 569 4 23:31
? 00:00:57 pgpool: sess
sess
--- On Wed, 23/9/09, Tatsuo Ishii is...@sraoss.co.jp wrote:
snip
Ok, I think for some reason DEALLOCATE fails and the
internal list
which manages prepared objects is not updated, and same
request is
issued over and over again. I need to know why DEALLOCATE
fails, but
at least we should
Hi chaps,
When we get an authentication in pgpool 2.2.5 we get a server closed the
connection unexpectedly error rather than the usual authentication error.
Is this intended behaviour or is it a bug? I seem to vaguely recall reading a
thread about it before ...
Glyn
--- On Sun, 1/11/09, Tatsuo Ishii is...@sraoss.co.jp wrote:
Ok, this is normal. Though there's a room to enhance so
that pgpool
replies with auth error message...
Patches are welcome:-)
How about this?
Glyn
diff -ru pgpool-II-2.2.5/pool_auth.c pgpool-II-2.2.5p/pool_auth.c
---
--- On Tue, 24/11/09, Aleksey Tsalolikhin atsaloli.t...@gmail.com wrote:
From: Aleksey Tsalolikhin atsaloli.t...@gmail.com
Subject: [Pgpool-general] pgpool-II 2.2.5 slamming the CPU
To: pgpool-general@pgfoundry.org
Date: Tuesday, 24 November, 2009, 0:26
Hi. We have our pgpool-II
--- On Wed, 25/11/09, Denis Gasparin de...@edistar.com wrote:
We have the problems with 2.6.16 and
2.6.18 kernels...
I'm not sure it is a kernel related problem...
Good, well I guess we can rule that out then.
___
Pgpool-general mailing
Hi people,
Bar the usual bison ones, I've noticed the list of compile time warnings
getting lager in later pgpool ii versions (i.e. 2.2.6 and 2.3.1) are these
known and acknowledged as ok to ignore, or is it just me?
http://privatepaste.com/706c465f36
Thanks
Glyn
, but I guess some
compilers might not be showing them...
http://privatepaste.com/2da30bdf07
--- On Thu, 14/1/10, Xavier Noguer xnog...@antica.cl wrote:
From: Xavier Noguer xnog...@antica.cl
Subject: Re: [Pgpool-general] Warnings in later pgpool-II versions
To: Glyn Astill glynast
Ah, I see.
--- On Wed, 10/3/10, Cesar Martin cmart...@gmail.com wrote:
From: Cesar Martin cmart...@gmail.com
Subject: Re: [Pgpool-general] Multi-statement queries
To: Glyn Astill glynast...@yahoo.co.uk
Cc: Matthias Tief matth...@itso-berlin.de, pgpool-general@pgfoundry.org,
daniel.cre...@l
Hi Guys,
We're using pgpool-II 2.3.3 purely as a connection pool to postgres 8.4,
however if any one of the connections are closed via pg_terminate_backend in
postgres 8.4 then pgpool attempts to fail over to a nonexistant node? See
logging below.
Also how do we log when pgpool is run as a
Hi Tatsuo,
My conf file is as follows (I've removed comments etc for clarity)
listen_addresses = '*'
port = 5432
pcp_port = 9898
socket_dir = '/tmp'
pcp_socket_dir = '/tmp'
backend_socket_dir = '/tmp'
pcp_timeout = 10
num_init_children = 600
max_pool = 1
child_life_time = 300
Surely this depends on what order you have the schemas detailed in the
search_path variable.
--- On Fri, 6/8/10, Marcin Kwiatkowski marc...@gmail.com wrote:
From: Marcin Kwiatkowski marc...@gmail.com
Subject: [Pgpool-general] Problem with tables with same name
To:
--- On Thu, 12/8/10, Josh Berkus j...@agliodbs.com wrote:
Does anyone here combine pgpool and
pgbouncer?
If so, what order do you chain them in ... pgpool, then
multiple
pgbouncer pools, or pgbouncer in front of pgpool? And
why?
I'm thinking that pgbouncer in front of pgpool makes
Hi all,
Just upgrading one of our pgpool instances to 3.0.1, however I'm seeing the
following error in the logs on startup:
pid 23752: pool_init_pool_passwd: couldn't open /usr/local/etc/pool_passwd.
reason: Permission denied
If I then connect in from a client then the backend segfaults.
Can I get the stable branch from cvs?
I'm currently checking out pgpool-II from
anonym...@cvs.pgfoundry.org:/cvsroot/pgpool
--- On Thu, 6/1/11, Tatsuo Ishii is...@sraoss.co.jp wrote:
From: Tatsuo Ishii is...@sraoss.co.jp
Subject: Re: [Pgpool-general] 3.0.1 and pool_passwd
To:
--- On Fri, 7/1/11, Tatsuo Ishii is...@sraoss.co.jp wrote:
Yes.
cvs -d :pserver:anonym...@cvs.pgfoundry.org:/cvsroot/pgpool
checkout -r V3_0_STABLE pgpool-II
Right, got it now, thanks Tatsuo.
The previous error with the pool_passwd appears to have gone on startup, but it
still appears when
--- On Tue, 11/1/11, Tatsuo Ishii is...@sraoss.co.jp wrote:
The previous error with the
pool_passwd appears to have gone on startup, but it still
appears when the server is stopped.
Can you please explain more detail?
When I stop pgpool-II I get the following message:
2011-01-11
--- On Tue, 11/1/11, Tatsuo Ishii is...@sraoss.co.jp wrote:
Oops. It seems same unportability regarding dirname(3) as
main.c is in
pg_md5.c. Can you please try including patches?
Hmm, still the same message with the patched md5.c
2011-01-11 10:57:46 ERROR: pid 5831: pool_init_pool_passwd:
Any luck with this?
--- On Tue, 11/1/11, Glyn Astill glynast...@yahoo.co.uk wrote:
From: Glyn Astill glynast...@yahoo.co.uk
Subject: Re: [Pgpool-general] pool_add_prepared_statement: prepared statement
already exists
To: Toshihiro Kitagawa kitag...@sraoss.co.jp
Cc: pgpool-general
Any news on this guys?
--- On Thu, 13/1/11, Glyn Astill glynast...@yahoo.co.uk wrote:
To: Toshihiro Kitagawa kitag...@sraoss.co.jp
Cc: pgpool-general@pgfoundry.org
Date: Thursday, 13 January, 2011, 9:42
--- On Thu, 13/1/11, Toshihiro
Kitagawa kitag...@sraoss.co.jp
wrote:
Glyn Astill
already exists
To: Glyn Astill glynast...@yahoo.co.uk
Cc: pgpool-general@pgfoundry.org
Date: Tuesday, 18 January, 2011, 1:49
On Mon, 17 Jan 2011 11:59:13 +
(GMT)
Glyn Astill glynast...@yahoo.co.uk
wrote:
Any news on this guys?
Hi Glyn,
I am sorry for late reply.
I am testing a patch
On Thu, 20 Jan 2011 09:07:04 + (GMT)
Glyn Astill glynast...@yahoo.co.uk
wrote:
Hi Toshihiro,
How did you get on with this? Is there anything I can
provide to help?
Glyn
--- On Tue, 18/1/11, Toshihiro Kitagawa kitag...@sraoss.co.jp
wrote:
From: Toshihiro Kitagawa kitag
Hi Guys,
Yesterday I deployed 3.0.1 to one of our connection pool servers, however the
machine appears to have crashed after running out of memory.
I've just run a simple test here, with pgpool in raw mode. All I've done is
write a program to connect, prepare, execute and deallocate a
From: TakehiroWada takehiro.w...@gmail.com
To: Glyn Astill glynast...@yahoo.co.uk
Cc: pgpool-general@pgfoundry.org pgpool-general@pgfoundry.org
Sent: Thursday, 18 August 2011, 16:27
Subject: Re: [Pgpool-general] 3.0.1 memory leaks?
Hi Glyn
the similar issue occurs pgpool(3.0.1
is elsewhere.
Glyn
From: takizo paul...@takizo.com
To: Glyn Astill glynast...@yahoo.co.uk
Cc: pgpool-general@pgfoundry.org pgpool-general@pgfoundry.org
Sent: Thursday, 8 September 2011, 1:48
Subject: Re: [Pgpool-general] Pgpool I vs Pgpool II
Gyln,
Thanks. I
Hi Toshihiro,
I can confirm that patch works and we no longer see the memory leak.
Thanks
Glyn
- Original Message -
From: Toshihiro Kitagawa kitag...@sraoss.co.jp
To: Glyn Astill glynast...@yahoo.co.uk; takizo paul...@takizo.com
Cc: pgpool-general@pgfoundry.org pgpool-general
40 matches
Mail list logo