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
0
votes
0 answers

pgpool-II VIP azure

I have setup pgpool-II in azure to load balance between two PostgreSQL cluster. I am using streaming replication to replicate data. Now I am planning to setup VIP so that the auto-failover is automatic. But the VIP address is not externally…
varun7447
  • 574
  • 1
  • 6
  • 27
0
votes
1 answer

Configure pgpool in master_slave mode fails to auth against backend

I am trying to run pgpool on 2+ web servers which also have a rails app, etc. The idea is to have replication via slony or streaming and failover via pgpool. It would also be nice to have queries balanced to the replca, and web server connections…
dwatson
  • 41
  • 1
  • 5
0
votes
2 answers

PostgreSQL : .pcppass file not found, tried other links

I am working on installing PgPoolAdmin on my local ubuntu system for installing it on server later. Currently, I am able to login but I keep getting an error Could not read .pcppass fileFile not found. I have tried this and many other resources, but…
We are Borg
  • 5,117
  • 17
  • 102
  • 225
0
votes
0 answers

how to delete enormously growing pg_xlog while streaming replication?

I am using a replication slot, streaming replication for a standby server. pg_xlog file is growing crazy. I have checked max_wal_size and wal_keep_segment configurations, they all looked reasonable. Is there a way to removed applied logs ? # -…
hece
  • 364
  • 2
  • 15
0
votes
1 answer

pgpool - service don't start: legitimation error

If try to start pgpool I got this error: administrator@Linux-HA-1:/etc/init.d$ service pgpool2 start * Starting pgpool-II pgpool FD - Starting pgpool-II by executing: /usr/sbin/pgpool -n -f /etc/pgpool2/3.5.2/pgpool.conf -F…
post4dirk
  • 313
  • 4
  • 16
0
votes
1 answer

pgpoolAdmin - superuser: unknow (connetion error)

After login i got following message. create -> /var/www/.pcppass #insert:hostname:port:username:password *:*:admin:postgres *:*:postgres:postgres *:*:administrator:postges host$ sudo chown www-data .pcppass ... and it don't works :-/
post4dirk
  • 313
  • 4
  • 16
0
votes
1 answer

pgpoolamin V3.5.2 parameter-check .pcpass Invalide permision

The path is ok, and the .pcppass file has www-data rights. Does anybody an idea who to solve this problem?
post4dirk
  • 313
  • 4
  • 16
0
votes
0 answers

Hibernate session; connected to which server? Using PostgreSQL JDBC Driver with Failover and pgpool-II

The PostgreSQL documentation shows that you can pass multiple hosts in the JDBC string for use with a HA setup (bottom of page): https://jdbc.postgresql.org/documentation/head/connect.html My setup has 3 nodes each with PostgreSQL server running. I…
Jim Clam
  • 117
  • 11
0
votes
1 answer

Can pgpool-II balance PostgreSQL servers with multiple instances each?

I have configured two PostgreSQL 9.5 instances in master-slave mode and could successfully configure PgPool-II for load balancing between them, and failover is just working fine (took me 2 weeks and lots of errors, but it finally worked). My…
iffs
  • 73
  • 7
0
votes
1 answer

node-postgres LEFT JOIN query

I am attempting to effect a join query in node-postgres (pg) with the following function but am getting a syntax error. The problem is the join query, everything else works fine. What is the correct way to format a join query in pg? exports.bigBook…
eabates
  • 878
  • 1
  • 8
  • 22
0
votes
1 answer

node-postgres, express with pg-pool, sending data to Angular frontend

I am pooling connections to my Postgres DB with pg-pool. I am having trouble, however, sending the results of my queries to the frontend. I assumed that I could use res.send as usual but it is not recognized (I also tried return). Here is my…
eabates
  • 878
  • 1
  • 8
  • 22
0
votes
1 answer

Postgres master / slave based on table

Currently I have 1 postgres instance which is starting to receive too much load and want create a cluster of 2 postgres nodes. From reading the documentation for postgres and pgpool, it seems like I can only write to a master and read from a slave…
lennard
  • 523
  • 6
  • 19
0
votes
1 answer

Does pgpool run on cygwin

Do you know if pgpool run with cygwin on windows ? If it does, do know any tutorial ? Thanks,
Yann
  • 1,388
  • 2
  • 11
  • 9
0
votes
0 answers

Postgres DB redundancy/HA server-side (no pgpool or similar)

I start off with my question: how can I setup redundancy with several DBs without having to install anything special on each of the clients? I have seen that the usual way to do it is to install something like pgpool on each client which can handle…
N3sh
  • 881
  • 8
  • 37
0
votes
1 answer

How to route particular select query on master in pgpool 3 postgres...?

My query is, how to route particular select query on a master in pgpool. I have tried black_function_list parameter in pgpool.conf but that did not work out. Also, my pgpool mode is streaming and load balancing is on.
Deepesh Goel
  • 283
  • 1
  • 3
  • 6
1 2 3
…
14 15