Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Postgresql Starting problem

Status
Not open for further replies.

manik23

Programmer
Joined
Feb 11, 2005
Messages
5
Location
BG
When I try to run my posgresql (version 7.3.9) I recieve the following error message:

PANIC: The database cluster was initialized with LC_COLLATE 'en_US.iso885915',
which is not recognized by setlocale().
It looks like you need to initdb.
Aborted

Cann someone please tell me how this cann be repaired?
Actualy i have copied the data directory from previos postgresql instalation.
 
By the way... I use postgresql on Linux Slackware 10.0
 
i would recomend to read
man locale-gen
if you do not have locales installed, install them
 
I have readed it, and have this locale installed... I have allso set LANG and all the others to en_US.iso885915...

Any other sugestions...
 
[purple]
Actualy i have copied the data directory from previos postgresql instalation.
[/purple]
I can't give good technical reasons, but I'm betting this is it. You should do a pg_dump then pg_restore instead of trying to copy data directories and files. There's logging (xferlog, clog I think) of transactions that won't stay intact with this method of moving data.

Again, it's just my guess.

----
JBR
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top