The below code snipet was created to check the number of rows in a PostgreSQL database, log the output to a file, and warn if the number of rows is over a certain number. There are numerous variables in the code snipet below that will need to be modified for it to work properly including message, notify, dbuser, and logfile. This code was created on CentOS some other items could be different including the location of the date command.

This script can be run as follows: checkrows $host $database

Read the rest of this entry »

Checking the number of rows in a PostgreSQL table is very easy. First connect to the database by using pgsql.

psql -U postgres -d "database-name"

Next use the following command to see the number of rows in a certain table.

select count(*) from tablename