Re: Question on initdb and subsequent start

>> I get the following message:
>> FATAL: invalid value for option 'LC_TIME': 'en'
>
> Do these things:
>
> (a) Complain to Apple about the broken state of their locale support.
> They should not be setting default locale values that their own library
> doesn't cope with.
>
> (b) Re-run initdb with LC_ALL set to C. If you're using tcsh I think
> this goes like
> setenv LC_ALL C
> initdb
> Watch initdb's output to make sure it acknowledges that all locale
> settings are C.
>
> regards, tom lane

Tom,

Thank you for the input.

Actually, I figured out later that I need to always specify my directory in
the initdb call with the name "data". Any other name causes this problem.

Originally I was issuing the following command:
/usr/local/bin/initdb -D /Users/Shared/pgdata

When I changed that to:
/usr/local/bin/initdb -D /Users/Shared/data

it worked fine. Pg_ctl was then able to start up postmaster without any
problems. So, it appears that PostgreSQL requires the name of the data
directory to be "data". This is probably obvious to most people but I am new
to PostgreSQL and didn't figure that out from the documentation.

Thanks for your response.

Regards,

Manoj Patwardhan