Skip to content

Instantly share code, notes, and snippets.

@imcitius
Created August 14, 2018 13:52
Show Gist options
  • Save imcitius/68a8fda9c4bc8a382b01f6435a218312 to your computer and use it in GitHub Desktop.
Save imcitius/68a8fda9c4bc8a382b01f6435a218312 to your computer and use it in GitHub Desktop.
curl from all nodes
>> curl -v pgsql-main-0.node.cluster-dev.consul:8008/master
* Trying 172.29.10.58...
* TCP_NODELAY set
* Connected to pgsql-main-0.node.cluster-dev.consul (172.29.10.58) port 8008 (#0)
> GET /master HTTP/1.1
> Host: pgsql-main-0.node.cluster-dev.consul:8008
> User-Agent: curl/7.59.0
> Accept: */*
>
* HTTP 1.0, assume close after body
< HTTP/1.0 200 OK
< Server: BaseHTTP/0.3 Python/2.7.5
< Date: Tue, 14 Aug 2018 13:50:48 GMT
< Content-Type: application/json
<
* Closing connection 0
{"database_system_identifier": "6589191000674292929", "postmaster_start_time": "2018-08-14 13:40:48.148 UTC", "timeline": 24, "xlog": {"location": 503507496}, "patroni": {"scope": "pgsql-main", "version": "1.4.5"}, "replication": [{"sync_state": "sync", "sync_priority": 1, "client_addr": "172.29.9.154", "state": "streaming", "application_name": "pgsql-main-2", "usename": "replicator"}, {"sync_state": "async", "sync_priority": 0, "client_addr": "172.29.9.189", "state": "streaming", "application_name": "pgsql-main-1", "usename": "replicator"}], "state": "running", "role": "master", "server_version": 100005}
>> curl -v pgsql-main-1.node.cluster-dev.consul:8008/master
* Trying 172.29.9.189...
* TCP_NODELAY set
* Connected to pgsql-main-1.node.cluster-dev.consul (172.29.9.189) port 8008 (#0)
> GET /master HTTP/1.1
> Host: pgsql-main-1.node.cluster-dev.consul:8008
> User-Agent: curl/7.59.0
> Accept: */*
>
* HTTP 1.0, assume close after body
< HTTP/1.0 503 Service Unavailable
< Server: BaseHTTP/0.3 Python/2.7.5
< Date: Tue, 14 Aug 2018 13:50:51 GMT
< Content-Type: application/json
<
* Closing connection 0
{"database_system_identifier": "6589191000674292929", "postmaster_start_time": "2018-08-14 13:48:15.337 UTC", "timeline": 24, "xlog": {"received_location": 503507496, "replayed_timestamp": null, "paused": false, "replayed_location": 503507496}, "patroni": {"scope": "pgsql-main", "version": "1.4.5"}, "state": "running", "role": "replica", "server_version": 100005}
>> curl -v pgsql-main-2.node.cluster-dev.consul:8008/master
* Trying 172.29.9.154...
* TCP_NODELAY set
* Connected to pgsql-main-2.node.cluster-dev.consul (172.29.9.154) port 8008 (#0)
> GET /master HTTP/1.1
> Host: pgsql-main-2.node.cluster-dev.consul:8008
> User-Agent: curl/7.59.0
> Accept: */*
>
* HTTP 1.0, assume close after body
< HTTP/1.0 200 OK
< Server: BaseHTTP/0.3 Python/2.7.5
< Date: Tue, 14 Aug 2018 13:50:55 GMT
< Content-Type: application/json
<
* Closing connection 0
{"database_system_identifier": "6589191000674292929", "postmaster_start_time": "2018-08-14 13:48:15.121 UTC", "timeline": 24, "xlog": {"received_location": 503507496, "replayed_timestamp": null, "paused": false, "replayed_location": 503507496}, "patroni": {"scope": "pgsql-main", "version": "1.4.5"}, "state": "running", "role": "replica", "server_version": 100005}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment