| From: | Quan-Ha Le <nlpsr(dot)ha(at)gmail(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | My issues |
| Date: | 2015-08-16 02:43:48 |
| Message-ID: | CALezqWvLgm2ocuMj=gPmSkcDnSZwYJDPMcBRdGmL_021HhPoLQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Dear Postgres support,
May I ask you some 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.
IT manager.
Alberta.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | greg.davidson+pg | 2015-08-16 04:01:11 | BUG #13575: invalid memory request size while storing call arguments into local variables |
| Previous Message | nlp.sr | 2015-08-16 02:35:15 | BUG #13574: Load Balancing |