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
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 anyone please enlight
> 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
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: pid
10768: DET
e de Operaciones
Open Comb Systems E.I.R.L.
Oficina: (+51-1) 3377813 | RPM: #034252 / (+51) 995540103 | RPC: (+51)
954183248
Website: www.ocs.pe
- Original Message -
From: "Simon Windsor"
To: pgsql-general@postgresql.org
Sent: Saturday, 21 January, 2017 2:38:59 PM
Subject: [GENE
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
Hi
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 applications and external customer applications.
For the record, inte
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
Hi,
I am new to pgpool. I have just installed pgpool and configured Master/Slave
mode with "stream" sub_mode. I have enabled load balance as that is the main
feature we want test out. I have enabled Health Check. The load balance appears
to work as I can see connections to both Master and Slave
I posted this in the pgpool mailing list and so far has not recvd any response.
Looks like that mailing list is hardly active.
=
I am researching pgpool technology. Let us say we want to use it as an
alternative to streaming replication of PG. Apparently
> 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
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 use serializable mode in a hot standby DETAIL:
"
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
Hi.
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 pgpool instances as load balancers/DB proxies.
The issue which I still
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
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 1857: LOG: new conn
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?
>
--
*
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
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 following errors:
Environment: PostgreSQL 9.3.3 on RHEL 6.4
We have already configured streaming replication in our environment. We have a
master/primary and two standby server configuration. Our next task requires us
to configure and install pgpool.
we want to leverage the installer: installer-pg93-3.3.3.tar.g
Hello to everybody.
I've found there should be a package pgpool-ha in the full package list:
http://yum.postgresql.org/news-packagelist.php
I installed PostgreSQL yum repository by installing this RPM (red hat 6,
x86_64):
http://yum.postgresql.org/9.2/redhat/rhel-6-x86_64/pgdg-redhat92-9.2-7
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
Hi,
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?
-- *
Emanuel Araújo*
http://eacshm.wordpress.com/
*
*
*Linux Certified
LPIC-1*
Hi
I am working on pgpool /postgresql/linux first time. All these three are
new to me.
I am running pgpool-HA using pacemaker-corosync.
I am having following error in my setup. Does any body have any idea
about the warning highlighted in logs ? Any type of help would be
appreciated a lot...
Sorry for off topic posting but...
Since pgfoundry has been down, the schedule for releasing pgpool-II
3.0.4, to be released today, will be delayed. Sorry for
inconvenience. We will start to continue the releasing work as soon as
pgfoundry comes back.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: h
Hi,
as the Subject says i want pgpool to talk only to my slony slaves.
In my company we have a Slony Setup with 1 master replicating to 2
slaves. Our application only does read queries (never ever writes) to
the 2 slaves through pgpool. While upgrading to pgpool 3.0.1 (from
2.2.5) i detected t
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
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 this is w
Pgpool Global Development Group is pleased to announce the
availability of pgpool-II 3.0 beta1. In the mean time new version of
pgpoolAdmin, the GUI tool for pgpool-II, pgpoolAdmin 3.0 beta1 is
released.
Users are encouraged to take part in our beta test program.
pgpool-II 3.0 beta1/pgpoolAdmin 3.
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
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
verses how
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
So, I've got it installed, and tweaked the configuration, but I simply
can not figure out how to connect to my databases via pgpool. Is this
simply transparent? I don't see how.
So I have a postmaster running on port 5434, how do I connect to that
database via pgpool? I simply can not find
Is it possible to send encrypted text at all the nodes in replication mode
for PGPOOL II 2.3.3?
Any help please.
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
Hi
I have installed pgpool in /home/megha/pgpool dir.
I found pgpool.pid file in /tmp folder.
when I try to start pgpool I get this error.
*pid file found but it seems bogus. Trying to start pgpool anyway..*
Please help me!
Thanks,
--
Megha
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
Hello there!
I am currently evaluating the best solution for a high-availability,
load balanced cluster.
Currently I am testing this environment : postgres 8.3.1, pgpool-II
2.1, Slony-I 1.2.14.
I've setup a master server to replicate all tables with Slony-I to a
slave, and a frontend with p
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
1 - 100 of 162 matches
Mail list logo
