Questions tagged [pgpool]

middleware between PostgreSQL servers and clients for connection pooling, replication and load balancing

Filter by
Sorted by
Tagged with
0
votes
0answers
23 views

Postgres Replication - WAL sender throw connection reset by peer

Good morning everyone, I hope containment is going well for you. For my part, I use this time to set up a Postgres 11 cluster on my servers, but I have some problems. Can you help me? I've got ...
0
votes
1answer
39 views

pcp_attach_node not working in pgpool 2

I've been working on pgpool2 setup with 2 DB node and I need to attach on the node, which os currently down. when I run postgres@pg-pool:~$ pcp_attach_node -p 9898 -n 1 -U postgres I get following ...
0
votes
1answer
90 views

Master - Master setup on Postgresql 10 + Ubuntu 18.04 + Pgpool II [closed]

Does anybody have experience in configuring Pgpool II with Postgresql 10 on Ubuntu 18.04? I am trying to setup Master - Master setup on Postgresql 10 + Ubuntu. I am trying to use Pgpool II I will ...
0
votes
0answers
15 views

Use pgpool in order to serve the mostly recently replicated Postgresql read-only replica databases?

As seen in this question setting the max_standby_archive_delay and the max_standby_streaming_delay as -1 on a single replica it may cause the replica on long-running queries to have stale data. So I ...
0
votes
0answers
25 views

PostgreSQL + pgpool replication with miss balancing

I have a PostgreSQL replication M-S with pgpool as a load balancer on master server only. The replication is going OK and there is no delay on the process. The problem is that the master server is ...
0
votes
0answers
21 views

Pgpool load balance to multiple read replica

I have one postgresql master and it has 4 read replica(CloudSQL). I want to setup a load balancer for the read replica. But unfortunately we can't do this since its a managed one. So Im thinking ...
0
votes
0answers
87 views

Barman + repmgr failover process

I am about to build a PostgreSQL 11 cluster with Repmgr and Pgpool II, and I want to use Barman for backups. The result will be a PostgreSQL cluster with one master node and two standby nodes: ...
0
votes
0answers
145 views

Repmgr service crashes during automatic failover, slave's upstream node points to failed master - PostgreSQL

We are using Centos7 with PostgreSQL 11.5 and Repmgr 4.4 in our system. We have setup an automatic failover system using Repmgr with a 3 node cluster (1 master - Server A, 2 standbys - Server C and F) ...
0
votes
0answers
208 views

replication & load balancer with postgresql configuration

I configured a master-slave replication server with postgres 9.6 following this doc and all worked fine. When I make changes on master server immediately are replicated to slave server and I cannot ...
0
votes
1answer
426 views

.pcppass not working

I run pgpool-II as postgres user so I can replicate exactly what I did in one sequence here in this post. -bash-4.2$ echo "pgpool:$(pg_md5 test)" > /etc/pgpool-II-11/pcp.conf -bash-4.2$ cat /etc/...
1
vote
0answers
610 views

Pgpool status restore/reset

Need help troubleshooting pgpool issue and reset the status. The “show pool_nodes” shows node 1 is down: postgres@node-0:~$ psql -p 9999 -c "show pool_nodes" node_id | hostname | ...
0
votes
1answer
90 views

Postgres 9.6 - Taking differenctial backup

I have a few CentOS boxes running Postgres 9.6. I am planning a central server which can make local copies of all DBs on the other servers. These servers are accessible via SSH on Internet. What is ...
0
votes
0answers
154 views

no performance improvement with pgpool query result caching

I'm trying to add query result caching to a PostGIS database that's frequently hit with the same (expensive) spatial queries. Looks like pgpool-II is currently the only well-developed solution. ...
1
vote
0answers
302 views

PGPool II + Django w/ psycopg2 load balancing

I've a pool of applications running django 1.6 with psycopg2 on top of a PGPool II with two backends PostgreSQL servers. But all queries (read and/or write) are going to master PostgreSQL even SELECT. ...
1
vote
0answers
402 views

Pgpool executes queries on standby nodes instead of master when replication is behind in standby

I have a postgresql 10 master db with 2 hot standby servers with streaming replication, and the replication is working correctly. The synchronous_commit is setted to remote_write Also I have a pgpool ...
1
vote
0answers
259 views

PGpool not properly detecting which postgres server is master

I am in the process of building a resilient database cluster and currently have 3 database servers running postgres 10 and repmgr. repmgr is taking care of the streaming replication including ...
0
votes
2answers
61 views

In pgPool-II 3.7.5 configuration pgpool.conf, is recovery_user a role or a system user?

I'm having trouble configuing pgPool-II 3.7.5 for online recovery. In pgpool.conf, there is a parameter called recovery_user along with a recovery_password that are somehow used to run ...
1
vote
0answers
27 views

Disconnect specific database from pgpool II

I'm using PostgreSQL 9.5 with pgpool II version 3.4.13 on Ubuntu 16.04.3 I want to drop a specific database so I must disconnect the database from pgpool. How can I do this without disconnecting the ...
1
vote
1answer
1k views

Connecting to Pgpool

Apologies for the long post but i'm stumped on getting Pgpool to work for me. Running Centos7 i have two instances of Postgres running on different ports in master replication mode. I have ...
0
votes
1answer
84 views

PgPool: distro vs upstream?

I'm running PostgreSQL 9.6 and would like to trial pgpool. The yum repository shows the following options: pgpool-II-96 postgresql-pgpool-II Which version should i use ? The documentation on PgPool ...
0
votes
2answers
2k views

Pgpool2 doesn't use the slave for load balancing

I've enabled streaming replication in my postgres 9.5.10 installed from ubuntu xenial repo. I want to enable load balance for pgpool-2 (3.7.0 amefuriboshi) installed from sources. So I have this ...
0
votes
1answer
770 views

PostgreSQL pgpool-II replication mode doesn't work?

I'm experimenting with PostgreSQL and pgpool-II and trying to setup native replication mode on pgpool. The pgpool documentation says In the native replication mode, Pgpool-II is responsible for ...
0
votes
0answers
233 views

Postgresql - Is this possible to setup a Zero downtime PostgreSQL Cluster?

I have already asked here about PostgreSQL HA setup, and I got many possible answers. But the bad thing is, even though if I use any third party software like PGpool, Repmgr, pacemaker are asking for ...
1
vote
0answers
367 views

pgpool-II configuring multiple masters and slaves

Actualy I did create a replication system using Pgpool2, with master/slave servers, now i need to add multiple master servers and I need them to be related and updated across each other. Is it ...
3
votes
1answer
899 views

PGPool memory requirements

What amount of physical memory is recommended for a dedicated PGPool machine running connection pooling & load balancing, but no query cache? I see num_init_children(96) * max_pool(2) * ...
1
vote
1answer
922 views

Troubleshooting PgPool Query Lags

I have been using PGpool-II for quite a while but just noticed an intermittent lag (slow request taking about 20s to execute) which I am able to replicate consistently. Before I explain here is a ...
0
votes
1answer
984 views

PgPool II: Write-Only and Read-Only DBs

I'd like to setup the following infrastructure: PSQL 9.6 in USA (master) PSQL 9.6 in Europe (slave) PgPool-II in Europe App Server in Europe (it reads the DB in 90% of time). My ...
2
votes
0answers
383 views

Pgpool II and Postgresql upgrade scenario using different major versions

Pgpool FAQ states that: You cannot mix different major versions of PostgreSQL, for example 8.4.x and 9.0.x And the reason that I understand very well is: Pgpool-II assumes messages from ...
0
votes
2answers
2k views

PGPool II - Failover when current master node dies

I have a 2 node high-availability postgresql 9.5 cluster. I'm using streaming replication, PGPool II (3.5.4 [ekieboshi]), and a virtual (or floating) secondary IP all hosted on aws to accomplish this. ...
3
votes
1answer
5k views

Why PgPool showing all the nodes as standby even though pg_is_in_recovery() shows correctly? [closed]

I have a set up where I have 1 pgpool, 1 primary postgres and 2 standby postgres. And I am seeing following issues: Issue 1 : Pgpool is not able to detect primary and says all are standby. [root@ip-...
2
votes
0answers
875 views

Using PGPool with RDS Slave replicas, any advice?

I have a Postgres 9.4 RDS instance with Multi AZ, and there's a slave, read-only replica. Up to this point the load balancing was made in the business layer of my app, but it's inneficient and I was ...
2
votes
1answer
1k views

Automatic recovery of the failed postgresql master node is not working with pgpool II

I am new to Postgresql and Pgpool II setup. I have configured the Postgresql HA/Load balancing using Pgpool II and Repmgr. I have followed the link to do the setup. The setup consist of 3 nodes and ...
1
vote
0answers
125 views

Pgpool slave node limit

I've started a new database architecture using pgpool-II 3.4.5, I have 3 servers by now, 1 master and 2 slaves. They are configured to use Master/Slave conf and LoadBalancing. The problem is: When I ...
0
votes
1answer
834 views

Pooler (pgbouncer) + MasterDB + Slaves

During a spike, my connections go from 30 to over 140, as you can see below: I'm willing to set-up a pooler like pgbouncer, but have some questions as my scenario is not that easy: 1 Load Balancer ...
1
vote
1answer
776 views

PGPool for Postgres load balancing, where to sit it

So I've been doing a stack of reading. I'm still not 100% clear of the best way to go about it. Let's take a simple setup. 3 nodes to server UWSGI apps (in random), 3 nodes for PGSQL, 1 nominal ...
9
votes
2answers
2k views

Postgres with pgpool architecture

Below is an example pgpool architecture: This implies that you only need to have pgpool on a single server; is this true? When I look at the configuration I also see that you configure backends ...
1
vote
0answers
316 views

Connecting Tableau and PgPool

I'm trying to connect Tableau to our database Postgresql via PgPool, for load Balance. I have Postgresql configured with Streaming Replication between one master and two slaves. And have another ...
1
vote
2answers
5k views

pgpool load balancing is sending all queries only to master

My two postgresql servers are configured for streaming replication, which is working fine. Pgpool is configured for Master Slave mode / Load Balance Mode. pgpool.conf: listen_addresses = '*' port = ...
1
vote
0answers
880 views

Master/Slave - streaming replication restrict function to master

How can I run a function a on master only? I don't want to connect directly to my master server, because the master server might change. Or can I change my function to work on this setup? Because ...
3
votes
1answer
6k views

Pgpool II : unable to read message length between two network interfaces

Start log file: 2015-03-06 01:57:56: pid 2760: LOG: Setting up socket for 0.0.0.0:9999 2015-03-06 01:57:56: pid 2760: LOG: Setting up socket for :::9999 2015-03-06 01:57:56: pid 2760: LOG: pgpool-...
0
votes
1answer
1k views

PGpool Promote to master and Slaves wont replicate on failure

Sorry for the copy paste from stackoverflow, but this is probably a better place to post this. Version pgpool-II-pg93-3.4.0-3pgdg.rhel6.x86_64.rpm I’ve seen some chat online about this from a ...
1
vote
0answers
311 views

Pgpool load-balancing vs. consistency

In what ways is consistency weakened when using pgpool-II load-balancing on Postgresql servers running streaming replication? Obviously with asynchronous replication you can insert a row on the ...
1
vote
1answer
3k views

pgpool-II doesn't execute my failover script

I have been installed pgpool-II 3.3.4 from source. I have two pgpool nodes and I also used the watchdog configuration to get a pgpool services with High Availability. When I stop one, the other wake ...
0
votes
1answer
322 views

Using pgpool and PostgreSQL in differents hosts.

I want to use pgpool but I did some research and I have a doubt, if neccesary install PostgreSQL and pgpool in the same machine? When I did my first configuration and installation in a same host. But ...
1
vote
0answers
247 views

how to get pgpool2 HA

I am using pgpool2 and PostgreSQL to get a HA of postgresql service. I have been working in this: .-----. .--------. | | W | DB | | PGP |-----+-----------...
1
vote
0answers
88 views

Does pg-pool-II support two phase commit?

When pg-pool II is used with sharding, what happens if I want to do a transaction which involves two nodes ? Does pgpool support two phase commit ?
4
votes
1answer
3k views

timeline 2 of the primary does not match recovery target timeline 1

I want to create a configuration with postgresql and pgpool to get height availability (HA). I want to do this: .-----. .--------. | | W | DB | | APP |---...
1
vote
2answers
1k views

PostgreSQL synchronous replication time out?

I'm using PostgreSQL 9.3 with synchronous replication. I have 2 synchronous replicators and 1 async replicator. My problem is when 2 synchronous replicators are down, transaction will wait ...
1
vote
0answers
131 views

Understanding pg-pool in details

I have following problem regarding the pg-pool (3.3.3) When master fails, automatic failover happens and standby is promoted to master. But this new master don't have any replicators. Other slave ...
0
votes
2answers
600 views

Connect Jira to Postgresql with Pgpool-II

I gotta problem with connecting Jira 6 to Pgpool-II which is responsible for load balancing and replication in Postgresql bases(2 instances). Pgpool is started on port 9999, I just want to connect ...