Check If The Local Server Is Running
An install of PostgreSQL comes with a number of utilities including the pg_isready
command. This command can be used to check if the local PostgreSQL server is up, running, and ready to receive connections.
If the server has not yet been started, running the command will result in a no response
response.
$ pg_isready
localhost:5432 - no response
In this case, the pg_ctl
command can be used to start the server.
$ pg_ctl -D $HOME/.asdf/installs/postgres/12.3/data start
waiting for server to start....
...
done
server started
It tells us that the server is started and we can confirm that by again running pg_isready
.
$ pg_isready
localhost:5432 - accepting connections
This command is most useful as part of a script, such as in a CI environment. In that case, you may not want it writing to stdout
, you just want to use the command's exit code. For that, you can tack on the --quiet
flag.
$ pg_isready --quiet
Last updated
Was this helpful?