Dear Mr Paquier,
We are now having 2 databases
a) postgres database on 10.236.49.12 (chosen as the master)
b) postgres database on 172.24.22.68 (chosen as the replicated one)
Each server was setup PGBouncer already; 2 servers are configured identically (Ubuntu 14.04.1)
may I ask you: How can we connect pgBouncer on the two databases so that changes on 10.236.49.12's postgres database
willbe automatically replicated onto the 172.24.22.68 ?
How to link the two server by pgBouncer and is there any other guideline?
You bet
Ha.
----- Original Message -----
From: "Michael Paquier" <michael.paquier@gmail.com>
To: "Ha Quan Le" <nlp.sr@shaw.ca>
Cc: pgsql-bugs@postgresql.org
Sent: Tuesday, March 3, 2015 6:41:05 PM
Subject: Re: Re[4]: [BUGS] BUG #12821: Cannot install xlogdump
> is there any statement so that I just run pg_xlogdump with which options so
> that it will show all the WAL log file from the beginning until the end of
> the WAL log instead of viewing each segment and short info? I suppose that a
> 16MB WAL log but only a piece as above?
If you want to see all the content of a given file, simply do not use
-n, you can as well have a look at series of files, like that:
pg_xlogdump $FIRST_SEGMENT_FILE $LAST_SEGMENT_FILE
Note that all those things are explained in the documentation:
http://www.postgresql.org/docs/9.3/static/pgxlogdump.html
--
Michael