Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qQo06-00125y-Ro for pgsql-general@arkaria.postgresql.org; Tue, 01 Aug 2023 11:57:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qQo03-0063G2-M7 for pgsql-general@arkaria.postgresql.org; Tue, 01 Aug 2023 11:57:17 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qQo03-0063Ft-6i for pgsql-general@lists.postgresql.org; Tue, 01 Aug 2023 11:57:16 +0000 Received: from ms-10.1blu.de ([178.254.4.101]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qQo01-000AnW-5Z for pgsql-general@lists.postgresql.org; Tue, 01 Aug 2023 11:57:15 +0000 Received: from [132.174.172.2] (helo=pureos) by ms-10.1blu.de with esmtpsa (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1qQnzx-0003uF-Pc; Tue, 01 Aug 2023 13:57:09 +0200 Date: Tue, 1 Aug 2023 13:57:08 +0200 From: Matthias Apitz To: pf@pfortin.com Cc: pgsql-general@lists.postgresql.org Subject: Re: error: connection to server on socket... Message-ID: Reply-To: Matthias Apitz References: <97d77785-22a0-5d48-9582-4a7beb2dc14f@gmail.com> <20230801072849.2faa25f1.pfortin@pfortin.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20230801072849.2faa25f1.pfortin@pfortin.com> X-Operating-System: FreeBSD 13.0-CURRENT r368166 (amd64) X-message-flag: Mails containing HTML will not be read! Please send only plain text. X-Con-Id: 51246 X-Con-U: 0-guru X-Originating-IP: 132.174.172.2 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk El día martes, agosto 01, 2023 a las 07:28:49 -0400, pf@pfortin.com escribió: > On Tue, 1 Aug 2023 06:22:46 -0400 Amn Ojee Uw wrote: > > >"/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory*//* > > Like mine, your distro probably uses /tmp/.s.PGSQL.5432 > $ ll /tmp/.s.PGSQL.5432 > srwxrwxrwx 1 postgres postgres 0 Aug 1 06:33 /tmp/.s.PGSQL.5432= > This here is on SuSE Linux: # ls -l /tmp/.*5432 srwxrwxrwx 1 postgres postgres 0 Aug 1 13:39 /tmp/.s.PGSQL.5432 # netstat -an | grep 5432 | grep LIST tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN tcp6 0 0 :::5432 :::* LISTEN unix 2 [ ACC ] STREAM LISTENING 22000 /tmp/.s.PGSQL.5432 We normaly use the TCP/IP port 5432 to connect to the server. matthias -- Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub