I was running postgres 8.4 on arch but now have 9 installed I want to use pg_upgrade to upgrade but I don't know what all the options I have to use are, and all the directories that I have to point it to. I think it asks for a previous pg binary directory... but that's gone. Will it still work? I've no important data, just play db's I just want to know how to do it. I also realize this is borderline serverfault, but I feel it has as much to do with arch's install process and paths, so I thought I'd ask here.
How do I pg_upgrade my database on Arch Linux?
arch linux;postgresql
I asked this question on serverfault, because I hadn't gotten an answer here, and this was the answer I got, it basically contains docs links. But the most important take home, in my opinion, is that to use pg_upgrade you have to have 2 versions of postgres installed side by side, as such I filed a bug with arch to build it into the package upgrade process