On Sun, 2011-11-20 at 08:13 +0900, Tatsuo Ishii wrote:
Thank you very much for the answer.
Is there a plan for using sr_check_password in the next release of pgpool
3.1 series?
Yes, it's in my plan. Unless supporting sr_check_password is too
invasive...
Sorry, but I disagree. Either it
On Sun, 2011-11-20 at 18:31 +0900, Tatsuo Ishii wrote:
On Sun, 2011-11-20 at 08:13 +0900, Tatsuo Ishii wrote:
Thank you very much for the answer.
Is there a plan for using sr_check_password in the next release of
pgpool 3.1 series?
Yes, it's in my plan. Unless supporting
On Fri, 2011-11-11 at 01:27 -0800, Sandeep Thakkar wrote:
Hi,
Why one more release of pgpool-II 3.0 series when we have pgpool-II
3.1 series released already? We were using pgpool-II 3.0.3 and then
updated to 3.1. Now, you have released 3.0.5. Which one should we use
for production?
when reattaching the node in raw mode(Guillaume Lelarge)
Don't know about the others, but the one you're referring to is fixed on
both releases.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
___
Pgpool-general mailing
On Thu, 2011-10-06 at 14:36 +0200, Armin Nesiren wrote:
Hi everyone,
I'm experiencing performance issues with pgpool-3.1
Problem is that when I connect through pgpool to database, database works
slower than
when I connect directly to master. In this test case, I have disabled node2,
just
On Thu, 2011-10-06 at 14:56 +0200, Armin Nesiren wrote:
On Thu, Oct 6, 2011 at 2:48 PM, Guillaume Lelarge
guilla...@lelarge.infowrote:
On Thu, 2011-10-06 at 14:36 +0200, Armin Nesiren wrote:
Hi everyone,
I'm experiencing performance issues with pgpool-3.1
Problem is that when I
On Thu, 2011-10-06 at 10:59 -0500, Matias Israel Malpica Escobar wrote:
Hi everyone i´ve been trying to understand and configure pgpool for a pool of
connections (not sure if that is the term), i already follow a manual and
confiigure it like this:
listen_addresses = '*'
port =
On Thu, 2011-10-06 at 17:27 +0200, Olivier NOEL wrote:
2011/10/6 Guillaume Lelarge guilla...@lelarge.info:
[...]
And it's not. Ok, there is some overhead, but it's veeery slow.
How did you check that?
You may be right in a specific setting, but I have no issues getting
better
On Thu, 2011-10-06 at 11:13 -0500, Matias Israel Malpica Escobar wrote:
Hi thanks for your answers, what i wanted to say about the connections and
errors from pgpool was that, for what i understand postgres returns an error
if the number of connections are higher than its maximum, and pgpool
On Wed, 2011-10-05 at 09:38 +0100, Thom Brown wrote:
Hi,
I want to be able to have a primary/standby PostgreSQL setup with
streaming replication and using pgPool to deal with the load balancing
and auto failover. One question I have is can I have 2 instances of
pgPool pointing to the same
On Wed, 2011-10-05 at 12:22 +0200, Guillaume Lelarge wrote:
On Wed, 2011-10-05 at 10:13 +0100, Thom Brown wrote:
On 5 October 2011 10:05, Guillaume Lelarge guilla...@lelarge.info wrote:
On Wed, 2011-10-05 at 09:38 +0100, Thom Brown wrote:
[...]
This seems like it should be a very common
On Wed, 2011-10-05 at 11:44 +0100, Thom Brown wrote:
On 5 October 2011 11:40, Guillaume Lelarge guilla...@lelarge.info wrote:
On Wed, 2011-10-05 at 12:22 +0200, Guillaume Lelarge wrote:
On Wed, 2011-10-05 at 10:13 +0100, Thom Brown wrote:
On 5 October 2011 10:05, Guillaume Lelarge guilla
On Tue, 2011-10-04 at 10:39 +0200, Olivier NOEL wrote:
Hi,
I compiled and installed pgpool 3.1 on Debian Wheezy yesterday. No
compile errors.
But I have a LOT of errors :
Oct 4 10:09:48 pgpool01 pgpool: 2011-10-04 10:09:48 ERROR: pid 1198:
Child process 7712 was terminated by
On Sat, 2011-07-30 at 08:38 +0900, Tatsuo Ishii wrote:
On Thu, Jul 28, 2011 at 10:40 PM, Tatsuo Ishii is...@sraoss.co.jp wrote:
Because newly added node is likely to have out of sync databases. Thus
bringing it online immediately will allow user to use obsolete
databases. You should
On Fri, 2011-08-05 at 00:17 -0400, Matt Solnit wrote:
On Jul 29, 2011, at 10:37 PM, Matthew Solnit wrote:
Hi everyone. I'm using pgpool-II 3.0.4 with PostgreSQL 9.0.2, in streaming
replication mode. We've had
a couple of cases where pgpool-II got a network timeout while performing a
On Thu, 2011-07-21 at 13:27 +0900, Tatsuo Ishii wrote:
Tatsuo,
Currently the recovery routine is called on the current master database,
and the parameters passed to it do not include the master database IP
address or hostname. Given that the way to provision a node with 9.1
On Thu, 2011-07-21 at 16:29 +0900, Tatsuo Ishii wrote:
On Thu, 2011-07-21 at 13:27 +0900, Tatsuo Ishii wrote:
Tatsuo,
Currently the recovery routine is called on the current master database,
and the parameters passed to it do not include the master database IP
address or
On Thu, 2011-07-21 at 10:41 +0200, David Hartveld wrote:
Op 21-07-11 08:16, Toshihiro Kitagawa schreef:
On Wed, 20 Jul 2011 11:58:45 -0400
Matt Solnitmsol...@soasta.com wrote:
Hi everyone. I'm trying to understand why load balancing doesn't work
with the PostgreSQL JDBC driver, and
On Thu, 2011-07-21 at 18:02 +0900, Tatsuo Ishii wrote:
From: Guillaume Lelarge guilla...@lelarge.info
Subject: Re: [Pgpool-general] We really need a change to the API for calling
recovery
Date: Thu, 21 Jul 2011 10:07:46 +0200
Message-ID: 1311235666.2018.11.camel@laptop
On Thu, 2011-07-21
On Tue, 2011-07-05 at 10:53 +0200, Mario Splivalo wrote:
I have set up logdir in pgpool.conf, but no logging ever takes place
there. It seem that the only way pgpool is logging stuff is to stdout
(where I can redirect it to file, pipe it to logger process, etc).
I even set debug to 1 in
On Tue, 2011-07-05 at 16:18 +0200, Mario Splivalo wrote:
On 07/05/2011 01:51 PM, Guillaume Lelarge wrote:
On Tue, 2011-07-05 at 10:53 +0200, Mario Splivalo wrote:
I have set up logdir in pgpool.conf, but no logging ever takes place
there. It seem that the only way pgpool is logging stuff
On Fri, 2011-06-10 at 12:52 -0400, Paul Giblock wrote:
Any help with this?
Before putting pgpool in the middle of this, did you install master and
slave as recommended on
http://www.postgresql.org/docs/9.0/interactive/warm-standby.html ?
--
Guillaume
http://blog.guillaume.lelarge.info
Le 01/04/2011 03:45, Sean Tegtmeyer a écrit :
Hi all,
When adding in a new slave node to a running database cluster using
pgpool-II w/Postgres9.0 SR, we would need to add a new ***backend_hostname
*to the pgpool.conf, correct? Then would it be necessary to restart
pgpool-II as the
Le 01/04/2011 08:06, Karl Lehenbauer a écrit :
Hi,
We have slony replication running with a 4 node cluster and we have been
using pgpool-II for a long time, to load balance certain queries.
Now we are preparing to migrate to PostgreSQL 9.0. Currently, one of our
slony slaves is
Le 31/03/2011 02:03, Sean Tegtmeyer a écrit :
Hi all,
In both master-slave mode and replication mode, pgpool-II is only running
on one box, correct?
If you only run pgpool on one box, yes, correct.
Therefore pgpool-II does not provide
a fail-over solution in the case that the box
Le 22/03/2011 15:25, Armin Nesiren a écrit :
I have problem reading from slave node values that is indexed with hash
index.
Does pgpool replicate hash indexes? Is there any special configuration for
hash index?
If you use pgpool replication system, you should have no issue with hash
index
Le 22/03/2011 16:59, Armin Nesiren a écrit :
But, what am I doing wrong then.
When I insert something in master node, and after that take select, I see my
record.
On slave, when using index I can not see exact record, and without using
index, record is there.
I have configured streaming
Le 20/03/2011 10:44, Tatsuo Ishii a écrit :
I'm new to pgpool and to this list. I'm trying to set up a load
balancing cluster using pgpool-II 3.0 and slony. So far it seems to
work as expected, except for one key aspect: it seems as it is not
implemeted the lag check for slony, only for
Le 17/03/2011 11:53, Gnanakumar a écrit :
Hi,
Our production server is running PostgreSQL v8.2.3 and pgpool-II-v2.0.1.
We're planning to upgrade PostgreSQL to the latest version 9.0.3. My
question is, is it possible/compatible to run pgpool-II v.2.0.1 with
PostgreSQL v9.0.3?
Don't
Le 15/03/2011 14:08, Sandeep Thakkar a écrit :
I think, the default path should be the relative path from where the binary
exists. So, it should be ../etc/pgpool.conf. Can we do it? We use pgpool-II
3.0.3 sources.
Why don't you use the -f option to specify your configuration file location?
Le 22/02/2011 09:52, Micka a écrit :
by the way :
-rwxr-xr-x 1 www-data root 722 2010-11-12 06:45 failover.sh
-rw-r--r-- 1 www-data root 982 2011-02-21 18:31 pcp.conf
-rw-r--r-- 1 root root 858 2011-02-22 09:08 pcp.conf.sample
-rw-r--r-- 1 www-data root 9532 2011-02-22 04:59
Le 22/02/2011 10:58, Micka a écrit :
Thanks,
Depends if you told pgpool where to find it. How did you launch pgPool?
pgPool is not launching yet.
Because i'm following this tutorial :
http://pgpool.projects.postgresql.org/contrib_docs/simple_sr_setting/index.html
I should have
Le 21/02/2011 18:36, Micka a écrit :
Hi,
I'm trying to understand on how to use the pcp command, but it doesn't work
see :
mickael@PTI2:/var/log/pgpool$ pcp_node_count 10 localhost 9898 postgres
pgpoolAdmin
AuthorizationError
And
sudo nano /usr/local/etc/pcp.conf
#
Le 21/02/2011 19:59, Stephen Sugden a écrit :
Hello everybody,
I am trying to configure pgpool-II to load balance queries and provide
failover for 2 (or more) identical backend servers. The application that
will access pgpool only does SELECT queries. The back end servers are
written to
Le 08/02/2011 13:26, Micka a écrit :
I would like to know if it is preferable to use postgreSQL 9 or Postgresql
8.3.8 ?
Postgresql 8.3.8 is described in the tutorial.
9.0. Why use a two years old release...
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
Le 07/02/2011 09:35, Wouter D'Haeseleer a écrit :
Hi All,
Just an enhancement question.
I have noticed that you need to keep a list of blacklisted functions in case
one of the functions does a write to the db.
Maybe it's a good idea to tackle this in an automated way.
Since if you do
Le 03/02/2011 16:52, Michal Slocinski a écrit :
Hi!
I'm pgpool newbie trying to setup cluster of two PostgreSQL servers.
I configureed pgpool.conf as follows:
# $Header: /cvsroot/pgpool/pgpool-II/pgpool.conf.sample-replication,v
1.11 2010/09/01 04:58:47 kitagawa Exp $
listen_addresses
Le 27/01/2011 09:49, Sandeep Thakkar a écrit :
I was just testing the pgpool with one primary and one standby on the same
box.
Hot Standby, Streaming replication, load balancing, all are working fine.
But, I
see that failover is not happening when I shut down my primary server. When I
Le 27/01/2011 13:06, Sandeep Thakkar a écrit :
Here, both the dbservers and pgpool run on the single box. This may not be
the
practical scenario, but I was just testing the features.
Hence, I directly used touch. Is it fine then?
If the user has the right to create such a file, yes. Is
Le 20/01/2011 23:58, Matthew Bennett a écrit :
I am setting up PGpool with PostgreSQL 9.0 using streaming replication. I want
to use PGpool to load balance between the live database and the hot-standby.
The
two Postgres servers are running on their own machines and PGpool is running
on
Le 18/01/2011 16:16, Gary Fu a écrit :
On 01/17/11 19:45, Tatsuo Ishii wrote:
Is there a simple query (not the 'show' command) to tell if my current
db connection is using pgpool ?
No. Why is show pool_status not good?
It causes error when the connection is not using pgpool.
You can try
Le 18/01/2011 22:06, Gary Fu a écrit :
On 01/18/11 15:35, Guillaume Lelarge wrote:
Le 18/01/2011 16:16, Gary Fu a écrit :
On 01/17/11 19:45, Tatsuo Ishii wrote:
Is there a simple query (not the 'show' command) to tell if my current
db connection is using pgpool ?
No. Why is show
Le 12/01/2011 09:40, Zhidong She a écrit :
Hi Guys,
I'm just a little confused about master_slave_sub_mode option in
configuration file.
If we build a master/slave db replication and deploy pgpool on top of
them, we need set master_slave_mode to true. It does make sence.
But why does
Hi,
Le 12/01/2011 15:10, Sandeep Thakkar a écrit :
[...]
I have a primary and a standby server on different boxes and both are running
on
different ports. I would like to use pgpool for Streaming Replication and
Failover. Hence, I selected Master/Slave mode with stream. Now, I have a
Le 18/12/2010 01:47, Tatsuo Ishii a écrit :
[...]
I did the work on pgpoolII-3.0.1's doc, by the way.
In the mean time, I think Jean-Paul Argudo is translating the doc to
French and if my memory is correct, he is trying to fix the English
doc as well. Is it possible for you and Jean to work
Le 25/09/2010 22:36, Duncan McQueen a écrit :
I see the new version of pgpool-II includes some support for postgres
9.0. I just installed the binary for postgres, but configure fails
when trying to find libpq (since postgres is installed in /opt).
Specifically. this fails:
./configure
, Guillaume Lelarge a �crit :
Le 20/08/2010 01:49, Tatsuo Ishii a �crit :
hi! i tried to compile pgpool-II 3.0 beta1 on SCO 5.0.7 , buti
can't find getopt.h file , i just have an getopt_.h from gnulib
but
is not enough to compile
Le 22/08/2010 08:36, Tatsuo Ishii a écrit :
Le 22/08/2010 00:35, Tatsuo Ishii a écrit :
Le 21/08/2010 09:25, Tatsuo Ishii a écrit :
Le 20/08/2010 15:04, Guillaume Lelarge a écrit :
Le 20/08/2010 01:49, Tatsuo Ishii a écrit :
hi! i tried to compile pgpool-II 3.0 beta1 on SCO 5.0.7 , buti
Le 21/08/2010 18:08, Guillaume Lelarge a écrit :
Le 21/08/2010 09:25, Tatsuo Ishii a écrit :
Le 20/08/2010 15:04, Guillaume Lelarge a écrit :
Le 20/08/2010 01:49, Tatsuo Ishii a écrit :
hi! i tried to compile pgpool-II 3.0 beta1 on SCO 5.0.7 , buti
can't find getopt.h file , i just
Le 22/08/2010 00:35, Tatsuo Ishii a écrit :
Le 21/08/2010 09:25, Tatsuo Ishii a écrit :
Le 20/08/2010 15:04, Guillaume Lelarge a écrit :
Le 20/08/2010 01:49, Tatsuo Ishii a écrit :
hi! i tried to compile pgpool-II 3.0 beta1 on SCO 5.0.7 , buti
can't find getopt.h file , i just have
Le 13/08/2010 03:02, Josh Berkus a écrit :
Hmmm. You might want to display a more user-friendly value for the
user, though, no?
Good point:-) I'm thinking about to change it for coming 3.0.
Great! Might I also suggest using getopt-long for the PCP commands?
That's already done in 3.0
Le 28/07/2010 16:50, Sean Brown a écrit :
Does PgPool have an issue with the order of results from a query being
returned in a different order?
With the ongoing issue of our cluster falling out, we just had one member
fall
out again and again, no error in PostgreSQLs log is recorded.
Le 28/07/2010 17:16, Sean Brown a écrit :
On Wednesday, July 28, 2010 10:56:27 am you wrote:
Le 28/07/2010 16:50, Sean Brown a écrit :
Does PgPool have an issue with the order of results from a query being
returned in a different order?
With the ongoing issue of our cluster falling out, we
Le 05/06/2010 02:42, Tatsuo Ishii a écrit :
[...]
I just want to let you know that I have started my *first* English
blog at: http://pgsqlpgpool.blogspot.com/.
I will post articles regarding PostgreSQL and pgpool-II.
That's great news. I see that you already posted one article. I'm gonna
Le 05/03/2010 09:45, Matthias Tief a écrit :
Hallo,
we are planning to use pgpool-II as replication solution for our
PostgeSQL application. Currently we evaluate, whether the restriction of
pgpool-II affect our application. In the documentation you say:
pgpool-II cannot process
Le 04/03/2010 13:41, Christophe Philemotte a écrit :
There exist some diff tools:
- apgdiff http://apgdiff.sourceforge.net/
- pgdiff http://pgdiff.sourceforge.net/
Those are schema-wise. I think that Arjen means data-wise.
you're rigth, I do not know data-wise diff. In fact, I've developped
Le mardi 21 juillet 2009 à 10:12:37, Dave Page a écrit :
On Mon, Jul 20, 2009 at 10:32 PM, Guillaume
Lelargeguilla...@lelarge.info wrote:
Le lundi 20 juillet 2009 à 19:06:50, Dave Page a écrit :
On Mon, Jul 20, 2009 at 5:38 PM, Guillaume
Lelargeguilla...@lelarge.info wrote:
The
Le lundi 20 juillet 2009 à 19:06:50, Dave Page a écrit :
On Mon, Jul 20, 2009 at 5:38 PM, Guillaume
Lelargeguilla...@lelarge.info wrote:
The latter. I don't see a way to catch them all easily. I'll commit this,
and try to find a way to catch the others.
Good luck with that. We use
Le jeudi 16 juillet 2009 à 15:48:58, Leonardo Carvalho a écrit :
Unfortunately, PgAdmin always sends this commands , trying to use
ISO date format.
If you discover how to fix that in PgAdmin, tell us!
There's no way to fix that without recompiling. But you can try the patch
attached.
Le jeudi 09 avril 2009 à 03:03:08, Tatsuo Ishii a écrit :
[...]
Also I'm going to give a talk at PGCon 2009 in Ottawa. I would like to
talk about how pgpool-II tries to keep the consistency among databases.
I'll be there too. That's one of the talk I want to attend.
--
Guillaume.
60 matches
Mail list logo