Tips from a Recovering Oracle DBA: Setting up your Postgres Environment like a Pro

There are several ways to set up a Postgres environment for the first time. I have seen several setups where the focus was on getting it to work fast (‘next, next, next, finish’). This I call ‘quick-and-dirty.’ It will work of course, but I decided to sit down and spend some time thinking on a robust, dependable, easy-to-manage architecture which I would not regret after a while. This presentation is to show you how I did it and hopefully give you some new ideas on how to improve your own environments.