Questions tagged [pgpool]

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

Filter by
Sorted by
Tagged with
1
vote
0answers
29 views

pgpool 4.2.1 and postgres 11 streaming replication problem

I've setup a 2+2 pgpool and postgresql cluster. two pgpool nodes in active/standby configuration and a streaming replication between databases All seemed work fine until after some failover and ...
0
votes
0answers
7 views

Pgpool create a cluster node with no application traffic

I have a pgpool cluster with 2 standby and 1 primary node. I am trying to create another node which will get replicated but will not handle any request or application traffic. It will solely be use ...
0
votes
1answer
24 views

support of multiple databases on different hosts by pgpool2

Let's assume We have 2 databases: Database1 is located on host1 and host2 Database2 is located on host3 and host4 If I'll use pgpool2 to connect to these 2 databases with single pgpool config for ...
0
votes
0answers
233 views

pgpool-II and Postgres docker image : automated failover and online recovery via rsa key

I've been following this documentation for pgpool-ii https://www.pgpool.net/docs/latest/en/html/example-cluster.html I'm having a hard time setting up rsa on my postgres streaming cluster built in ...
0
votes
0answers
40 views

Pgpool load balancing for a specific database

we have around 50 databases in QA environment. Please clarify how can I mention in database_redirect_preference_list to enable load balancing only for a single database. Should I need to mention all ...
0
votes
0answers
231 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
188 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
219 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
1answer
815 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
1k 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
153 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
195 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
351 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
531 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
322 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
71 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
29 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
2k 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
153 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
3k 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
913 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
246 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
399 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 ...
4
votes
2answers
1k 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
1k 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
1k 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
449 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
3k 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
6k 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
895 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
2k 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
128 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
908 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
778 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
3k 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
320 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
953 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 ...
4
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
2k 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
322 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
335 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
252 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
93 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
138 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
650 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
760 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 ...