Re: Live steraming replication setup issue!

The WAL records in receive and replay means the same WAL record, please see below :

postgres=# select pg_xlogfile_name('796/BA9D8000');
     pg_xlogfile_name    
--------------------------
 0000000100000796000000BA
(1 row)

postgres=# select pg_xlogfile_name('796/BA9D7FF0');
     pg_xlogfile_name    
--------------------------
 0000000100000796000000BA
(1 row)

That means the replication is continuously streaming and may behind few WAL records. Do you see the lag all the time ? Did you test if the replication is working fine ?

You can check that via pg_controldata as well. What does sync_state in pg_stat_replication say ?

Regards,

Venkata B N

Fujitsu Australia