I've had to do this a few times and each time I have to dig around to get this just right so this time I decided to install and document what I did. I'm doing this install on Centos 5.2 64bit that is running in a VM (VMware Fusion) on my Mac Book Pro. This Centos install is also running a version of ColdFusion and Apache. I have two reasons for doing this install. One is so I can practice the upgrade from 8.1 to 8.3. There are some SQL functions in 8.3 I want to get into that lets you return ranks with your query. See this. And the next was so I could document this process so I don't have to search the net to find how to do it and then figure out how I need to do it. Since I maintain my own servers I tend to have to research this sort of thing a few times a year. I'm also planning to purchase a new to me server with much more power to run my production PostgreSQL DB and I figure I should have this part sorted out by the time I decide to spend the money on the machine.
So step one after figuring out the VM stuff (running VMware is new to me) is to install PostgreSQL. When I did my first PostgreSQL install ages ago I downloaded the source and ran a bunch of commands something along the lines of .configure --some-options; make; make install; and some other stuff. Now that I'm using Centos I figured why the heck do ALL of that when there is YUM! So I did yum:




