Re: [ADMIN] Problem with data migration from 9.1 to 9.2

2013-03-24 Thread Andrzej Zawadzki
On 04.03.2013 13:53, Daniel Krysiak wrote: > Hi, > > I'm using Arch Linux i686, and postgresql-old-upgrade package which > provides /opt/pgsql-9.1/ > Here is exactly what I did (this procedure has always worked for me) > > su - postgres > cd /var/lib/postgres > mv data data-9.1 > mkdir data > initd

[ADMIN] Problem with data migration from 9.1 to 9.2

2013-03-04 Thread Daniel Krysiak
Hi, I'm using Arch Linux i686, and postgresql-old-upgrade package which provides /opt/pgsql-9.1/ Here is exactly what I did (this procedure has always worked for me) su - postgres cd /var/lib/postgres mv data data-9.1 mkdir data initdb --locale en_US.UTF-8 -D /var/lib/postgres/data pg_upgrade