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 1t8KIC-003T2S-DX for pgsql-general@arkaria.postgresql.org; Tue, 05 Nov 2024 14:12:23 +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 1t8KI9-00DqPC-RE for pgsql-general@arkaria.postgresql.org; Tue, 05 Nov 2024 14:12:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t8KI9-00DqO6-F9 for pgsql-general@lists.postgresql.org; Tue, 05 Nov 2024 14:12:22 +0000 Received: from mail-il1-x130.google.com ([2607:f8b0:4864:20::130]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t8KI6-000Kad-0X for pgsql-general@postgresql.org; Tue, 05 Nov 2024 14:12:21 +0000 Received: by mail-il1-x130.google.com with SMTP id e9e14a558f8ab-3a6ad7c5827so17055025ab.0 for ; Tue, 05 Nov 2024 06:12:19 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1730815937; x=1731420737; darn=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=OIxZ9Xj/Bn2BWx/zWOjDHkQAlK9Wc+YC3C84NW9GA8k=; b=IV5g6qCmeBnN4AhXa3dCF1/T15tKwhW/D88PH8B7eMJdwAQnymO3MDNExmfOaYEkUB UEjRvbbyuFbK7IpZ8RdxhUTpjzsnORpaoqv29FljHZ4W4LNhD/Qwa0pqKBfAWgSb9TAR WoOe1Ib97t+79Pbm0/VvsqMVwwuwf/3WtfqDVtVsU8AFKkLsLtDQtHjD5BG6x8seGAE6 h1sqd8uFPV9XuxLN6JHRkRI+izDyFzeAhIQL/nuvKG8Aw5oeY7W8BITIECWhYIAJMd/G v8zfUWOWhMGB1j7Q3Ol6gnGkmTZ8Q19EuiGzzY0PdwkXt/KdrCMl3JsB7K5XRhr85EJL QE1Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1730815937; x=1731420737; 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=OIxZ9Xj/Bn2BWx/zWOjDHkQAlK9Wc+YC3C84NW9GA8k=; b=eJhEuiRpTTdHU82vtU8/XFo2iCc/3Kiyh8bq0wl6sWAjSMUlHNBmJF5x2yGpQd7Ggu bp1nQLbfnJNzvTFH3iT6PX3AN8ozo/T278yPQVPttLJ1uHp/YQsr8iBgg0UXoR0pV4RA UuPveyvKCVjhUQSyF7oqLzlnNOAuX+5RMWvemWd8U9Rt+7VWF86rSe98eQ3tIpzkiaFg HimtjtoM9Cn+VwiJu/zyrifOOAQjhVx56WMO4hSXF19EXP2EeaIpTov595iaJQ2Bq2FQ e8nHCUeyO/GZ6OS5ZrL93tWjn6HMg8xvRIXnqcMtrQLwH/Thd7S7zQVtoBLD8GVKiDk3 kezg== X-Gm-Message-State: AOJu0Yz7VTfdgS2ta0L20GoPfk+l0H+Pddx+WQKBiDB80bjwQbg/RluS XMyGwwKmgHkwU5eWZ+6rM3Es9l4Tibrru87ie+uR/hMaXUPg6yQ3g+bebnLUaCHZfTrnoGhvMa6 imytWQ/lGLT1DhjiRlflJgoiG3p0HBB+l X-Google-Smtp-Source: AGHT+IHfVJx7WxyJy3GhzOhKVWfJujA0roCjQwGKyumo2hckds188QY8h4xtOLjSYu0REXBMRpp9ZMkBtklE5PFkSyc= X-Received: by 2002:a05:6e02:190a:b0:3a4:e75c:c9d5 with SMTP id e9e14a558f8ab-3a6b00c9de4mr187166985ab.0.1730815937251; Tue, 05 Nov 2024 06:12:17 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Greg Sabino Mullane Date: Tue, 5 Nov 2024 09:11:40 -0500 Message-ID: Subject: Re: Postgres listens on random port To: Kal Cc: pgsql-general@postgresql.org Content-Type: multipart/alternative; boundary="0000000000001c91ef06262afdfe" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000001c91ef06262afdfe Content-Type: text/plain; charset="UTF-8" Start by seeing where the port is actually being set by running this: select setting, source, sourcefile, sourceline from pg_settings where name = 'port'; Cheers, Greg --0000000000001c91ef06262afdfe Content-Type: text/html; charset="UTF-8"
Start by seeing where the port is actually being set by running this:

select setting, source, sourcefile, sourceline from pg_settings where name = 'port';
Cheers,
Greg

--0000000000001c91ef06262afdfe--