When connecting to a PostgreSQL database using pgAdmin you may receive an error letting you know that the server instrumentation is not installed. This is a warning to let you know that you can install the adminpack contribution which will provide more functionality to pgAdmin including the ability to modify the pg_hba.conf and postgresql.conf configuration…Details
Earlier a client with a fairly complex network setup had a power outage in one of their data centers in Dallas, TX. The power outage caused three servers and a firewall to lose power causing all sorts of other issues on the servers themselves. One of the primary issues was getting the PostgreSQL cluster back…Details
Last night I was working on upgrading the BIOS on an older Dell Poweredge 650 that I have been using as a PostgreSQL development server. One of the CD’s I needed to create is downloaded from Dell as two parts of an ISO file that needed to be combined so below is information on how…Details
While troubleshooting another problem this evening I noticed a bunch of avahi-daemon errors in the messages log on a CentOS Linux development server. The error hasn’t caused any issues that I am aware of and may be a simple case of a new warning message or another server on the network sending rogue DNS packets…Details
I have a couple development servers I have been using for testing PostgreSQL configured with walmgr for log shipping. The secondary server stopped working the other day and I finally got a chance to look into it this morning and attempted to restart Postgres via a terminal but it failed. Below I describe how the…Details
While working on a clients Ubuntu Linux computer I needed to send some of the logs to myself so I could analyze them at a later date but there was not an SMTP server installed on the computer. This can be resolved by installing the Exim MTA (Mail Transfer Agent) using the below apt-get command…Details
While working on a clients computer yesterday I needed to send some of the logs from the computer to myself so I could analyze later on my computer. At first I had to install the Exim MTA which I will write an article on in the near future but once installed mail was still not…Details
I ran into a error when installing the first gem on a CentOS development server I was creating. The error states that the extconf.rb file could not the header files. Below I show the output of the error along with what was done to resolve the error.