upgrading from postgres 8.3 to 8.4

I upgraded my postgres today.  (Yes, I know it is an old version – that is what the CodeRanch forums use.)  First I reviewed what I did to install 8.3 originally and how frustrating that was.  Upgrading went smoother.  Here’s what I did:

  1. Download the Mac Postgres 8.4 graphical installer.
  2. Install it.
  3. Create my database and load data
  4. Change context.xml in Tomcat to point to port 5433.  (since I had two postgres installs at the same time, it incremented the port from the default of 5432) (changed this back)
  5. sudo su – root and changed  /Library/PostgreSQL/8.4/data/postgresql.conf to use port 5542.  (If I was doing this again, I’d just uninstall the old version as first step to avoid port conflicts)
  6. In finder: Go > Go to folder > Libraries > Postgres > 8.3 and select the uninstaller app

That’s it.  Nice and easy.  Which is good because the initial install was nothing but easy!

Now I can rewrite this without a stored procedure!

Leave a Reply

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