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" <michael(dot)paquier(at)gmail(dot)com>
To: "Ha Quan Le" <nlp(dot)sr(at)shaw(dot)ca>
Cc: pgsql-bugs(at)postgresql(dot)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