Re: problem with locale : - Mailing list pgsql-general

From Vibhor Kumar
Subject Re: problem with locale :
Date
Msg-id 49CF43F5.1090301@enterprisedb.com
Whole thread Raw
In response to Re: problem with locale :  (Vibhor Kumar <vibhor.aim@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Vibhor Kumar
Date:
Subject: Re: problem with locale :
Next
From: Alain Roger
Date:
Subject: concatenate and use as field