HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMinor

How to quickly test if postgres database is accessible?

Submitted by: @import:stackexchange-devops··
0
Viewed 0 times
quicklypostgresaccessibledatabasetesthow

Problem

I whished there were a tool like ping for databases? I just want to ping the database and see if it is accessible from a remote server from Linux command line (bash).

I read about telnet, but I am not sure how it works.

Any suggestions?

Solution

Something like:

pg_isready --host=192.168.79.8 --username=test --port=5432


192.168.79.8:5432 - no response

Another solutions is telnet:

telnet 192.168.79.8 5432


Which returns:

Trying 192.168.79.8...
Connected to 192.168.79.8.
Escape character is '^]'.

If the database is accessible.

Code Snippets

pg_isready --host=192.168.79.8 --username=test --port=5432
telnet 192.168.79.8 5432

Context

StackExchange DevOps Q#14789, answer score: 7

Revisions (0)

No revisions yet.