psql -U user db
\l # list databases
\c db # connect to database
\dt # list tables
mastodon
setting up nagios monitoring
- download check_postgres plugin
cd /opt/nagios/custom_plugins
wget "https://bucardo.org/downloads/check_postgres.tar.gz"
tar xf check_postgres.tar.gz
cd check_postgres...
./check_postgres.pl --symlinks
- open port on mastodon server
iptables -A INPUT -p tcp -s laundry.tilde.gdn --dport 5432 -m state --state NEW,ESTABLISHED -j ACCEPT
https://www.digitalocean.com/community/tutorials/how-to-monitor-your-managed-postgresql-database-using-nagios-core-on-ubuntu-18-04