Re: BUG #12821: Cannot install xlogdump

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