Its fairly straight forward to monitor a postgresql table’s activity with the wonderful script check_postgres.pl created by Greg Sabino Mullane. This script is useful for so many things I will surely be writing about other ways to use this script with Nagios and Cacti.

1. Download Script: Download the check_postgres.pl script here.

Read the rest of this entry »

Tags: .pgpass, /etc, check_postgres.pl, database, libexec, nagios, perl, postgres, PostgreSQL, table

Open PGAdmin and connect to the database where you would like to remove all data from a certain table. Click the SQL (execute arbitrary SQL commands) button. Use the below syntax and all data will be removed.

truncate table table_name

Read the rest of this entry »