Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1muyD8-0000dV-Ni for pgsql-bugs@arkaria.postgresql.org; Wed, 08 Dec 2021 14:46:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1muyD7-0000zN-Il for pgsql-bugs@arkaria.postgresql.org; Wed, 08 Dec 2021 14:46:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1muyD7-0000z7-22 for pgsql-bugs@lists.postgresql.org; Wed, 08 Dec 2021 14:46:21 +0000 Received: from p-impout003aa.msg.pkvw.co.charter.net ([47.43.26.134] helo=p-impout003.msg.pkvw.co.charter.net) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1muyD4-0005WL-8C for pgsql-bugs@lists.postgresql.org; Wed, 08 Dec 2021 14:46:20 +0000 Received: from raker.lan ([24.163.67.44]) by cmsmtp with ESMTPA id uyD0mjvQeR0wIuyD1m0XNc; Wed, 08 Dec 2021 14:46:16 +0000 X-Authority-Analysis: v=2.4 cv=FYAkeby6 c=1 sm=1 tr=0 ts=61b0c538 a=DQjDuPnXzmJSQFi5SsPVwA==:117 a=DQjDuPnXzmJSQFi5SsPVwA==:17 a=NEAV23lmAAAA:8 a=g-wFfxmhMr7qyuJGr9wA:9 a=QEXdDO2ut3YA:10 a=H1Z9MyDyb20dmftl3-UA:9 a=HF_utGKJdaQ8-GtC:21 a=frz4AuCg-hUA:10 a=_W_S_7VecoQA:10 Message-ID: <846ec7fe2c2fc5958b0946a9f4bc69615393be7e.camel@nc.rr.com> Subject: Re: FATAL: postmaster became multithreaded during startup From: Reid Thompson Reply-To: jreidthompson@nc.rr.com To: pgsql-bugs@lists.postgresql.org In-Reply-To: References: Content-Type: multipart/alternative; boundary="=-OGSM4tXwaXc1X9vQwW8o" Date: Wed, 08 Dec 2021 09:46:04 -0500 MIME-Version: 1.0 User-Agent: Evolution 3.41.2 Compiled: 2021-10-14 01:37:05 X-CMAE-Envelope: MS4xfGQUQot+k/GzGVOl5yvuwaE1JM8RIWHWWkVKNitvrJRlzXxspSKj/QvBxBdGzZNGFO2m/axmruuMb9bL4TqpbboaY28EpGyChsYAcURP6cKCbSJV5xUh EbSTRquz6yXaTvJVkO+cJbuh+mu8JNWr2mXO+qbm5Dy0Kl71cNo0GCPizU8/LF2U8h8wThrYNeDFMDY0PEoL8sx55Nd6WHtsTXE= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-OGSM4tXwaXc1X9vQwW8o Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8bit On Wed, 2021-12-08 at 03:53 +0000, Jose Diaz wrote: > Greetings, > > I recently tried to create a Rails app and when I tried to create the > database I got the following error message: > > PG::ConnectionBad: could not connect to server: Connection refused >         Is the server running on host "localhost" (::1) and accepting >         TCP/IP connections on port 5432? > could not connect to server: Connection refused >         Is the server running on host "localhost" (127.0.0.1) and > accepting >         TCP/IP connections on port 5432? > > After some checking on my computer and remembering a problem I had > when I tried to use PGadmin last week I realized there was an error > in the database.  > > After some research on the internet, I found that there was an error > message on my log for the database that says: > > FATAL:  postmaster became multithreaded during startup > HINT:  Set the LC_ALL environment variable to a valid > > The output from my locale was > > 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="en_US.UTF-8" > > despite that, I tried the following commands to set up my local > anyways > > export LC_ALL=en_US.UTF-8 > export LANG=en_US.UTF-8 > > No success. > > I added the following commands to both, my .bash_profile and .profile > files  > > export LC_ALL="en_US.UTF-8" > export LANG="en_US.UTF-8" > > No success. > > I changed the language configuration of my mac to English, I set > locale environment variables on startup on the terminal and added the > following command to my .zshrc file  > > export LC_ALL=en_US.UTF-8 > export LANG=en_US.UTF-8 > > Still no success. > > I really don't know what's going on. I haven't changed any > configuration. I had a previous version of PostgreSQL, but I didn't > know which version I had. I updated it to version 13 as a possible > solution found on the internet but still the same error.  > > Before this, it worked normally. It is the first I touch these > settings because I seldom work on databases. I hope I provided enough > info, this is as much detailed I can currently get. I thank you in > advance for your assistance. https://github.com/PostgresApp/PostgresApp/issues/317#issuecomment-251786830 indicates that the locale values need to be set properly for the postgres user. --=-OGSM4tXwaXc1X9vQwW8o Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable
On Wed, 2021-12-08 at 03:53 +0000, Jose Diaz wrote:<= /div>
Greetings,

I recently tried to create a Rails app and when I tried to = create the database I got the following error message:

PG::Connectio= nBad: could not connect to server: Connection refused
    &nb= sp;   Is the server running on host "localhost" (::1) and accepting
        TCP/IP connections on port 5432?
<= div>could not connect to server: Connection refused
   =     Is the server running on host "localhost" (127.0.0.1) and ac= cepting
        TCP/IP connections on port 5432?

After some= checking on my computer and remembering a problem I had when I tried to us= e PGadmin last week I realized there was an error in the database. 

<= div style=3D"font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; = color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">After some rese= arch on the internet, I found that there was an error message on my log for= the database that says:

FATAL:  postmaster became multithreaded during startup<= br>HINT:  Set the LC_ALL environment variable to a valid

The output= from my locale was

LANG=3D"en_US.UTF-8"

LC_COLLATE=3D"en_US.= UTF-8"

LC_CTYPE=3D"= en_US.UTF-8"

LC_MES= SAGES=3D"en_US.UTF-8"

LC_MONETARY=3D"en_US.UTF-8"

LC_NUMERIC=3D"en_US.UTF-8"

LC_TIME=3D"en_US.UTF-8"

LC_ALL=3D"en_US.UTF-8"


despite that, I tried= the following commands to set up my local anyways

export LC_ALL=3Den_US.UTF-8

export LANG=3Den_US.UTF-8


No success.

I added the following co= mmands to both, my .bash_profile and .profile files 

export<= /span> LC_ALL=3D"en_US.UTF-8"
export LANG=3D"en_US.UTF-8"

No success.

I changed the language configuration= of my mac to English, I set locale environment variables on startup on the= terminal and added the following command to my .zshrc file 

e= xport LC_ALL=3Den_US.UTF-8
export LANG=3Den_US.UT= F-8

Still no success.

I really don't know what's going on. I haven't chan= ged any configuration. I had a previous version of PostgreSQL, but I didn't= know which version I had. I updated it to version 13 as a possible solutio= n found on the internet but still the same error. 

Before this, it worked normally.= It is the first I touch these settings because I seldom work on databases.= I hope I provided enough info, this is as much detailed I can currently ge= t. I thank you in advance for your assistance.

<= /div>

indicates that the l= ocale values need to be set properly for the postgres user.

<= /div>
--=-OGSM4tXwaXc1X9vQwW8o--