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 1u2q7l-006gzJ-Ra for pgsql-general@arkaria.postgresql.org; Thu, 10 Apr 2025 11:31:14 +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 1u2q7k-00Ajum-7f for pgsql-general@arkaria.postgresql.org; Thu, 10 Apr 2025 11:31:12 +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 1u2q7j-00AjuX-PB for pgsql-general@lists.postgresql.org; Thu, 10 Apr 2025 11:31:12 +0000 Received: from mail-ed1-x52e.google.com ([2a00:1450:4864:20::52e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u2q7e-0042yi-0C for pgsql-general@lists.postgresql.org; Thu, 10 Apr 2025 11:31:11 +0000 Received: by mail-ed1-x52e.google.com with SMTP id 4fb4d7f45d1cf-5ec9d24acfbso3172099a12.0 for ; Thu, 10 Apr 2025 04:31:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=peoplecall-com.20230601.gappssmtp.com; s=20230601; t=1744284664; x=1744889464; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=zmR2VM8c/JUQhciGyvZ2HTik/5+JNkVrtsdRSqH8ZWQ=; b=Kaqn37e53g1+Ql0l8/3ZMXGuFrY90zTJaAllvMozg3dClke7780Jiy9FSoRuBOlQhg zd7bQwvkNykVwVvleiMClfxa18rtlaU8ZuVg0pyeXmkvC5wSFA/wrb03Bt/+sF59X1ot Wkg4f4M8CmY/RTm4LQoxYsvA7h608eR2IjfWcVLXSZSnlD0I4apXeC7k8EjUJz46Cnz/ Qm3yf7fVdpZFETbYPKnJAnogu5uAGTY7odrkiqApE7sykOEKC1LwD7HwxeizLOJY+sQZ WUb7ibY5y30H7n2Bx52VF4Dxtkv23g+14MdxQSKep2U3iE/B3D1U9KS9Y/GQMz0Cp2wo ++1g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744284664; x=1744889464; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=zmR2VM8c/JUQhciGyvZ2HTik/5+JNkVrtsdRSqH8ZWQ=; b=ra9+MjkR07QuWfyBl+XIqFKg1U3DaJ6j6pa3gTBwJzXeWzwz8uSR3Mjayc/scgEz6y AYFAmwGa0SEYMsMxPhXpz1x7sWHKZT2bI9WQQUsp5czPyTzWttGzjAzDRlJxLZmAHhPA ShwWMd/WeeosfdpvYv8mG0sScV3sJFerg0/x6XfUz4yk2OKgsSWNLMOEVTxZlsm9fICv oPDWgxzaaSAx7XfWd+bbWGCn09ZSnmrY5uMFvw0NkJKLj02G5R+vE4rd0Ja3ja0bAVje RykK73EIwIvODHSmc1omXJQFSPEvBbgx5JwmbIvWU5kIPLXrOWJqPWauawdfetW4cu2w jEiA== X-Gm-Message-State: AOJu0Yz0+CTtslGr2oOAjwhB7eyxUvoBRm0TPwhRm1ZuXE98Ay4xYcR8 +31rDFKPTpDZsd6c3u/8qNXdyr6d2XAbt6/DBRJNVn2T+XlzBZnt+95io/5PuP/IMFn5RWiqMPk uJ6Gruo6h5aoeNCsjlZDv58X3N9P8tgdh6I7I X-Gm-Gg: ASbGncuYdJB+iHSGzyhuqfqeAlzOu6inu2EsswcCcND0yv3Xuatvd+qEMnXdrcPvyo6 aECMsf+7yKkmJOJm10JMsG5V8Bs3a0jUyUmYYUjaIZXJGqWGo5b5UM2jctv2Rg+6lIdV56j0BS5 iiQNXrmhYyzsllrEOKNco= X-Google-Smtp-Source: AGHT+IFueaEm4iouaUPBUFxFjqfbwnoWb/fiRz9Fdrs8+YmM6ZaRY7or2BgBU35mE1Q4YfUpyOV3pQqYJs8I9TczNNI= X-Received: by 2002:a17:907:9805:b0:ac2:26a6:febf with SMTP id a640c23a62f3a-acabc48f077mr165762266b.20.1744284664324; Thu, 10 Apr 2025 04:31:04 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Francisco Olarte Date: Thu, 10 Apr 2025 13:30:27 +0200 X-Gm-Features: ATxdqUEkQHLYymeynYZJ8IeT_Uob48u0mnjHTzb9xAvelhjA9Ewa0xOlOJM-BdM Message-ID: Subject: Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it) To: "Abraham, Danny" Cc: "pgsql-general@lists.postgresql.org" Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 9 Apr 2025 at 19:44, Abraham, Danny wrote: > Thanks for the answers. > All the 3 lines are, of course, uncommented for the test. That was assumed. > I am using Linux, socket is in /tmp, i see the .s files , but local trust still does not connect. You forgot to answer the first and most important question. > How are you connecting? Your symptoms matches confusing local with > TCP/IP to localhost. They are not the same thing. For what we know you maybe trying to connect to the database using "echo hi", and then the what will surprise us is you were able to connect via tcpip. Francisco Olarte.