I am not familiar with swarm cluster nor repmgr. So I wonder why you
wouldn't be able to get to the goal you are trying to achieve without
repmgr. Can you please elaborate more?
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.srao
Thank you Tatsuo for the Reply, I will post this in list you mentioned.
By Master-Master, I meant two pgpool servers both active accepting
connections from Application, If one Pgpool Server becomes unlavailable
other still accepting connections. At an Ideal time, both Pgpool instances
on each PgPo
> Hello There,
>
> I need to setup two PGPool Servers in Master-Master mode, First thing I
> want to know, is it possible?
>
> I know we can setup 2 PGPool servers in master-slave mode using watchdog.
> http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/en.html
>
> Could any
> This may be the wrong list, but I am not sure where it needs to go. I am
> trying to set up pgpool, and I keeping on getting this message:
>
> NOTICE: add node from hostname:"xxx" port:9000 pgpool_port:
> rejected.
> Jul 28 22:11:49 xx pgpool[10768]: [172-2] 2017-07-28 22:11:49: pi
Hi.
I had to implement something similar some time ago. Basically, a group of
database servers (postgres) geographically distributed, with each one having a
group of servers in each datacenter, and each server preferring the nearest
database server, but allowing connections to a further one if
Simon Windsor schrieb am 21.01.2017 um 21:26:
I was wondering if there is another option that will allow me to
spool all ALTER|CREATE|DELETE|DROP|INSERT|UPDATE commands to all
nodes, and SELECTs to any of the connected nodes. The apllication can
actually handle separate READ|WRITE nodes from how
Hi
Thanks for the reply. We were not planning to use pgPools connection
pool mode, but its replication mode.
Our tests with pgPool allow us to install a backup db via pgPool to each
node, and tests loads overnight of 10+GB of inserts/updates/deletes all
work fine, with only a slight loss of
Simon,
* Simon Windsor (simon.wind...@cornfield.me.uk) wrote:
> My employer wants to move from an in house Oracle solution to a
> cloud based Postgres system. The system will involve a number of
> data loaders running 24x7 feeding several Postgres Databases that
> will be used by internal applicat
Michael,
He already posted the identical question to the Pgpool-II mailing list
yesterday.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
> On Wed, Oct 12, 2016 at 10:04 AM, Dylan Luong
> wrote:
>> I am new to pg
On Wed, Oct 12, 2016 at 10:04 AM, Dylan Luong wrote:
> I am new to pgpool.
You may want to ask directly on the mailing lists of pgpool, even if
Tatsuo-san or anybody involved in it are looking at this mailing list:
http://pgpool.net/mediawiki/index.php/Mailing_lists
--
Michael
--
Sent via pgs
> It should not forward transactions which are requested to be
> SERIALIZABLE to standbys. If you just suppress the SET statement
> (or substitute REPEATABLE READ), queries in that transaction can
> return incorrect results.
Yes. Once "SET default_transaction_isolation to serializable" (or its
va
On Wed, Apr 13, 2016 at 5:54 PM, Kevin Grittner wrote:
> See this example, and imagine that
> the transaction generating the list of receipts for the closed
> batch is run on the standby before the transaction adding the last
> receipt commits. Or test it.
https://wiki.postgresql.org/wiki/SSI#D
On Wed, Apr 13, 2016 at 1:30 AM, Alexander Pyhalov wrote:
> Tatsuo Ishii писал 13.04.2016 02:36:
>>>
>>> On 04/12/2016 16:50, Adrian Klaver wrote:
On 04/12/2016 01:06 AM, Alexander Pyhalov wrote:
>>>
>>> I understand. I mean perhaps pgpool shouldn't forward these statements
>>> to slaves
Tatsuo Ishii писал 13.04.2016 02:36:
On 04/12/2016 16:50, Adrian Klaver wrote:
On 04/12/2016 01:06 AM, Alexander Pyhalov wrote:
I understand. I mean perhaps pgpool shouldn't forward these statements
to slaves.
Yeah, PostgreSQL used to accept the command on standbys (at least in
9.0). The rest
> On 04/12/2016 16:50, Adrian Klaver wrote:
>> On 04/12/2016 01:06 AM, Alexander Pyhalov wrote:
>>> Hi.
>>>
>>> We have application which explicitly does
>>> set default_transaction_isolation to 'serializable' .
>>> It is connected to PostgreSQL master/slave cluster through pgpool-II
>>> (pgpool2 3
On 04/12/2016 07:02 AM, Alexander Pyhalov wrote:
On 04/12/2016 16:50, Adrian Klaver wrote:
On 04/12/2016 01:06 AM, Alexander Pyhalov wrote:
Hi.
We have application which explicitly does
set default_transaction_isolation to 'serializable' .
It is connected to PostgreSQL master/slave cluster thr
On 04/12/2016 16:50, Adrian Klaver wrote:
On 04/12/2016 01:06 AM, Alexander Pyhalov wrote:
Hi.
We have application which explicitly does
set default_transaction_isolation to 'serializable' .
It is connected to PostgreSQL master/slave cluster through pgpool-II
(pgpool2 3.4.3-1.pgdg70+1). Our log
On 04/12/2016 01:06 AM, Alexander Pyhalov wrote:
Hi.
We have application which explicitly does
set default_transaction_isolation to 'serializable' .
It is connected to PostgreSQL master/slave cluster through pgpool-II
(pgpool2 3.4.3-1.pgdg70+1). Our logs are filling with
ERROR: 0A000: cannot
On 01/27/2016 11:53, Tatsuo Ishii wrote:
There's a file called "pool_status" which records the previous status
of the DB servers. So the file records that "A is down, B is up". In
your case, when A reboots, the old primary server on A may start as a
primary, but from the file pgpool knows that t
I don't know anything about repmgr. I neglect the questions to repmgr.
> I'd like to setup HA PostgreSQL streaming replication cluster with two
> nodes. The main issue which I'd like to protect from is HW node
> failure or reboot. I supposed to use repmgr to control PostgreSQL
> cluster and two pg
AI Rumman wrote:
> I am using pgpool-II version 3.4.3 (tataraboshi).
> Where my database is Postgresql 8.4.
>
> I am trying to configure ssl mode from client and between pgpool and database
> it is non-ssl.
> I configured as document and now I am getting this in my log:
>
> 2015-10-13 22:1
> Hi,
>
> I am using pgpool-II version 3.4.3 (tataraboshi).
> Where my database is Postgresql 8.4.
>
> I am trying to configure ssl mode from client and between pgpool and
> database it is non-ssl.
> I configured as document and now I am getting this in my log:
>
>>
>> *2015-10-13 22:17:58: pid
On 10/15/2015 09:36 AM, AI Rumman wrote:
I configured Postgresql 9.4 and still getting the same error.
Configured what?
Or more to the point what is ssl_renegotiation_limit set to?
Thanks.
On Thu, Oct 15, 2015 at 7:16 AM, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 10/1
I configured Postgresql 9.4 and still getting the same error.
Thanks.
On Thu, Oct 15, 2015 at 7:16 AM, Adrian Klaver
wrote:
> On 10/15/2015 06:59 AM, AI Rumman wrote:
>
>> Hi,
>>
>> I am using pgpool-II version 3.4.3 (tataraboshi).
>> Where my database is Postgresql 8.4.
>>
>
> Probably already
On 10/15/2015 06:59 AM, AI Rumman wrote:
Hi,
I am using pgpool-II version 3.4.3 (tataraboshi).
Where my database is Postgresql 8.4.
Probably already know, but 8.4 is approximately 1.25 years beyond EOL:
http://www.postgresql.org/support/versioning/
I am trying to configure ssl mode from cl
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.c
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 blacklistfunctio
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, consultin
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 wrote:
> Dear Sir/Mam,
>
> Can I have technical documentation for configuration of PgPool?
>
--
*
Problem has been solved utilizing tcpdump which revealed that the standbys were
not trying to contact the primary server, although they each were contacting
the other standby. From
this, we determined that a minor typographical error was present in the
pgpool.conf file. The setting under the wa
Ellen,
To date I have no solution. I'm currently trying to build a debug-able version
of 3.3.4 as I think I have a network problem which is preventing pgpool from
being a happy shareable system. Each one currently thinks it's a primary upon
startup, if it will start at all.
Sent from my iPad
Hi Jay,
Can you pls tell me how you resolved this issue.
We are running pgpool-II version 3.3.3
Thanks.
Ellen
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Pgpool-starting-problem-tp5803276p5818354.html
Sent from the PostgreSQL - general mailing list archive at Nabbl
> Hi all,
>
> If I turn use_watchdog = off in the pgpool.conf file, then in spite of the
> system being configured as master-slave, a socket file is created in /tmp,
> and everything starts normally with no errors. If, however, I set
> use_watchdog = on, pgpool will abort on startup with the follo
Jay at Verizon wrote
> Hi all,
>
> If I turn use_watchdog = off in the pgpool.conf file, then in spite of the
> system being configured as master-slave, a socket file is created in /tmp,
> and everything starts normally with no errors. If, however, I set
> use_watchdog = on, pgpool will abort on s
On Mon, 2011-09-12 at 08:07 -0300, Emanuel Araújo wrote:
>
> I'm doing a rebuild to a rpm package postgresql-9.0 with pgpool but
> your spec is outdated, there is some spec updated or have to make my
> changes manually?
Please hold on for 2-3 days. PgPool is the first RPM that I will need to
upd
> I'm doing a rebuild to a rpm package postgresql-9.0 with pgpool but your
> spec is outdated, there is some spec updated or have to make my changes
> manually?
Devrim is in charge of updating the spec file. Devrim?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
On Tue, Sep 21, 2010 at 8:08 PM, Tatsuo Ishii wrote:
> Unfortunately the gdb backtrace does not show enough information
> because of optimization, I guess. Can you take a backtrace with
> optimization disabled binary?
>
> You can obtain this by editing Makefile around line 147.
>
>
I edited conf
> On Tue, Sep 21, 2010 at 10:45 AM, Bryan Murphy wrote:
>
>> I'm sorry, when I went back over to double check my steps I realized I ran
>> the wrong command. I am *still* having the problem. It appears that the
>> MD5 hashes now match, but it's still failing. I have postgres and pgpool
>> insta
On Tue, Sep 21, 2010 at 10:45 AM, Bryan Murphy wrote:
> I'm sorry, when I went back over to double check my steps I realized I ran
> the wrong command. I am *still* having the problem. It appears that the
> MD5 hashes now match, but it's still failing. I have postgres and pgpool
> installed in
On Tue, Sep 21, 2010 at 10:26 AM, Bryan Murphy wrote:
> On Mon, Sep 20, 2010 at 6:23 PM, Tatsuo Ishii wrote:
>
>> I have used PostgreSQL 9.0 + pgpool-II 3.0 and they work fine with md5
>> auth. Your log seems to indicate that the password in pool_passwd and
>> the one in pg_shadow are not identi
On Mon, Sep 20, 2010 at 6:23 PM, Tatsuo Ishii wrote:
> I have used PostgreSQL 9.0 + pgpool-II 3.0 and they work fine with md5
> auth. Your log seems to indicate that the password in pool_passwd and
> the one in pg_shadow are not identical. Can you verify that?
> The query result:
>
> select pass
> I tried the patch file and I still cannot connect. The only other
> difference is that I've already upgraded our images to Postgres 9.0.0 from
> rc1.
>
> Here is the pgpool debug log:
>
> 2010-09-20 19:43:19 DEBUG: pid 1329: I am 1329 accept fd 6
> 2010-09-20 19:43:19 LOG: pid 1329: connecti
On Sun, Sep 19, 2010 at 11:31 PM, Tatsuo Ishii wrote:
> Sorry for delay. I had a trip outside Japan.
>
No problem.
> I found nasty bug with pgpool. Please try attached patches.
>
I tried the patch file and I still cannot connect. The only other
difference is that I've already upgraded our im
Sorry for delay. I had a trip outside Japan.
> Thanks, I should have thought to try that location. :)
>
> I put the pool_passwd file in the expected location (custom build,
> /opt/postgres/etc/pool_passwd and /etc/pool_passwd) and reran my test. I'm
> still having the same connection problem.
I
On Tue, Sep 14, 2010 at 6:55 PM, Tatsuo Ishii wrote:
> Sorry for not enough description about pool_passwd. It's located under
> the same directory as pgpool.conf. So the default is
> /usr/local/etc/pool_passwd.
>
> You need to create /usr/local/etc/pool_passwd if the uid to run pgpool
> server d
> I can't get md5 authentication working with postgres 9rc1 and pgpool-II 3.0.
> I see references to "pool_passwd" in the pgpool documentation, but I see
> nothing indicating *where* this file should exist and how pgpool finds it.
> I've set my accounts up in pcp.conf, however, I do not believe t
Guillaume Lelarge wrote:
Le 02/07/2010 15:46, Geoffrey a écrit :
Tatsuo Ishii wrote:
I'm trying to get a handle on sane values for these two parameters.
I assume that they should somehow correlate to my existing
max_connections in my postgresql.conf file. Anyone using pgpool-II
care to comme
Le 02/07/2010 15:46, Geoffrey a écrit :
> Tatsuo Ishii wrote:
>>> I'm trying to get a handle on sane values for these two parameters.
>>> I assume that they should somehow correlate to my existing
>>> max_connections in my postgresql.conf file. Anyone using pgpool-II
>>> care to comment?
>>>
>>>
Tatsuo Ishii wrote:
I'm trying to get a handle on sane values for these two parameters. I
assume that they should somehow correlate to my existing
max_connections in my postgresql.conf file. Anyone using pgpool-II care
to comment?
I'm sure it's a balancing act between how many connections
> I'm trying to get a handle on sane values for these two parameters. I
> assume that they should somehow correlate to my existing
> max_connections in my postgresql.conf file. Anyone using pgpool-II care
> to comment?
>
> I'm sure it's a balancing act between how many connections you want
On Tue, Jun 22, 2010 at 07:07:33AM -0400, Geoffrey wrote:
> A couple of questions regarding pgpool:
>
> Is there a problem with using multiple connection pools for the same
> database? Point being, we might want to give a higher number of
> connections to one group of users then another. I ca
A couple of questions regarding pgpool:
Is there a problem with using multiple connection pools for the same
database? Point being, we might want to give a higher number of
connections to one group of users then another. I can see doing this by
having separate connection pools. The higher p
Scott Marlowe wrote:
On Mon, Jun 21, 2010 at 2:42 PM, Geoffrey wrote:
Scott Marlowe wrote:
On Mon, Jun 21, 2010 at 1:45 PM, Geoffrey
wrote:
John R Pierce wrote:
On 06/21/10 5:37 AM, Geoffrey wrote:
So I've got 13 different databases on 13 different postmasters, now
does
pgpool know which d
On Mon, Jun 21, 2010 at 2:42 PM, Geoffrey wrote:
> Scott Marlowe wrote:
>>
>> On Mon, Jun 21, 2010 at 1:45 PM, Geoffrey
>> wrote:
>>>
>>> John R Pierce wrote:
On 06/21/10 5:37 AM, Geoffrey wrote:
>
> So I've got 13 different databases on 13 different postmasters, now
> does
Scott Marlowe wrote:
On Mon, Jun 21, 2010 at 1:45 PM, Geoffrey wrote:
John R Pierce wrote:
On 06/21/10 5:37 AM, Geoffrey wrote:
So I've got 13 different databases on 13 different postmasters, now does
pgpool know which databases I'm trying to connect to?
you would need 13 different connectio
On Mon, Jun 21, 2010 at 1:45 PM, Geoffrey wrote:
> John R Pierce wrote:
>>
>> On 06/21/10 5:37 AM, Geoffrey wrote:
>>>
>>> So I've got 13 different databases on 13 different postmasters, now does
>>> pgpool know which databases I'm trying to connect to?
>>
>> you would need 13 different connection
John R Pierce wrote:
On 06/21/10 5:37 AM, Geoffrey wrote:
So I've got 13 different databases on 13 different postmasters, now
does pgpool know which databases I'm trying to connect to?
you would need 13 different connection pools.
Can this be done?
--
Until later, Geoffrey
"I predict futu
On 06/21/10 5:37 AM, Geoffrey wrote:
So I've got 13 different databases on 13 different postmasters, now
does pgpool know which databases I'm trying to connect to?
you would need 13 different connection pools.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chan
Guillaume Lelarge wrote:
If you want to be able to connect on various databases from various
servers, pgBouncer is what you're looking for.
It does not appear that pgbouncer will 'limit exceeding connections' as
does pgpool. So if I have a pool of 20 connections and 20 connections
are used,
Guillaume Lelarge wrote:
Le 21/06/2010 15:52, Geoffrey a écrit :
So I've got the following:
port =
.
.
backend_hostname0 = 'localhost'
backend_port0 = 5434
backend_weight0 = 1
backend_data_directory0 = '/data/pgsql/master'
backend_hostname1 = 'localhost'
backend_port1 = 5435
backend_weight
Le 21/06/2010 15:52, Geoffrey a écrit :
> So I've got the following:
>
> port =
> .
> .
> backend_hostname0 = 'localhost'
> backend_port0 = 5434
> backend_weight0 = 1
> backend_data_directory0 = '/data/pgsql/master'
> backend_hostname1 = 'localhost'
> backend_port1 = 5435
> backend_weight1 =
So I've got the following:
port =
.
.
backend_hostname0 = 'localhost'
backend_port0 = 5434
backend_weight0 = 1
backend_data_directory0 = '/data/pgsql/master'
backend_hostname1 = 'localhost'
backend_port1 = 5435
backend_weight1 = 1
backend_data_directory1 = '/data/pgsql/mwv'
In my pgpool.con
Geoffrey wrote:
Gerd Koenig wrote:
Hi Geoffrey,
you do not need to connect to your database directly, just connect to
pgpool itself.
e.g.: your database runs on port 5434, pgpool runs on port 5432
=>
* pgpool has to be configured in that way that it connects to the
database on port 5434
W
Gerd Koenig wrote:
Hi Geoffrey,
you do not need to connect to your database directly, just connect to pgpool
itself.
e.g.: your database runs on port 5434, pgpool runs on port 5432
=>
* pgpool has to be configured in that way that it connects to the database on
port 5434
What parameter in
Gerd Koenig wrote:
Hi Geoffrey,
you do not need to connect to your database directly, just connect to pgpool
itself.
e.g.: your database runs on port 5434, pgpool runs on port 5432
=>
* pgpool has to be configured in that way that it connects to the database on
port 5434
* you/your app's sho
Hi Geoffrey,
you do not need to connect to your database directly, just connect to pgpool
itself.
e.g.: your database runs on port 5434, pgpool runs on port 5432
=>
* pgpool has to be configured in that way that it connects to the database on
port 5434
* you/your app's should connect to the ser
t; > > thesis.
> > > > > so thats why I am using this.
> > > > > Is there any problem if I use this version?
> > > > > Is this stable version?
> > > > > Finally I am able to work both pgpool and postgres working togather.
> &g
work both pgpool and postgres working togather.
>
>
> From: Tatsuo Ishii [is...@sraoss.co.jp]
> Sent: Thursday, February 18, 2010 1:56 AM
> To: megha198...@gmail.com
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] pgpool error
Wao. This is pgpool, right? It's not maintained anymore(it was almost
3 years ago). Please use pgpool-II. The latest version is pgpool-II
2.3.2.1.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
> Sorry for late reply. I work full
How did you start pgpool exactly(command line)?
Also, the number "" dpends on pgpool.conf.
Can you show me pgpool.conf?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
> >From the README file , I found that " psql -p -c
pgpool.pid file contains pgpool's parent process id. That message
indicates that the file exists but the pgpool process id does not
exist. Probably pgpool was stopped in unclean way. You may ignore the
message as long as pgpool starts ok.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sra
Have you turned off autovacuum on the first db node before starting
online recovery?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
> Hello,
>
> today I recognized an error while playing with pgpool-II 2.1 and
> postgresql 8.3.5 (on 64bit linux).
> I really don't know if the error is caused by pgpool or if
On Sun, August 10, 2008 3:03 pm, Henry wrote:
>
> I scratched around some more, found doc/pgpool-en.html and my ignorance
> has been somewhat lessened.
oi, wrong list /blushes
I really should *not* use multi-users under one login in squirrelmail...
--
Sent via pgsql-general mailing list (pgsql
I scratched around some more, found doc/pgpool-en.html and my ignorance
has been somewhat lessened.
My previous config was almost right except for:
pgpool2_hostname = ''
#backend_data_directory0
#backend_data_directory1
and my Linux distro had assigned hostname 'slave1' to localhost, on which
P
On Wed, 19 Dec 2007, Tom Lane wrote:
Not sure if pgpool has its own list.
There's a moderately active general user list as part of the set at
http://pgfoundry.org/mail/?group_id=155
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end
> Hi,
> This is a newbie pgpool question. I have 2 servers (master-slave) and Slony
> is doing the replication. I had installed pgpool for load balance where i
> had disabled the replication_mode=false and load_balance_mode=true in
> pgpool.conf
>
> pcp_node_info gives this output.
>
> -sh-3.00$
"Josh Harrison" <[EMAIL PROTECTED]> writes:
> This is a newbie pgpool question.
> ...
> sorry if my question is silly
It doesn't sound silly, but this isn't the best place to ask it.
The slony project has its own mailing list(s) and you'll get
better-informed answers there. Not sure if pgpool has
On 9/12/07, sharmi Joe <[EMAIL PROTECTED]> wrote:
> Hi,
> Im a newbie to postgres. Can you explain what pgpool is ?
> Thanks
>
>
http://pgpool.projects.postgresql.org/
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an
> Hi List;
>
> It seems that in a replication scenario pgpool becomes the single point of
> failure, i.e. if we loose the pgpool box were dead. Any thoughts,
> suggestions, best practices, etc per creating redundancy in the pgpool layer?
>
> I've posted to the pgpool list as well but I wanted t
On Sep 7, 2006, at 3:31 PM, andy rost wrote:
a) The system load is > 20
b) WCPU values for the 14 active pgpool processes exceed 20%
c) Context switching on the server jumps as high as 250,000
The application now takes 4 (with pgpool) rather than less than two
hours (without pgpool) to comple
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> Please forgive me if this is slightly off topic to the list, but I
> couldn't find any suitable *mail based* forum.
pgsql-www is probably the right place to report this sort of problem.
regards, tom lane
-
Please forgive me if this is slightly off topic to the list, but I
couldn't find any suitable *mail based* forum.
I got following mail and it seems the only solution is re-subscrive to
Pgpool-committers (and do it again and again because the system will
kick off them again).
-
On Apr 3, 2006, at 3:05 AM, Tatsuo Ishii wrote:
The problem is not reproduced here. Do you have any idea how to
reproduce it?
If I did, I'd resolve it. :P
I suppose I can try restarting the connection pools on this server
just to see what happens. If I am able to do that, I will post the
The problem is not reproduced here. Do you have any idea how to
reproduce it?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
> On Apr 1, 2006, at 8:01 AM, Tatsuo Ishii wrote:
>
> >> A while back, I posted about seeing a number of warnings from pgpool:
> >>
> >> http://archives.postgresql.org/pgsql-admin/200
> A while back, I posted about seeing a number of warnings from pgpool:
>
> http://archives.postgresql.org/pgsql-admin/2005-03/msg00305.php
>
> A typical pair of statements in my postgres logs looks like this:
>
> WARNING: there is no transaction in progress
> STATEMENT: ABORT
>
> Tatsuo Ishi
Andrew Sullivan wrote:
On Sat, Oct 15, 2005 at 06:04:54PM -0700, Chris Travers wrote:
Out of curiosity, what is wrong with requiring client SSL certs to
access the system and only issuing them to the PGPool system (or using a
different CA if you need to issue client certs to the end users)?
to 0. Unfortunately this would not help
> on a query by query basis, but the above would.
>
>
>
>
>
>
>
>
>
>
>
>
>
> -Original Message-
> From: Tatsuo Ishii [mailto:[EMAIL PROTECTED]
> Sent: Saturday, April 23, 2005 7:23 PM
> To: Brian Magui
> On Sun, 2005-04-24 at 00:53, Ron Mayer wrote:
> > Tatsuo Ishii wrote:
> > >>
> > >>Is there anyway to load balance selects to more than 2 servers? ex. 1
> > >>master with 2 slaves? Run multiple instances?
> > >
> > > It's on my TODO but will not be a trivial change.
> >
> > Could I set up 2
PM
To: Brian Maguire
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Pgpool questions
> I have a couple Pgpool questions regarding running pgpool as a
load balancer with Sony as the replicator.
>
>
>
> Is there anyway to load balance selects to more than 2 servers
On Sun, 2005-04-24 at 00:53, Ron Mayer wrote:
> Tatsuo Ishii wrote:
> >>
> >>Is there anyway to load balance selects to more than 2 servers? ex. 1
> >>master with 2 slaves? Run multiple instances?
> >
> > It's on my TODO but will not be a trivial change.
>
> Could I set up 2 pairs of pgpool-ba
Tatsuo Ishii wrote:
Is there anyway to load balance selects to more than 2 servers? ex. 1 master with 2 slaves? Run multiple instances?
It's on my TODO but will not be a trivial change.
Could I set up 2 pairs of pgpool-balanced servers, and use a
third pgpool to load balance across the two pools?
> I have a couple Pgpool questions regarding running pgpool as a load balancer
> with Sony as the replicator.
>
>
>
> Is there anyway to load balance selects to more than 2 servers? ex. 1 master
> with 2 slaves? Run multiple instances?
It's on my TODO but will not be a trivial change.
> I
On Sat, Apr 23, 2005 at 08:37:02AM -0700, Joshua D. Drake wrote:
> Brian Maguire wrote:
> >Is there any way to tell a select query to only go to the slave?
>
> That i don't know.
I think Tatsuo said recently that it was an interesting suggestion and
the he'd look into implementing it.
--
Alv
Brian Maguire wrote:
I have a couple Pgpool questions regarding running pgpool as a load balancer
with Sony as the replicator.
Is there anyway to load balance selects to more than 2 servers? ex. 1 master with 2 slaves? Run multiple instances?
My understanding is that if you turn on the load b
> Tatsuo,
>
> I'm excited that pgpool is working for us now. We plan to start using it in
> the near future on our production applications (hundreds of thousands of DB
> transactions per day). I have just a couple follow-up questions:
>
> 1. When we use pgpool, should we still use a databas
Thanks for the tip. The client_encoding and lc_messages values were different on the two databases. I fixed both settings, and it works now!
KevinTatsuo Ishii <[EMAIL PROTECTED]> wrote:
What are client_encoding values on these two servers? It seems they donot match...--Tatsuo Ishii> Sure, here
What are client_encoding values on these two servers? It seems they do
not match...
--
Tatsuo Ishii
> Sure, here is the debug output when I run the following command..
>
> -bash-2.05b$ psql -p -c 'show pool_status' template1
> psql: server closed the connection unexpectedly
> This p
Sure, here is the debug output when I run the following command..
-bash-2.05b$ psql -p -c 'show pool_status' template1psql: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.
Debug output from
Can you show me debug messages by starting pgpool with -d option?
--
Tatsuo Ishii
> Hello,
>
> I'm having trouble getting pgpool to work in master/slave mode. I'm planning
> on using something like Slony-I for replication, and use pgpool only to load
> balance the queries across the master an
Brian Maguire wrote:
> Is anyone currently using pgpool with production high volume use? I
> am interested in your success and challenges.
There isn't much special about high volume use. Just make sure you
configure the pool size appropriately for your application and
configure a corresponding
1 - 100 of 123 matches
Mail list logo
