There is a problem with mac osx in regard to locale. A
bug report was submitted to apple, they (apple)
acknowledged the bug and said it would be addressed in
a future version.
End result... when you initdb you need to use locale =
C. I forgot the exact syntax just look at the docs.
initdb --locale=C
Hope this helps.
Ted
--- Claudio Sartori <claudio.sartori@unibo.it> wrote:
>
========================================================================
>
> ====
> POSTGRESQL BUG REPORT
> TEMPLATE
>
========================================================================
>
> ====
>
>
> Your name : Claudio Sartori
> Your email address :
> claudio.sartori@unibo.it
>
>
> System Configuration
> ---------------------
> Architecture (example: Intel Pentium) :
> Apple PowerMac G4
> dual 1.o GHz
> Operating System (example: Linux 2.0.26 ELF) :
> Apple Mac OS X
> 10.2.6, main language Italian
>
> PostgreSQL version (example: PostgreSQL-6.5.1):
> PostgreSQL-7.3.3
>
> Please enter a FULL description of your problem:
> ------------------------------------------------
> I followed exactly the update instructions in
> http://www.entropy.ch/software/macosx/postgresql/
> everything seems to work fine, but after the pg_ctl
> start command the
> log file contains the line
>
> FATAL: invalid value for option 'LC_TIME': 'it_IT'
>
> and the system is not started.
>
> Before I had 7.2.3 perfectly working (and at present
> I switched back to
> it)
>
> Regards
>
> --
> Claudio Sartori
> Dipartimento di Elettronica, Informatica e
> Sistemistica
> Universita' di Bologna
> Viale Risorgimento, 2
> I-40136 BOLOGNA
> ITALY
> Tel (direct): +39 051 20 93554
> Tel (operator): +39 051 20 93548 - 93001
> Fax : +39 051 20 93540
> Mobile: +39 335 690 8250
> http://www-db.deis.unibo.it/sartori/
>
> --
> Claudio Sartori
> Dipartimento di Elettronica, Informatica e
> Sistemistica
> Universita' di Bologna
> Viale Risorgimento, 2
> I-40136 BOLOGNA
> ITALY
> Tel (direct): +39 051 20 93554
> Tel (operator): +39 051 20 93548 - 93001
> Fax : +39 051 20 93540
> Mobile: +39 335 690 8250
> http://www-db.deis.unibo.it/sartori/
>
> --
> Claudio Sartori
> Dipartimento di Elettronica, Informatica e
> Sistemistica
> Universita' di Bologna
> Viale Risorgimento, 2
> I-40136 BOLOGNA
> ITALY
> Tel (direct): +39 051 20 93554
> Tel (operator): +39 051 20 93548 - 93001
> Fax : +39 051 20 93540
> Mobile: +39 335 690 8250
> http://www-db.deis.unibo.it/sartori/
>
> --
> Claudio Sartori
> Dipartimento di Elettronica, Informatica e
> Sistemistica
> Universita' di Bologna
> Viale Risorgimento, 2
> I-40136 BOLOGNA
> ITALY
> Tel (direct): +39 051 20 93554
> Tel (operator): +39 051 20 93548 - 93001
> Fax : +39 051 20 93540
> Mobile: +39 335 690 8250
> http://www-db.deis.unibo.it/sartori/
>
> --
> Claudio Sartori
> Dipartimento di Elettronica, Informatica e
> Sistemistica
> Universita' di Bologna
> Viale Risorgimento, 2
> I-40136 BOLOGNA
> ITALY
> Tel (direct): +39 051 20 93554
> Tel (operator): +39 051 20 93548 - 93001
> Fax : +39 051 20 93540
> Mobile: +39 335 690 8250
> http://www-db.deis.unibo.it/sartori/
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose
> an index scan if your
> joining column's datatypes do not match
__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
