Re: postgres with xcode - Mailing list pgsql-general

On 07/28/2018 07:15 AM, Sumit Chaturvedi wrote:
Please reply to list also.
Ccing list.

> Hello. Thanks a lot for your response. Yes that was also there.

Note: Bottom posting is the style on this list. Unfortunately the 
screenshot is not coming through on this reply. For those that see this 
the screenshot showed:

LC_ALL en_US.UTF8

Generally it is a better idea to cut and paste from command line output 
or a text file then show a screenshot. For the reason above and also 
because screenshots make it difficult for other users to cut and paste 
into their machines for testing/debugging purposes.

Back to the problem at hand. The error message only shows up in the 
section I quoted before with regards to locale handling on Macs.

Are you having any issues with starting Postgres outside of xcode?

> 
> On Sat, Jul 28, 2018 at 7:41 PM Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>> wrote:
> 
>     On 07/28/2018 04:04 AM, Sumit Chaturvedi wrote:
>      > Hello everyone. I'm a third year student from IIT Bombay, India.
>     Since
>      > I'm currently learning about databases, I wanted to debug postgresql
>      > with xcode. However, I am having a lot of problems.
>      > OS - 10.13.6 (High Sierra)
>      > Xcode - 9.4.1
>      >
>      > To set up my system, I tried to replicate the instructions found at
>      > https://wiki.postgresql.org/wiki/Working_with_Eclipse
>      > <https://wiki.postgresql.org/wiki/Working_with_Eclipse> for my case.
>      >
>      > Everything proceeded fine until a point where I had to change the
>     run
>      > configuration (scheme in xcode terms). I set the executable as
>     postgre
>      > from /src/backend and gave the appropriate arguments. Then, when I
>      > pressed run, I got an error as shown in the attachment.
> 
>     I can tell you where the error comes from:
> 
>     postmaster.c
> 
>     /*
>     * On macOS, libintl replaces setlocale() with a version that calls
>     * CFLocaleCopyCurrent() when its second argument is "" and every
>     relevant
>     * environment variable is unset or empty.  CFLocaleCopyCurrent() makes
>     * the process multithreaded.  The postmaster calls sigprocmask() and
>     * calls fork() without an immediate exec(), both of which have undefined
>     * behavior in a multithreaded program.  A multithreaded postmaster
>     is the
>     * normal case on Windows, which offers neither fork() nor sigprocmask().
>     */
>     if (pthread_is_threaded_np() != 0)
>           ereport(FATAL,
>                         
>       (errcode(ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE),
>                               errmsg("postmaster became multithreaded
>     during
>     startup"),
>                               errhint("Set the LC_ALL environment
>     variable to
>     a valid locale.")));
> 
>      > To solve it, I set up my environment variables in xcode
>     appropriately to
>      > make sure that locale information was reaching wherever it was
>     needed.
>      > But even now, when I press run I get the same error.
> 
>     I do not see that the LC_ALL environment variable is set, per the HINT
>     to the FATAL message.
> 
>      >
>      > Hoping someone can share with me how they went about with their
>     setup.
>      >
>      > --
>      > Sumit Chaturvedi
> 
> 
>     -- 
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 
> -- 
> Sumit Chaturvedi


-- 
Adrian Klaver
adrian.klaver@aklaver.com