{"action":"created","issue":{"url":"https://api.github.com/repos/timescale/timescaledb-docker/issues/40","repository_url":"https://api.github.com/repos/timescale/timescaledb-docker","labels_url":"https://api.github.com/repos/timescale/timescaledb-docker/issues/40/labels{/name}","comments_url":"https://api.github.com/repos/timescale/timescaledb-docker/issues/40/comments","events_url":"https://api.github.com/repos/timescale/timescaledb-docker/issues/40/events","html_url":"https://github.com/timescale/timescaledb-docker/issues/40","id":388743388,"node_id":"MDU6SXNzdWUzODg3NDMzODg=","number":40,"title":"Question: how can we check if timescale has started","user":{"login":"tmtron","id":20422904,"node_id":"MDQ6VXNlcjIwNDIyOTA0","avatar_url":"https://avatars1.githubusercontent.com/u/20422904?v=4","gravatar_id":"","url":"https://api.github.com/users/tmtron","html_url":"https://github.com/tmtron","followers_url":"https://api.github.com/users/tmtron/followers","following_url":"https://api.github.com/users/tmtron/following{/other_user}","gists_url":"https://api.github.com/users/tmtron/gists{/gist_id}","starred_url":"https://api.github.com/users/tmtron/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tmtron/subscriptions","organizations_url":"https://api.github.com/users/tmtron/orgs","repos_url":"https://api.github.com/users/tmtron/repos","events_url":"https://api.github.com/users/tmtron/events{/privacy}","received_events_url":"https://api.github.com/users/tmtron/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-12-07T17:20:08Z","updated_at":"2018-12-12T16:56:31Z","closed_at":null,"author_association":"NONE","body":"Currently I start the docker container and then test every second until `Select 1` returns true.\r\nThis does not work when the database is new: e.g. started for the first time - maybe after restoring a backup.\r\n\r\nIn this case it seems the database is started, shut down and then restarted: at least I suppose so, because I get this error: \"the database system is shutting down\"\r\n\r\nWhat is the recommended way to check if the timescaledb docker image is ready to accept connections?"},"comment":{"url":"https://api.github.com/repos/timescale/timescaledb-docker/issues/comments/446661170","html_url":"https://github.com/timescale/timescaledb-docker/issues/40#issuecomment-446661170","issue_url":"https://api.github.com/repos/timescale/timescaledb-docker/issues/40","id":446661170,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0NjY2MTE3MA==","user":{"login":"RobAtticus","id":1501309,"node_id":"MDQ6VXNlcjE1MDEzMDk=","avatar_url":"https://avatars1.githubusercontent.com/u/1501309?v=4","gravatar_id":"","url":"https://api.github.com/users/RobAtticus","html_url":"https://github.com/RobAtticus","followers_url":"https://api.github.com/users/RobAtticus/followers","following_url":"https://api.github.com/users/RobAtticus/following{/other_user}","gists_url":"https://api.github.com/users/RobAtticus/gists{/gist_id}","starred_url":"https://api.github.com/users/RobAtticus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RobAtticus/subscriptions","organizations_url":"https://api.github.com/users/RobAtticus/orgs","repos_url":"https://api.github.com/users/RobAtticus/repos","events_url":"https://api.github.com/users/RobAtticus/events{/privacy}","received_events_url":"https://api.github.com/users/RobAtticus/received_events","type":"User","site_admin":false},"created_at":"2018-12-12T16:56:31Z","updated_at":"2018-12-12T16:56:31Z","author_association":"MEMBER","body":"Hi @tmtron you can use the `pg_isready` binary, either on your host machine or from the docker image to test if a PostgreSQL/TimescaleDB instance is ready to accept connections. It takes t he same parameters as `psql` so make sure to provide the correct hostname/port"}}
{"actor":{"display_login":"RobAtticus"}}