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
14
votes
2 answers

django 1.7 and connection pooling to PostgreSQL?

What are the differences between the django apps (Django-PostgresPool, djorm-ext-pool, django-db-pool) and PG Bouncer or PG Pool? Do the apps use one of the last two packages? In this article, the author says that there is a patch starting with…
Michael
  • 8,357
  • 20
  • 58
  • 86
12
votes
2 answers

Java queries against PGPool II cause "unnamed prepared statement does not exist" errors

I have a Java app that uses a Postgres database and I'm trying to introduce PGPool in order to scale up my database. I'm running into a problem where Postgres throws the following error: unnamed prepared statement does not exist. After cranking up…
Mark B
  • 183,023
  • 24
  • 297
  • 295
11
votes
2 answers

Deploying a high availability Postresql 9.0 on Amazon EC2 with PGPool-ii

We have an existing web application that uses Postgresql 9.0 and PGPool-ii. I am thinking of migrating our infrastructore to Amazon EC2 and was inspired by the following link:…
Mike
  • 111
  • 1
  • 3
10
votes
1 answer

What's the difference between pgpool II replication and postgresql replication?

I'm not exactly a DBA, so I would appreciate easy to understand responses. I have to provide replication to our DB and pgpool seems more convenient because if one postgresql instance fails, the clients are not required to change anything to keep on…
nique21
  • 101
  • 1
  • 4
9
votes
1 answer

Slony and PGPool for fail-over

We're considering Slony and PGPool as alternatives to handle failover in our application -and it seems like since we're gonna need at least two DB servers, we could take advantage of load balancing too- Under which circumstances Slony is better than…
SDReyes
  • 9,798
  • 16
  • 53
  • 92
9
votes
4 answers

Postgres 9.0 and pgpool replication : single point of failure?

My application uses Postgresql 9.0 and is composed by one or more stations that interacts with a global database: it is like a common client server application but to avoid any additional hardware, all stations include both client and server: a main…
doc
  • 91
  • 1
  • 2
8
votes
1 answer

pgpool2 load balancing not working

I have a Python/Django app that will require database load balancing at some point in the near future. In the meantime I'm trying to learn to implement pgpool on a local virtual machine setup. I have 4 Ubuntu 12.04 VMs: 192.168.1.80 <- pool,…
gdonald
  • 984
  • 2
  • 12
  • 23
8
votes
2 answers

pgpool-II authentication failure

I am using pgpool-II 3.2.1 in from of two PostgreSQL 9.1 configured as master-hot standby. When trying to authenticate from PGAdmin I get: Error connecting to the server: FATAL: password authentication failed for user "postgres" In pgpool logs I…
ftraian
  • 658
  • 1
  • 7
  • 21
7
votes
1 answer

PHP PDO PGPOOL PGSQL - SQLSTATE[HY000]: General error: 7 no connection to the server

I try to explain the problem I have!!! I use PDO extension to connect to PostgreSQL through pgpool-II. It works fine within Apache, but from PHP CLI (on the same machine) I receive this PDO error: SQLSTATE[HY000]: General error: 7 no connection to…
user1829243
  • 119
  • 2
  • 5
6
votes
1 answer

psql non-select: how to remove formatting and show only certain columns?

I'm looking to remove all line drawing characters from: PGPASSWORD="..." psql -d postgres -h "1.2.3.4" -p 9432 -c 'show pool_nodes' -U owner node_id | hostname | port | status | lb_weight | role …
Steve Amerige
  • 1,309
  • 1
  • 12
  • 28
6
votes
2 answers

pgAdmin connection error to pgpool

I'm using pgAdmin III to manage my database from client. I have a master and a slave postgreSQL running in streaming replication mode. There's another pgpool server in front of them to do connection pooling and load-balancing. When I was connection…
J Freebird
  • 3,664
  • 7
  • 46
  • 81
6
votes
2 answers

A good PgPool II configuration

I have been trying to configure PgPool to accept a requests of about 150. Postgres server is configured to accept only 100 connections. Anything beyond 100 need to be pooled by PgPool. I don't seem to get that. I only require PgPool to queue the…
Murali_dharan_raju
  • 79
  • 1
  • 3
  • 8
5
votes
0 answers

Spring Data JPA: Can't Find Inserted Entity From Another Thread

I Insert an entity in main thread, then in another thread I try to read a field (modifiedAt) of that inserted entity by a JPA Query with Spring JPA Repository. interface SettlementRepository : JpaRepository { /** *…
youhans
  • 6,101
  • 4
  • 27
  • 39
5
votes
2 answers

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 receiving more request than the slave even when I…
Juan I. Morales Pestana
  • 1,057
  • 1
  • 10
  • 34
5
votes
0 answers

Should I disable Knex.js connection pool in HA setup?

I have a High Availability setup where data flows as such: ... <-> Objection.js <-> Knex.js (pool) <-> Pgpool-II (pool) <-> PostgreSQL Cluster As you see, the connection pool is being managed in two places right now - Knex.js and Pgpool-II. I am…
demisx
  • 7,217
  • 4
  • 45
  • 43
1
2 3
…
14 15