We have already installed ODBC drivers for Oracle and PostgreSQL in prior articles. In this article, we will install ODBC drivers on CentOS to connect us to an MySQL database. The general idea is similar to the steps we followed…
Enabling and managing binary logging will make it more likely that you can recover your database to a specific point in time. These point in time recoveries require proper backups as well as having your MySQL server instance configure for…
Immediately after installing the PostgreSQL ODBC drivers on a new CentOS system (see the earlier article: Install PostgreSQL ODBC), I received a second request to install the Oracle ODBC drivers on the same CentOS system. Everything has additional steps when…
We had an interesting little project the other day. One of our statisticians needed to be able to connect to his PostgreSQL database using ODBC. The client was a CentOS 6 box, which already had PostgreSQL 9.3 installed on it.…
PostgreSQL Replication Options So, with all of the other articles that I have written about Postgresql, I figured that it was inevitable that we finally get one written about replication. What makes an article about Postgresql replication difficult is that…
If you installed Postgres using the methodology demonstrated in our earlier article: CentOS Install Postgres 9.3, then at some point you may need to upgrade your Postgresql instance. For this article on upgrading postgresql, I used a 9.2 instance that…
I admit that in the past I have had some real frustrations granting permission users in PostgreSQL databases. I believe that much of this stemmed from the fact that up until Version 9, there was no way to manipulate the…
The other day, we had an issue with one of our PostgreSQL databases where one of our applications wasn’t closing its unused connections. We tripled the max_connections and it used all of those up too. While I was monitoring the…
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…
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…
Postgresql is a great SQL database with lots of great features that you can install for free with just a few quick tasks. First, we need to get the yum repo from postgresql website, use yum to install it and…
MySQL stores user’s password in a crypto format. It wasn’t too long ago that the default length of the crypto password was stored in a 16 character length. More recently, MySQL has changed their password length capability scheme to up…
Uptime vs Database Backups Backups of your database can be an enemy to your system uptime. Doing a filesystem dump of your database tablespace files will require that it occur while your database is down so that you don’t have…
Master Slave MySQL Replication Summary Master / Slave replication in MySQL is a great way to store an exact replica of your database on another machine in another location as part of a disaster recovery plan. Before setting up Master…