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.kla...@aklaver.com> 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.kla...@aklaver.com <mailto:adrian.kla...@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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> >> >> >> >> >> -- >> Sumit Chaturvedi >> > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > -- Sumit Chaturvedi