Re: problem with locale :

Hi Eigenio,

Stefan has already mentioned the reason for  the error.

It seems the database is not compatible with the binaries/server.

However, you can check the locale of data directory using the pg_controldata <data directory>, if the it is compatible with the server.

For information about the command:
http://www.postgresql.org/docs/8.1/static/app-pgcontroldata.html

Thanks & Regards,
Vibhor Kumar
www.enterprisedb.com


Vibhor Kumar wrote:

Hi Eugenio,

Use the following command to know about the locale.
pg_controldata <Data Directory>

For more information, please follow the link given below:
http://www.postgresql.org/docs/8.3/static/app-pgcontroldata.html

Thanks & Regards,
Vibhor Kumar
www.enteprisedb.com

Stefan Kaltenbrunner wrote:

Eugenio Modesti wrote:

Hello,
i received a copy of a postgresql data directory and i need to read it (and do a regular dump).
the datadir version is 8.1 so i installed that version of the server.
When trying to start the server i got this:
Error: The server must be started under the locale : which does not exist anymore

how can i know on which locale that datadir is based?
what is ":" as a locale?

the server is running under ubuntu server.

are you sure that the datadirectory you got was not created on a 32bit box and you are running a 64bit OS (or the other way round)?


Stefan