Arch Linux

dangsos

Member

Registered: 2009-03-06

Posts: 28

[Solved]Upgrading postgres 9.2 to 9.3 isn't working.

Instructions from postgres wiki under the quick guide

pacman -S --needed postgresql-old-upgrade

--works

su -

--works

su - postgres -c 'mv /var/lib/postgres/data /var/lib/postgres/data-9.2'

--provides error
mv: cannot move '/var/lib/postgres/data' to '/var/lib/postgres/data-9.2': Permission denied

su - postgres -c 'mkdir /var/lib/postgres/data'

--error
mkdir: cannot create directory '/var/lib/postgres/data': File exists

su - postgres -c 'initdb --locale en_US.UTF-8 -E UTF8 -D /var/lib/postgres/data'

--haven't tried yet

If it's easier I could just destroy the current postgresql install and reinstall, but I can't find any documentation on that either.

Thanks in advance!

Last edited by dangsos (2013-10-23 15:14:34)

dangsos

Member

Registered: 2009-03-06

Posts: 28

Re: [Solved]Upgrading postgres 9.2 to 9.3 isn't working.

Okay, apparently /var/lib/postgres was owned by root and not postgres, not sure if I screwed this up or what, but simply making the dir and changing the data-9.2/ dir to postgres:postgres and moving all the files fixed the issue for me.

teekay

Member

Registered: 2011-10-26

Posts: 271

Re: [Solved]Upgrading postgres 9.2 to 9.3 isn't working.

EDIT: nevermind, you found out yourself. Good.

Last edited by teekay (2013-10-23 15:16:49)