Skip to content

Instantly share code, notes, and snippets.

@nobu666
Created March 8, 2013 06:21
Show Gist options
  • Save nobu666/5114578 to your computer and use it in GitHub Desktop.
Save nobu666/5114578 to your computer and use it in GitHub Desktop.
PostgreSQL replication monitoring
diff -u <(psql DB_NAME -c "select * from pg_current_xlog_location()" -t) <(psql DB_NAME -c "select flush_location from pg_stat_replication" -t)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment