File system level backup from 32bit to 64bit

From: mljv(at)planwerk6(dot)de
To: pgsql-general(at)postgresql(dot)org
Subject: File system level backup from 32bit to 64bit
Date: 2008-01-07 15:31:40
Message-ID: 200801071631.40093.mljv@planwerk6.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

i wanted to move my database from a 32bit machine to 64bit machine with rsync
like it is explained here

http://www.postgresql.org/docs/8.1/interactive/backup-file.html

I did an inital rsync while database was running. then shutdown, rsync again,
starting 64bit database says:

/var/lib/postgresql/8.1# /etc/init.d/postgresql-8.1 start
Starting PostgreSQL 8.1 database server: main* Error: The server must be
started under the locale : which does not exist any more.
failed!

The locales are exactly the same when i list them with

locale -a

i guess that rsyncing all database files from 32bit to 64bit does not work.

if so:
1. the error message is misleading.
2. It is not obvious for me that you can't copy from 32bit to 64bit. Maybe it
should be mentioned in the docs.

kind regards,
janning

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2008-01-07 16:03:43 Re: Hash Indexes
Previous Message Gregory Stark 2008-01-07 15:18:46 Re: Index trouble with 8.3b4