checksum error from windows to linux

Started by Antoine PERENNECabout 20 years ago2 messagesgeneral
Jump to latest
#1Antoine PERENNEC
antoine.perennec@wanadoo.fr

Hi all,
I'm a newbie to postgres, and I'm facing a few problems to start my postgres server.
Actually, I've retrieved a postgreSQL database from a postgreSQL server that was running on windows and I'm trying to load this database on a postgreSQL server that will be running on a linux mandrake platform. I downloaded the PostgreSQL 8.0.7 package, same version as the windows server, and copied the data directory from the windows server into the /usr/local/pgsql/data directory on my linux platform.
Then, I've tried to launch the server in the foreground with the command line :
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
The error message was telling me that the value "French_France" for the locale "lc_messages" wasn't recognized by postmaster.
Then I've defined a locale alias in locale.alias for "French_France", but the checksum problem persists.
I suppose there's a deeper cause to this problem, involving the way the checksum is computed.
Is there a way to overcome the problem simply, for example re-compute the checksum before starting the server ?
Or may I initialize the server with an empty database with initdb, then postmaster and then recover the data without the checksum ? I'm really looking for this particular kind of recovering process.
Whatever, sorry for my difficulties of explanation, I'm really new to postgres and english isn't my mother tongue (I bet you've guessed it), and thanks a lot for any help !!
Antoine

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Antoine PERENNEC (#1)
Re: checksum error from windows to linux

Antoine PERENNEC <antoine.perennec@wanadoo.fr> writes:

Actually, I've retrieved a postgreSQL database from a postgreSQL
server that was running on windows and I'm trying to load this
database on a postgreSQL server that will be running on a linux
mandrake platform.

You generally can't transfer the physical datafiles between
non-identical platforms. Use pg_dump instead to create a portable
dump.

regards, tom lane