On 02/13/2016 09:04 AM, Mick wrote: > Hi All, > > How would you suggest I upgrade dev-db/postgresql-9.4.5-r2 to 9.5.1? > > I read here that dump and restore is probably a cleaner way to upgrade gentoo > based installations, rather than using the pg_dump and pg_restore commands: > > http://michael.orlitzky.com/articles/upgrading_postgresql-9.x_on_gentoo.php >
Haha, yes, I remember that. I stand by the note at the top. You can install 9.5 side-by-side with 9.4. That gives you time to look over the configuration for 9.5 while 9.4 is still running. Then when you're ready, run pg_dump/pg_dumpall to back everything up. Stop 9.4, eselect 9.5, start 9.5, and then run pg_restore or psql < backup.sql to load all of the data. It's fast, conceptually simple, and minimizes the downtime. When you're sure it works, don't forget to remove 9.4 from the default runlevel and add 9.5 so that you're not surprised on a reboot.
