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 will be 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"  
To: "Ha Quan Le"  
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