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
3 answers

Primary and standby server at different timelines in postgres

I am very new to postgres and being new I got stuck at a point and need some help, please pardon if you find it silly. I am doing a pgpool HA and at postgres level i have streaming replication between 3 nodes of postgresql-9.5 - 1 master and 2…
subhojit_paul
  • 31
  • 1
  • 5
0
votes
1 answer

pgpool-II - Load balancing PostgreSQL instances

I'm using pgpool2 version 3.5.1 where there are 4 PostgreSQL 9.1 instances which has 16GB and 8 cores running on Ubuntu. This is the pgpool.conf file. As you can see in the conf file there are 4 instances which are backend_hostname0 = '192.168.7.35'…
Techie
  • 44,706
  • 42
  • 157
  • 243
0
votes
1 answer

Add a new Postgresql node to pgpool

I am planning to use a pgpool instance with 2 Postgresql databases only to run parallel query without replication. Can I add a new node to pgpool without blocking the whole system? Thanks a lot
Priscy
  • 2,303
  • 2
  • 10
  • 6
0
votes
1 answer

pgpool Setup on Database Server

I have three servers. One is running pgpool, another two in master-slave mode streaming replication. When installing pgpool, I was suggested to install the pgpool_regclass on my database servers as well. There's no problem installing it in the…
J Freebird
  • 3,664
  • 7
  • 46
  • 81
0
votes
2 answers

Connecting two servers with PgPool

I'm trying to configure pgpool to use load balance between two servers (Both running Debian 8.2 and Postgresql 9.4). I already have Streaming Replication working between the two (Master in 153 and Slave in 155). Now I installed PgPool and configured…
Mauricio Cacho
  • 101
  • 3
0
votes
1 answer

Can we install PGPool on Master/StandBY Postgres DB Server

As per the standard practice, we install the PGPool in separate instances. This increases a separate hardware for PGPool. Although, they are in HA mode it consumes minimum 2 servers. So instead of doing this, can we install it on Master/Standby…
Mandar Pimplapure
  • 3
  • 4
0
votes
0 answers

PG-POOL settings issue

I have pgpool installed on my server but I am facing issue while optimising it. I have 2 different queries running on the same table- 1st is update query which runs every 1 min and query exec time is around 30 secs. So technically it is running…
Ritesh Kumar
  • 75
  • 1
  • 10
0
votes
1 answer

Pg_pool and Slony together for Postgresql Cluster setup

we have 4 postgresql servers. Is it good idea to setup slony replication in 3 nodes(1 master and 2 nodes) and pgpool for load balancing with master node??? Thanks in advance.
chanti king
  • 83
  • 1
  • 7
0
votes
2 answers

Cannot connect to PGpool in virtual machine

I'm tring to setup a simple master/slave replication between two PostgreSQL instances, each running in a virtual machine in two different hosts. Both virtual machines have a NAT configuration, with the following port forwarding rules: PROTO HOST …
Homero C. de Almeida
  • 199
  • 1
  • 8
0
votes
1 answer

PgPool Replication - Directly insert into Master, will it replicate to the Slave

I am looking at PostgreSQL 9.4 Streaming Replication with PgPool for Load Balancing vs. using PgPool replication. Since PgPool replication is statement / middleware based does it mean that if I directly update the Master outside of PgPool it will…
DS1
  • 3
  • 2
0
votes
1 answer

Can pgpool manage sessions since the server application keep connections after they're no longer active?

I have an server applications with datasnap and delphi 2010 (this version have some problems managing sessions), and I have to terminate the idle sessions in postgres once a day. I've installed pgpool but it doesn't make any difference, so, did I…
Lucas Steffen
  • 1,244
  • 2
  • 10
  • 22
0
votes
2 answers

Pgpool-II. Two Database on same pgpool server

my question is about the number of Postgres Databse pgpool can manage. I have two servers: Node 1: pgpool postgreSQL Node 2: postgreSQL I have two database: DB1 and DB2. I can connect from app server to DB1 throught pgpool on port…
juaruelo
  • 1
0
votes
1 answer

PgPool like failover for MySQL - Currently using HAProxy

I'm running MySQL servers load balanced via HAProxy. But I need to perform some action whenever a node (MySQL) goes down or comes up, like we do in PgPool-II. Example: When ever MySQL-1 goes down, I also want to shutdown my WebServer-1. (STONITH…
Shan
  • 2,141
  • 2
  • 17
  • 32
0
votes
1 answer

PGpool Promote to master and Slaves wont replicate on failure

(version pgpool-II-pg93-3.4.0-3pgdg.rhel6.x86_64.rpm) I’ve seen some chat online about this from a while back, but I haven’t found a solve. I have 2 pgpool servers running streaming replication and load balancing. They connect to 3 postgres servers.…
Rob
  • 409
  • 4
  • 20
0
votes
1 answer

relation "branches" does not exist pgbench-tools and postgresql database scale returned ""

I've installed postgresql 9.1 on ubuntu 12.04 with pgpoolII-3.3.3 and pgPoolAdmin. I'm trying to make a test with pgbench-tools to measure the performance of postgresql. So I move to the directory where is pgbench-tools and configure the config…
Cesar
  • 131
  • 2
  • 7
1 2 3
…
14
15