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 strongm 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
Feb 11, 2005
5
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