PostgreSQL Administrator’s Cheatsheet

Posted in: Technical Track

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!

Interested in working with Lukas? Schedule a tech call.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *