I Know of a few gotchas essentially the database upgrade itself is easy just do a full dump and reload. here are the gotchas
1) be sure to follow the steps here http://www.postgresql.org/docs/9.3/static/upgrading.html including the file system backup first. If there is a failure in the restore it can be a nightmare to fix if you didn't make a copy of the database files before you upgrade. 2) If you are using custom table spaces like I am make sure you make backup copies of those as well. also recreate them on the new database before the restore. I use custom table spaces because I hate putting entire databases in /var so my journal is in the default location and my data is on a different partition. if you intend to use custom table spaces this is probably the best time to make that change its painful otherwise. 3) if you are doing this on EL 6 you need to update a symlink for jdbc. here is the default " ~]# ls -L /usr/share/java/postgresql-jdbc.jar lrwxrwxrwx. 1 root root 44 Nov 5 2012 /usr/share/java/postgresql-jdbc.jar -> /usr/share/java/postgresql-8.4-703.jdbc4.jar " you need to make sure you have the correct PostgreSQL 9 jdbc file installed and /usr/share/java/postgresql-jdbc.jar is pointed to the one for 9 instead of 8. This one is critical or you will experience a whole lot of weird issues and possibly even database corruption especially with Taskomatic. 3) I haven't had time to track this down yet however I did create a bug ticket. I found that rhnsearchd is still ignoring the IP address in the configuration and connecting to local host. I do not know if its due to some remnant someplace left over from upgrades or if it is a real bug in rhnsearchd itself. On Mon, Jul 14, 2014 at 11:35 AM, Boyd, Robert <robert.b...@peoplefluent.com> wrote: > Andy, > > When you do the upgrade I'd like to hear what if any details you discover > that you have to work through that deviate from the postgres docs. I'd like > to make the same upgrade. I looked at it a few months ago and decided to > wait a while before tackling it. > > Thanks, > > Robert Boyd > Sr. Systems Engineer > PeopleFluent > e. robert.b...@peoplefluent.com > > Visit: www.peoplefluent.com | Read: Peoplefluent Blog | Follow: @peoplefluent > | Download: iPad App > > -----Original Message----- > From: spacewalk-list-boun...@redhat.com > [mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Andy Ingham > Sent: Monday, July 14, 2014 10:02 AM > To: spacewalk-list@redhat.com > Subject: [Spacewalk-list] upgrading postgres (8.4 > 9.x) on the spacewalk > server ? > > Folks -- > > Any particular gotchas about attempting to upgrade the postgresql server for > our spacewalk installation? It's at version 8.4 and we'd like to get it into > the 9.x series. > > I'm assuming it should just be done according to the postgres docs? > > TIA, > Andy > > > Andy Ingham > IT Infrastructure > Fuqua School of Business > Duke University > > _______________________________________________ > Spacewalk-list mailing list > Spacewalk-list@redhat.com > https://www.redhat.com/mailman/listinfo/spacewalk-list > > _______________________________________________ > Spacewalk-list mailing list > Spacewalk-list@redhat.com > https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list