psql
command. It also understands the same environment variables and .pgpass
file that other PostgreSQL CLI tools do.pgmetrics
binary to an EC2 instance with access to the database.pgdash
binary to the same EC2 instance as before.psql
like this:pgmetrics
using the same arguments:wheel
is a user with superuser privileges, but you can use any credentials that have access to the pg_catalog
schema..pgpass
files, using trust
authentication and client certificates. You can even directly supply the password in plain-text, like this:-f json
option for this:shared_preload_libraries
includes auto_explain
.shared_preload_libraries
, a reboot of the database instance will be required.