Stack Overflow
Stack Overflow

Questions tagged [pgpool]

Pgpool-II is a middleware between PostgreSQL servers and clients for connection pooling, replication and load balancing

pgpool wiki

225 questions
5
votes
2 answers

Connection pool using pg-promise

I'm using Node js and Postgresql and trying to be most efficient in the connections implementation. I saw that pg-promise is built on top of node-postgres and node-postgres uses pg-pool to manage pooling. I also read that "more than 100 clients at…
michalDia
  • 61
  • 1
  • 6
5
votes
1 answer

In pgpool while using delete query inside postgresql function ,it is not deletingdata from all servers

I have created following function in pgpool . CREATE OR REPLACE Function fun1(Id int) RETURNS boolean as $executionStatus$ DECLARE BEGIN DELETE FROM table1 where table1_id = Id ; DELETE from table2 where table2_id = Id ; DELETE from…
Priyesh Karatha
  • 604
  • 5
  • 18
5
votes
3 answers

pid file disappears after starting pgpool with ubuntu and postgresql

I´ve installed postgresql 9.1 on ubuntu 12.04 with pgpoolII-3.3.3 and pgPoolAdmin If I try to run pgpool from a terminal with sudo pgpool it seems to start. Viewing ubuntu file explorer I can see how a pgpool.pid file is created at…
Cesar
  • 131
  • 2
  • 7
5
votes
0 answers

How to properly get connections from pgPool-II with JDBC in the case of a multi-user application?

My company plans to use pgPool-II in order to benefit of its "Fail Over", "Load Balancing" (and eventually "Replication") features. We consider here that we have a J2EE Tomcat web application hosted by a servers cluster where Jakarta Tomcat…
Antonin
  • 181
  • 2
  • 11
4
votes
0 answers

how to solve pg pool error connection to front end

I am using pgpool for managing postgres databases cluster that deployed with k8s, and I faced this error: ERROR: unable to read data from front end DETAIL: EOF encountered with front end anyone know about this?
Morteza Bonakdar
  • 43
  • 5
4
votes
1 answer

PostgreSQL synchronous replication consistency

If we compare multiple types of replication (Single-leader, Multi-leader or Leaderless), Single-leader replication has the possibility to be Linearizable. In my understanding, Linearizability means that once a write completes, all later reads should…
Стефан Цолић
  • 117
  • 1
  • 10
4
votes
1 answer

Manage conflicts and lag on Postgres Replication in Hot Standby with read heavy Slave

Requirement: Avoid terminating connection due to conflict with recovery error and also have acceptable replication lag. Google Cloud PostgreSQL 9.6, Replication turned on (uses Streaming replication), PGPool-II set to only do load balancing and with…
Khushbu
  • 295
  • 4
  • 14
4
votes
0 answers

How to configure Tomcat JDBC Pool for a load balanced cluster (like PostgreSQL Master-Slave Replication)

Let's assume there is a PostgreSQL cluster consisting of a single master node and two read-only replicas via streaming replication. How can I configure Tomcats DBCP to be aware that there are several different nodes within the db cluster, thus…
Mahatma_Fatal_Error
  • 720
  • 1
  • 10
  • 26
4
votes
3 answers

pgpooladmin 3.5.2 Error code e1014 could not read .pcppass file

That the error looks like The right's are Anyone there to solve the problem?
post4dirk
  • 313
  • 4
  • 16
4
votes
2 answers

Can't use PGPool with Amazon RDS Postgres

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 inefficient, and I was hoping to use PGPool, so the app interacts with a…
ffflabs
  • 17,166
  • 5
  • 51
  • 77
4
votes
1 answer

PGPool 'SHOW pool_nodes' returns 'ERROR: unrecognized configuration parameter "pool_nodes"' over jdbc

I have successfully configured our application with PGpool, and I must say, it is pretty awesome. I am trying to expose information about the PGPool cluster in our app, and I'm having trouble using 'SHOW' commands over JDBC with the postgres Driver.…
eric
  • 2,699
  • 4
  • 29
  • 40
4
votes
3 answers

Postgresql 9.2 failover

I have set up streaming replication from a master DB to a slave DB. If the master is shut down, the slave will take over. The replication and failover works fine. I have a web app using the master database for storing data. Some details: Both…
Zaute
  • 95
  • 1
  • 8
3
votes
0 answers

PgPool-II backend authentication failed

I'm trying to configure pgpool as the load balancer for my Postgres cluster. I have two postgres nodes, 1 master and 1 slave. My pg_hba.conf looks like hostssl user mydb 1.1.1.1/32 md5 hostssl user postgres 1.1.1.1/32 md5 host user mydb …
Ghoul
  • 149
  • 5
3
votes
1 answer

Synchronous vs asynchronous streaming replication for Postgres with PgPool

After reading the documentation of PgPool I was left confused which option would suit my use case best. I need a main database instance which would serve the queries and 1 or more replicas (standbys) of the main one which would be used for disaster…
vsir
  • 349
  • 2
  • 12
3
votes
1 answer

What exactly does a connection pool for databases like PostgreSQL do?

I know the general idea that a connection pool is a pool of reusable connections that speeds up traffic to the database because it can reuse connections instead of constantly creating new ones. But this is a very high level explanation. It doesn't…
Martin01478
  • 387
  • 1
  • 5
  • 16
1
2
3
…
14 15