Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

PostgreSQL replication delay/lag

I think the best one would be 2 combined with a check if the wal receiver process is running before running that
query with something like:

$ ps aux | egrep 'wal\sreceiver'
postgres  3858  0.0  0.0 2100112 3312 ?        Ss   19:35   0:01 postgres:
wal receiver process   streaming 36/900A738
This solution would only be run on the slave and it is pretty easy to setup.


Comments

Popular posts from this blog

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

2017 Shortern URL - Other Website Like ADFOC.US

How to Repair Corrupt database postgresql

How To Schedule PostgreSQL Jobs using pgAgent on Linux plateform

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?