Skip to content

Instantly share code, notes, and snippets.

@imcitius
Created August 14, 2018 13:49
Show Gist options
  • Save imcitius/0be62fcbf8fa880a5a6e8f9627719a27 to your computer and use it in GitHub Desktop.
Save imcitius/0be62fcbf8fa880a5a6e8f9627719a27 to your computer and use it in GitHub Desktop.
log master->replica
авг 14 13:48:12 pgsql-main-2 patroni.py[28436]: 2018-08-14 13:48:12,792 INFO: Lock owner: pgsql-main-2; I am pgsql-main-2
авг 14 13:48:12 pgsql-main-2 patroni.py[28436]: 2018-08-14 13:48:12,800 INFO: Got response from pgsql-main-0 http://172.29.10.58:8008/patroni: {"database_system_identifier": "6589191000674292929", "postmaster_start_time": "2018-08-14 13:40:48.148 UTC", "timeline": 23, "xlog": {"received_location": 503504872, "replayed_timestamp": "2018-08-14 13:43:39.465 UTC", "paused": false, "replayed_location": 503504872}, "patroni": {"scope": "pgsql-main", "version": "1.4.5"}, "state": "running", "role": "replica", "server_version": 100005}
авг 14 13:48:12 pgsql-main-2 patroni.py[28436]: 2018-08-14 13:48:12,906 INFO: manual failover: demoting myself
авг 14 13:48:13 pgsql-main-2 patroni.py[28436]: 2018-08-14 13:48:13,057 INFO: Leader key released
авг 14 13:48:15 pgsql-main-2 patroni.py[28436]: 2018-08-14 13:48:15,063 INFO: closed patroni connection to the postgresql cluster
авг 14 13:48:15 pgsql-main-2 patroni.py[28436]: 2018-08-14 13:48:15,095 INFO: postmaster pid=30142
авг 14 13:48:15 pgsql-main-2 patroni.py[28436]: 2018-08-14 13:48:15.102 UTC [30142] LOG: listening on IPv4 address "0.0.0.0", port 5432
авг 14 13:48:15 pgsql-main-2 patroni.py[28436]: 2018-08-14 13:48:15.104 UTC [30142] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
авг 14 13:48:15 pgsql-main-2 patroni.py[28436]: 2018-08-14 13:48:15.108 UTC [30142] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
авг 14 13:48:15 pgsql-main-2 patroni.py[28436]: 2018-08-14 13:48:15.120 UTC [30142] LOG: redirecting log output to logging collector process
авг 14 13:48:15 pgsql-main-2 patroni.py[28436]: 2018-08-14 13:48:15.120 UTC [30142] HINT: Future log output will appear in directory "/var/log/postgresql".
авг 14 13:48:15 pgsql-main-2 patroni.py[28436]: localhost:5432 - rejecting connections
авг 14 13:48:15 pgsql-main-2 patroni.py[28436]: localhost:5432 - accepting connections
авг 14 13:48:22 pgsql-main-2 patroni.py[28436]: 2018-08-14 13:48:22,793 INFO: Lock owner: pgsql-main-0; I am pgsql-main-2
авг 14 13:48:22 pgsql-main-2 patroni.py[28436]: 2018-08-14 13:48:22,793 INFO: does not have lock
авг 14 13:48:22 pgsql-main-2 patroni.py[28436]: 2018-08-14 13:48:22,793 INFO: establishing a new patroni connection to the postgres cluster
авг 14 13:48:22 pgsql-main-2 patroni.py[28436]: 2018-08-14 13:48:22,806 INFO: no action. i am a secondary and i am following a leader
авг 14 13:48:33 pgsql-main-2 patroni.py[28436]: 2018-08-14 13:48:33,027 INFO: Lock owner: pgsql-main-0; I am pgsql-main-2
авг 14 13:48:33 pgsql-main-2 patroni.py[28436]: 2018-08-14 13:48:33,027 INFO: does not have lock
авг 14 13:48:33 pgsql-main-2 patroni.py[28436]: 2018-08-14 13:48:33,030 INFO: no action. i am a secondary and i am following a leader
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment