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
1
vote
1 answer

Load balancing PostgreSQL with Windows Servers

I have a question concerning the possibilities of load balancing when using PostgreSQL with Windows Servers. On Unix systems this is made possible by using pgpool-II. How can I achieve the same with Windows? I know that you cannot mix systems when…
Konrad
  • 1,014
  • 1
  • 13
  • 24
1
vote
1 answer

Node.JS and pgpool versions

I am trying to call postgress via pgpool (pgpool-II) using node.js 'pg' module. If anyone had got that kind of setup working, what is the right version of pgpool-II and right version of 'pg' that are known to work together? From what I found some…
Yaron Naveh
  • 23,560
  • 32
  • 103
  • 158
1
vote
1 answer

pgpool handling of CTEs with UPDATE

I'm running pgpool-II with load balancing enabled, such that it is sending read-only queries to both servers in my cluster. However, there are some cases where I have CTE queries that contain UPDATE commands, but the underlying query is a SELECT, so…
Jeremy Wilson
  • 509
  • 1
  • 4
  • 16
1
vote
5 answers

configure: error: libpq is not installed or libpq is old

I'm trying to install pgpool-II in Ubuntu 13.10 environment. I'm following this tutorial to get it done. I get below error. configure: error: libpq is not installed or libpq is old From the docs. Note: pgpool-II requires libpq library in…
Techie
  • 44,706
  • 42
  • 157
  • 243
1
vote
2 answers

pgpool-II: is possible to promote a node to master more than one time?

I have this configuration with pgpool: "Host-1" master and "Host-2" slave, if "Host-1" go down, pgpool correctly promotes "Host-2" to be the master; but then if "Host-1" return up, pgpool is not aware of this and, if "Host-2" go down, pgpool doesn't…
Gianluca
  • 23
  • 1
  • 5
1
vote
2 answers

Pgpool tries to write to slave machine

It occured only once - pgpool (newest version) allowed application to write to a slave machine. The only error message I have is like that: "cannot execute UPDATE in a read-only transaction", nothing more in postgres logs or anywhere. Anyone had a…
Marek M.
  • 3,799
  • 9
  • 43
  • 93
1
vote
0 answers

How to configure pgpool for reasonable speed

I have a problem with pgpool II configured in master-slave mode with replication on slony. I have configured postgres databases on each server to run as fast as they can and this was verified by me when I set up connection directly to the db…
tobix10
  • 101
  • 3
  • 10
1
vote
1 answer

Npgsql failed to establish connection to CentOS PostgreSQL through PgPool

I have a webapplication in Asp.net connecting to a separate database-server running CentOS with PostgreSQL. This setup works fine. To increase performance on the database-server I'm trying to install and confgure PgPool-II for pooling…
user1097830
  • 11
  • 2
0
votes
3 answers

Issue Connecting to Postgres Pgpool Server with Entity Framework Core

I am encountering an issue while attempting to connect to a PostgreSQL Pgpool server using Entity Framework Core. The setup involves the utilization of the Postgresql HA Helm Chart by Bitnami, which sets up a high-availability PostgreSQL cluster.…
Erdison Berisha
  • 9
  • 2
0
votes
0 answers

postgresql-ha "unable to connect to upstream node" randomly, causing pgpool "kind does not match between main(0) slot[0] (52)"

Environment: kubernetes with istio sidecars injected. I'm using bitnami/postgresql-ha as a database for my airflow, and randomly seeing the below log in my postgresql statefulset with 3 pods (image: bitnami/postgresql-repmgr:15.3.0-debian-11-r8).…
Jasmine H
  • 1
  • 1
0
votes
0 answers

Postgresql HA by Bitnami - Unable to get session context error when trying to create a db from a .NET app

I deployed Postgresql HA Helm Chart by Bitnami on my Kubernetes Cluster and did the configuration based on the provided configuration fields by the Helm chart. I'm getting an error when trying to create a db from a .NET app when using PgPool II's…
Dardan Lubishtani
  • 21
  • 5
0
votes
0 answers

ERROR: cannot execute UPDATE in a read-only transaction Pgpool and Aurora

I am trying to do a POC for my Jira application to have a proxy pgpool which allows me to utilise both reader and writer instance of amazon aurora postgres, the final goal is to have all read only transaction to go to reader instance and remaining…
Sahil Gulati
  • 1
0
votes
0 answers

Whitelist of Heroku Static IP QuotaGuard is timing out to connection to Aurora Postgres

I have a Node JS app hosted on Heroku. The Node JS app has a postgres 14 database that was migrated to Aurora Postgres on AWS. I am now trying to connect the Heroku app to the Aurora Postgres database. In AWS, access to the Aurora Postgres database…
user20186448
  • 1
  • 1
0
votes
0 answers

Difference between pgpool `primary` and watchdog `MASTER` versus the load_balance_node

I have a pgpool with 3 nodes. I have a confusion between the pgpool primary and the watchdog MASTER and the node designated load_balance_node In my setup, the pgpool primary node (according to show pool_nodes output) is : 10.108.104.31 (This is also…
gkns
  • 697
  • 2
  • 12
  • 32
0
votes
0 answers

Load balancing Postgresql Docker

I have a server (debian 11) on which there is a psql container, with an existing database. My number of customers is increasing day by day, so I plan for the future and want to make my server flexible in order to increase my performance according…
mmmhh
  • 11
  • 3
1 2 3
…
14 15