Re: postgres with xcode

[Sumit Chaturvedi <sumit.chaturvedi@xxxxxxxxx>]

Hello,

Does the following seem unusual?

amaltaas:backend amaltaas$ locale

LANG="en_US.UTF-8"

LC_COLLATE="en_US.UTF-8"

LC_CTYPE="en_US.UTF-8"

LC_MESSAGES="en_US.UTF-8"

LC_MONETARY="en_US.UTF-8"

LC_NUMERIC="en_US.UTF-8"

LC_TIME="en_US.UTF-8"

LC_ALL=

After this I ran postgres from terminal like the following and it works:

amaltaas:backend amaltaas$ ./postgres -D ~/Desktop/dn

2018-07-29 14:27:04.544 IST [68250] LOG:  listening on IPv6 address "::1", port 5432

2018-07-29 14:27:04.545 IST [68250] LOG:  listening on IPv6 address "fe80::1%lo0", port 5432

2018-07-29 14:27:04.545 IST [68250] LOG:  listening on IPv4 address "127.0.0.1", port 5432

2018-07-29 14:27:04.546 IST [68250] LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"

2018-07-29 14:27:04.567 IST [68251] LOG:  database system was shut down at 2018-07-29 14:23:35 IST

2018-07-29 14:27:04.574 IST [68250] LOG:  database system is ready to accept connections

So although the problem is with xcode. I have a feeling that it is not because of LC_ALL.

So my point is that maybe the hint is not entirely correct.. 

On Sun, Jul 29, 2018 at 12:11 AM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:

On 07/28/2018 11:24 AM, Sumit Chaturvedi wrote:
Ccing list

Yes, I can start Postgres server from the terminal. I was thinking, if I comment out these lines and another assert later on which checks whether postmaster is using multiple threads, I'll be fine right?

If by fine you mean driving further into the crash then yes. The error is FATAL for a reason, to stop the postmaster before you do damage.

The issue seems to be with xcode, that is where you should spend your time troubleshooting. If it where me I would start by not setting the environment variables in xcode. Further help may involve going to an xcode mailing list/forum and asking advice.

On Sat, Jul 28, 2018 at 11:46 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@aklaver.com>> wrote:

    On 07/28/2018 11:08 AM, Sumit Chaturvedi wrote:

        Hello.

        Thanks for those pointers. Will keep them in mind in the future.
        No, there is no problem outside Postgres.


    So you can start the Postgres server and use it from a program other
    then xcode?


        Could it be that postmaster becomes multithreaded for some other
        reason??


    That error message only shows up in one place in the code and that
    is when dealing with Mac locales.

    You can download the source from here:

    https://www.postgresql.org/ftp/source/
    <https://www.postgresql.org/ftp/source/>

    and look for yourself.





    --     Adrian Klaver
    adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@aklaver.com>




--
Sumit Chaturvedi

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx

--

Sumit Chaturvedi