Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ghGRz-0001sb-Ae for pgsql-performance@arkaria.postgresql.org; Wed, 09 Jan 2019 16:11:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ghGRx-0007MP-Uu for pgsql-performance@arkaria.postgresql.org; Wed, 09 Jan 2019 16:11:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ghGRx-0007MC-NV for pgsql-performance@lists.postgresql.org; Wed, 09 Jan 2019 16:11:25 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ghGRv-0003n9-9t for pgsql-performance@lists.postgresql.org; Wed, 09 Jan 2019 16:11:25 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id x09GBJO8002003; Wed, 9 Jan 2019 11:11:19 -0500 From: Tom Lane To: Mariel Cherkassky cc: Jeff Janes , pgsql-performance@lists.postgresql.org Subject: Re: postgresql unix socket connections In-reply-to: References: <19153.1547045702@sss.pgh.pa.us> Comments: In-reply-to Mariel Cherkassky message dated "Wed, 09 Jan 2019 17:17:03 +0200" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <2001.1547050279.1@sss.pgh.pa.us> Date: Wed, 09 Jan 2019 11:11:19 -0500 Message-ID: <2002.1547050279@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Mariel Cherkassky writes: > But in both of the machines I have the same os and I used the same > repository - postgresql rpm repository. The only difference is that in > machine 2 I also installed all pg 9.6 packages. Even When I try to use > /usr/pgsql-9.2/bin/psql the psql still tries to access the > /var/run/run/postgresql dir as the socket dir. Does those packages include > a different libpq ? What postgres package change the libpq ? "rpm -ql" would tell you about which packages supply what. Assuming there's more than one libpq.so on your machine, which it sounds like there is, which one gets used depends on the dynamic linker's configuration -- see /etc/ld.so.conf and "man ldconfig". regards, tom lane