Question : Start log file: 2015-03-06 01:57:56: pid 2760: LOG: Setting up socket for 0.0.0.0:9999 2015-03-06 01:57:56: pid 2760: LOG: […]
Tag: pgpool
PGPool Frequent Queries
Question : We recently setup a PostgreSQL Cluster with PGPool in front of it. This is our first go at […]
.pcppass not working
Question : I run pgpool-II as postgres user so I can replicate exactly what I did in one sequence here […]
PGPool II – Failover when current master node dies
Question : I have a 2 node high-availability postgresql 9.5 cluster. I’m using streaming replication, PGPool II (3.5.4 [ekieboshi]), and […]
PGpool Promote to master and Slaves wont replicate on failure
Question : Sorry for the copy paste from stackoverflow, but this is probably a better place to post this. Version […]
Pgpool – semanage config files – which filetype should I choose?
Question : Reffering to problem with pgpool installation : Problem with pgpoolAdmin installation I had a problem with non running […]
Pooler (pgbouncer) + MasterDB + Slaves
Question : During a spike, my connections go from 30 to over 140, as you can see below: I’m willing […]
In pgPool-II 3.7.5 configuration pgpool.conf, is recovery_user a role or a system user?
Question : I’m having trouble configuing pgPool-II 3.7.5 for online recovery. In pgpool.conf, there is a parameter called recovery_user along […]
Can you make SSL and SSL-only (hostssl) connections to PGPool?
Question : The new version of PGPool (3.2) has an “SSL” section in the conf file, and directions on how […]
PgPool II: Write-Only and Read-Only DBs
Question : I’d like to setup the following infrastructure: PSQL 9.6 in USA (master) PSQL 9.6 in Europe (slave) PgPool-II […]