PostgreSQL Administrator’s Cheatsheet
Dec 30, 2009 / By Lukas Vysusil
Most people start with free databases and eventually get to know the enterprise products. I started the other way around.
After being trapped for eight years in the Oracle world, I felt like exploring another database platform. For some reason I can’t get myself to fiddle around with MySQL. There’s nothing rational about this–no benchmarks, reviews, or co-worker horror stories. I feel it’s just not my type.
So when looking for free database, I reached out for PostgreSQL, again for no objective reason–only the gut feeling that this could be what I’m looking for.
I took advantage of the Christmas holidays to dive into it, and guess what? I like it! That’s why I decided to put together this small cheat sheet of most common things administrators might be looking for. If you are used to Oracle. I added equivalents in red where appropriate for quicker orientation.
By the way, if you ask me what to use for a lightweight web development platform, I made my choice–PHP 5 with the CodeIgniter framework and PostgreSQL 8.4 on Oracle Enterprise Linux 5.
And now, here is my PostgreSQL cheatsheet. Enjoy!