Hi,

I am using a combination of file based backup of my postgresql cluster
location, and WAL archiving as my main backup system for my postgresql
database cluster.

Now I am having an issue when I try to restore my system on a different
distribution from the one that I am currently using:


Both the postgresql versions are 8.3.9. (old server is Ubuntu Hardy new
server is Debian Lenny)

when I replace the default "main" folder with the one in my archive,
upon starting postgresql I get the following error:

The server must be started under the locale : which does not exist any
more.

(note that the area where the actual locale should be, it is actually empty)

Now I've made sure that all the locales present on the old server are
also installed on the new one, and both have the exact same locale set
as default.

Both also have the same locale setup in postgresql.conf

Whenever I switch back to the default main directory that came with the
fresh installation the database will fire up nicely.

Sadly, the postgresql log gives me no information at all when attempting
to start from the restored "main" cluster (with debug1)

I have tested the above procedure restoring from ubuntu Hardy to ubuntu
Hardy several times, and it never gave me any problems, but I don't
really see why a restore to a different distro should give any problems
as long as the postgresql versions match up ?


Any assistance, and or insights would be highly appreciated,

Kind regards

Jeroen