Skip to content

Instantly share code, notes, and snippets.

@95gabor

95gabor/spilo.md

Last active January 30, 2025 16:47
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save 95gabor/6f00f64baa34a74c6d122fd0d61ac06f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save 95gabor/6f00f64baa34a74c6d122fd0d61ac06f to your computer and use it in GitHub Desktop.
Download ZIP
postgres cluster, spilo, patronictl
Raw
spilo.md

PostgreSQL cluster commands

Spilo cluster commands

List cluster info

patronictl list

Recover when there is at least one member with running state

patronictl failover
# patronictl failover --candidate postgres-0

Re-init member

patronictl reinit

Check DB connection

psql -H $POSTGRES_SERVICE_HOST -U $PGUSER_SUPERUSER -d $SCOPE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment