Arch Linux

awayand

Member

Registered: 2009-09-25

Posts: 398

[SOLVED] Install into different location

Hello beloved Arch-community,
I wanted to upgrade my postgres installation using the pg_upgrade tool. The pg_upgrade tool requires the old as well as the new postgres binaries to be present, so I downgraded from v9 back to v8 to make sure everything would still work fine and it did. Then I tried to do a v9 installation using

$ sudo pacman -Sy postgres --root=~/tmp

but then pacman complains the directory structure is not the way it expects it (i.e. "problem setting dpath /tmppath/var/lib/pacman"). Instead of wasting time doing it the hard and beginner way, I wanted to ask what the most elegant way of doing this would be. How can I define an alternative path in pacman for this purpose and if not, how would you go about upgrading postgres from v8 to v9?
Thanks!

Last edited by awayand (2011-04-30 17:53:33)

Mr.Elendig

#archlinux@freenode channel op

From: The intertubes

Registered: 2004-11-07

Posts: 4,097

Re: [SOLVED] Install into different location

pg_upgrade simply dumps and restore the db, you can do a dump yourself, upgrade then restore.

---

Evil #archlinux@libera.chat channel op and general support dude.
. files on github, Screenshots, Random pics and the rest

awayand

Member

Registered: 2009-09-25

Posts: 398

Re: [SOLVED] Install into different location

Thanks for that workaround! Will look into it. My problem is that I don't know postgresql at all and didn't want to dive into it, just do the upgrade and be done with it...

awayand

Member

Registered: 2009-09-25

Posts: 398

Re: [SOLVED] Install into different location

I found the solution to my problem. A simple "tar -Jxvf package.pkg.tar.xz" did it for me.