So, I encountered a situation the other day where we were having an issue with hosting some of our blogs. Without wanting to go into the issue too far, we wanted to simplify the setup of one of our websites…
Cacti is a great tool for graphing almost anything that talks SNMP. You can use it to graph server performance, file system usage, router interfaces, bandwidth usage, temperature, etc… Because so many have created their own templates for it, there…
Here are some more helpful postgresql commands that can help your out in your first few weeks of using Postgresql. Finding the current, time, which database you are in, the size of a database or a table, the database ipaddress…
Every system administrator has learning experiences that need to be shared to help others. Here are some lessons that I learned as a solo system administrator for a small growing company. I was lucky to have the following experiences before…
Navigating Postgresql with Psql command line can be frustrating until you have a quick cheat sheet of simple commands used for typical navigation. Once you get these commands memorized, you can quickly do nearly anything with just a few keystrokes.…
While postgresql is a great database with lots of features that you would normally only get in an enterprise database, navigating through it on the command line the first few lines can be a bit of an experience. So, I…