Re: logical Replication

Hi Achilleas,

>Now on the publisher side what does : 
>select * from pg_stat_replication ; 
>tell you? 
Please find the below output:
>*select * from pg_stat_replication ;*
   pid  | usesysid | usename  | application_name | client_addr  |
client_hostname | client_port |          backend_start           |
backend_xmin |   state   |  sent_lsn  | write_lsn  | flush_lsn  | replay_lsn
| write_lag | flush_lag | replay_lag | sync_priority | sync_state

-------+----------+----------+------------------+--------------+-----------------+-------------+----------------------------------+--------------+-----------+------------+------------+------------+------------+-----------+-----------+------------+---------------+------------
 32515 |    78225 |    user | appn               | xxx.xxx.xx.xxx |                
|       411111 | 2018-08-20 11:32:09.636622+05:30 |              | streaming
| 0/69BE27D0 | 0/69BE27D0 | 0/69BE27D0 | 0/69BE27D0 |           |          
|            |             0 | async






--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html