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
7 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
17 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
14 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
40 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
79 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
101 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
281 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/...
0
votes
0answers
14 views

How will client psql command need to change to connect via pgpool ? Do we always need to specify the pgpool port explicitly in the psql command?

Hi we are playing with pgpool connection pooling. We are running it in the same server where postgres is running. For local client connections , we are specifying the pgpool port in psql command to ...
1
vote
0answers
380 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
73 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
126 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
248 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
324 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
230 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
59 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
22 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
62 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
692 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
222 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
353 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
782 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
851 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
879 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
350 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
4k 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
844 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
755 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
772 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
312 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
842 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
5k 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
318 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
244 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
87 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 |---...
0
votes
1answer
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
125 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
570 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 ...
2
votes
1answer
681 views

What's the data flow between Pgpool, Postgresql and client

I'm new in Pgpool. I want to ask the question, what is the dataflow between Pgpool, Postgresql when client querying data 1/ Client query data to Pgpool, PgPool ask Postgresql Postgresql calculate ...
1
vote
1answer
305 views

Pgpool - semanage config files - which filetype should I choose?

Reffering to problem with pgpool installation : Problem with pgpoolAdmin installation I had a problem with non running pgpooladmin(installation files permission was wrong). I must change file label of ...