Skip to content

Instantly share code, notes, and snippets.

@adamzwakk

adamzwakk/pg_recovery_progress.sh

Last active July 15, 2022 10:05
Show Gist options
  • Save adamzwakk/9e69fa1c26ce0fc27e164879a82ded7a to your computer and use it in GitHub Desktop.
Save adamzwakk/9e69fa1c26ce0fc27e164879a82ded7a to your computer and use it in GitHub Desktop.
Download ZIP
Looks up where postgres startup recovery is at in the WAL files
Raw
pg_recovery_progress.sh
ls -l $(sudo lsof -p $(ps aux | grep postgres | grep startup | awk '{print $2}') | grep wal | awk '{print $9}') | awk '{print $6" "$7" "$8}'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment