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…