Unix & Linux Stack Exchange is a question and answer site for users of Linux, FreeBSD and other Un*x-like operating systems. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
up vote 1 down vote accepted

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

share|improve this answer
Upgrading postgresql on arch is quite annoying. I saw your question but my solution was so hacky I did not think it was worth reporting it. I don't think arch developers would automate that kind of process, but maybe better documentation or an update script on AUR would do the trick. – Barthelemy Dec 3 '10 at 11:30
only problem with them not automating it is the fact that 2 pg's must be side by side... idk what they'll do with the bug. – xenoterracide Dec 3 '10 at 12:32

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.