Stefan Schwarzer <stefan.schwarzer@xxxxxxxxxxxx> writes: >> Also, pay attention to the first few lines of initdb output --- >> it will tell you what it thinks it's supposed to use for locale. > It tells me the following: > The files belonging to this database system will be owned by user > "schwarzer". > This user must also own the server process. > The database cluster will be initialized with locale en_US.UTF-8. > The default database encoding has accordingly been set to UTF8. > ... > creating template1 database in /Users/schwarzer/Documents/ > data_postgres/base/1 ... FATAL: XX000: failed to initialize > lc_messages to "" > LOCATION: InitializeGUCOptions, guc.c:2666 Hmph. That seems to eliminate the bad-locale-setting theory. In the past, when we've seen instances of this, it's been either an improper setting or something missing/broken in the platform's locale support. I'd have thought OS X was relatively impervious to this type of problem because it's a monolithic install instead of package-based, but maybe not. What have you got under /usr/share/locale? On my OS X 10.4 laptop, I see g42:~ tgl$ ls -lR /usr/share/locale/en_US.UTF-8 total 40 lrwxr-xr-x 1 root wheel 28 Apr 26 2006 LC_COLLATE -> ../la_LN.US-ASCII/LC_COLLATE lrwxr-xr-x 1 root wheel 17 Apr 26 2006 LC_CTYPE -> ../UTF-8/LC_CTYPE drwxr-xr-x 3 root wheel 102 Mar 20 2005 LC_MESSAGES lrwxr-xr-x 1 root wheel 30 Apr 26 2006 LC_MONETARY -> ../en_US.ISO8859-1/LC_MONETARY lrwxr-xr-x 1 root wheel 29 Apr 26 2006 LC_NUMERIC -> ../en_US.ISO8859-1/LC_NUMERIC lrwxr-xr-x 1 root wheel 26 Apr 26 2006 LC_TIME -> ../en_US.ISO8859-1/LC_TIME /usr/share/locale/en_US.UTF-8/LC_MESSAGES: total 8 lrwxr-xr-x 1 root wheel 45 Apr 26 2006 LC_MESSAGES -> ../../en_US.ISO8859-1/LC_MESSAGES/LC_MESSAGES g42:~ tgl$ ls -lLR /usr/share/locale/en_US.UTF-8 total 200 -r--r--r-- 1 root wheel 4642 Mar 20 2005 LC_COLLATE -r--r--r-- 1 root wheel 80744 Mar 20 2005 LC_CTYPE drwxr-xr-x 3 root wheel 102 Mar 20 2005 LC_MESSAGES -r--r--r-- 1 root wheel 34 Mar 20 2005 LC_MONETARY -r--r--r-- 1 root wheel 8 Mar 20 2005 LC_NUMERIC -r--r--r-- 1 root wheel 377 Mar 20 2005 LC_TIME /usr/share/locale/en_US.UTF-8/LC_MESSAGES: total 8 -rw-r--r-- 1 root wheel 18 Mar 20 2005 LC_MESSAGES I'm wondering if some of those files are missing, or the symlinks are dangling, on yours. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
