Instructions from postgres wiki under the quick guide
pacman -S --needed postgresql-old-upgrade
su - postgres -c 'mv /var/lib/postgres/data /var/lib/postgres/data-9.2'
mv: cannot move '/var/lib/postgres/data' to '/var/lib/postgres/data-9.2': Permission denied
su - postgres -c 'mkdir /var/lib/postgres/data'
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)
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.
EDIT: nevermind, you found out yourself. Good.
Last edited by teekay (2013-10-23 15:16:49)