Using Railroad and Graphviz Blog update (10/22/2007): Thanks to the comment posted by Blog de Kilgore, I tried Railroad (instead of using the below method with starUML) to visualize my RoR app. Very easy to setup and use (see examples on web page). Here’s a quick command to create a .png graphic file of your…
It is not stated clearly on pgAdmin’s site if it will operate on Windows Vista without issue so I decided to download, install and see if there were any issues. First I visited pgAdmin III Windows download page here. On this page it states that pgAdmin III will work with Windows 2000, Windows XP, and…
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. Download Script: Download the check_postgres.pl script here.
This error message was received when attempting to run an NRPE command from the shell. The fill error is below followed by how the issue was resolved. The error has been posted on the next page because of its length.
I imported an old Blogger account into a WordPress blog recently and my titles did not import correctly. So there I was stuck with 500 posts with no titles. I decided the easiest way to fix that would be to copy the post dates from the Blogger account to the titles in WordPress. So here is…
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
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…
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
Troel has written a great summary of the SQL standard for the timestamp data type along with its implementation in the big 5 databases (MySQL, PostgreSQL, Microsoft SQL Server, Oracle, and DB2). MySQL It turns out that MySQL does not support sub-second time or date formats. There is a MICROSECOND function in MySQL allowed to…