From: | nlp(dot)sr(at)shaw(dot)ca |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #13573: Load Balancing |
Date: | 2015-08-16 02:34:46 |
Message-ID: | 20150816023446.2606.75306@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 13573
Logged by: Ha Le
Email address: nlp(dot)sr(at)shaw(dot)ca
PostgreSQL version: 9.4.3
Operating system: Ubuntu 14
Description:
Dear Michael,
It is me, Quan Ha Le from Blackberry company,
This time may you support me with 2 questions:
I have a Master and a Standby by Repmgr Cloning, on a Postgresql Database
cluster
QUESTION 1: Why my pg_xlog for Master is huge up to 8GB and it doesnot clean
up (removal of wal logs) automatically ?
And the pg_xlog for Standby is only 300MB ?
The pg_resetxlog needs running off-line (by service postgresql stop), but
how to run online (during postgresql service still on) because there is a
software connect to my master all the time ?
QUESTION 2: Is there any way to make HAPROXY+PGBOUNCER Load balancing for my
Postgresql Master and Standby ? I can only read /write on the Master and the
Reads donot load balancing to happen at the same time on Standby ?
Best,
Quan Ha Le.
From | Date | Subject | |
---|---|---|---|
Next Message | nlp.sr | 2015-08-16 02:35:15 | BUG #13574: Load Balancing |
Previous Message | Tom Lane | 2015-08-15 16:01:59 | Re: BUG #13571: sql-only extension segfaults backend during creation |