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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1uBrgC-007Y1W-Gz
	for pgsql-admin@arkaria.postgresql.org; Mon, 05 May 2025 09:00:05 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1uBrgB-002REN-L7
	for pgsql-admin@arkaria.postgresql.org; Mon, 05 May 2025 09:00:03 +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 <s.malathouras@deltasoftsolutions.net>)
	id 1uBr9w-002HJV-2X
	for pgsql-admin@lists.postgresql.org; Mon, 05 May 2025 08:26:44 +0000
Received: from mail-westeuropeazon11022127.outbound.protection.outlook.com
 ([52.101.71.127] helo=AS8PR03CU001.outbound.protection.outlook.com)
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <s.malathouras@deltasoftsolutions.net>)
	id 1uBr9s-000Eqd-2x
	for pgsql-admin@lists.postgresql.org;
	Mon, 05 May 2025 08:26:43 +0000
ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none;
 b=IgPOyqv15G4IxsCqs38zA8Yc6hh+rtknAGIrZDhOxkxjdvIS71Xiq2bpkGNPYmaRuRbhyO2Nb5LgrbN9MNCWQSnxZ/wF+tvu+X6LF4z135ko8Y91Yq6CEEdaLOZeaGO6DF2vrJNEJHH6okpKLZJR8xmemCiopAdFYk56+rNBDzwd+OcJRknsw5LcP5fTJxyWi2si/jaGmlMffFkvgZ16w75db9vt4X+lNWfYH7LwJVEMqjmYjtKIcelIvISTs97edSM+d9gQu9P2W0yt4rQ0W9A/JfQPMTiH5Y9+tO0BvLyDhlH+qSbdl6uARqVAxhRvLMvNFVaTjnzU8TvCEaocSg==
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com;
 s=arcselector10001;
 h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1;
 bh=APuh/d/YXLV7HAiQxeqXK+2/Ft8JxPUyHwudQzL1j+k=;
 b=jT5+nr8eGxG710ENGV/1CaPLL9XK4QKLk6GFL1UnkTOyL9wvKkEOds2vjIFZdXNriUEPGe4TBCtI/mv6niM0rSkVhsHzD1b+1nh6cUWibmBH8lj15hMUyL4Yas+xNoCmVWO3+iLDQEg5jRzbEpEN4RFqImJU2eRScSx+ErlPt5/HK1iVUTp5lA/hx0nT1IjjmJrR7PvWcuT0j2dlODIcyXxkEHY7rr5yU1hQCROTAG9p7GLW5fmExhnFEsOP7UaL6fW584VlxFYFN0n3qq2vhnQ5T1zYC7JOSrIhGpTRwmulr6z+dh6BUFOvmRBHd3po6DPCodS6QoJWEYnikw2XDQ==
ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass
 smtp.mailfrom=deltasoftsolutions.net; dmarc=pass action=none
 header.from=deltasoftsolutions.net; dkim=pass
 header.d=deltasoftsolutions.net; arc=none
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=deltasoftsolutions.net; s=selector1;
 h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck;
 bh=APuh/d/YXLV7HAiQxeqXK+2/Ft8JxPUyHwudQzL1j+k=;
 b=hg4MwIw8oobtWP3m+oeKiZ0QgPSVUWZOiljXh4UdcmgJvE39XLNordqMsPpZN+ZRhaozIpx0nxdqFqTC8z86417JPgGmYGs9djzrTmd8kuSCmSpnpCMjswx0DsBoxhLP9hhXSKSISRhoTljHBC/PHHNna4IRg6VoUluA9vXcQD9Ok4o96czGXzZT2PA1K00hYZX1z4DPFXrElvalEE9mYzWk0+n/MZPPjSORy3krBR6886KPIZiXQwH8bNA5C0uA/y8kQu9F5HoazKSgNpWRpGlBHnHhwlU7cbmo1M2OmJ5L1dcc4Z6gHuC7dpVyYbeaU4ikG5ZMs6x1Oj6IK5UObQ==
Received: from PAWPR05MB10431.eurprd05.prod.outlook.com
 (2603:10a6:102:2f0::16) by AS1PR05MB9323.eurprd05.prod.outlook.com
 (2603:10a6:20b:4d4::14) with Microsoft SMTP Server (version=TLS1_2,
 cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8699.26; Mon, 5 May
 2025 08:26:38 +0000
Received: from PAWPR05MB10431.eurprd05.prod.outlook.com
 ([fe80::1097:ea34:f60d:59e2]) by PAWPR05MB10431.eurprd05.prod.outlook.com
 ([fe80::1097:ea34:f60d:59e2%4]) with mapi id 15.20.8699.019; Mon, 5 May 2025
 08:26:38 +0000
From: Stelios Malathouras <s.malathouras@deltasoftsolutions.net>
To: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Subject: Does PostgreSQL listen_addresses='*' Dynamically Detect New
 Interfaces
Thread-Topic: Does PostgreSQL listen_addresses='*' Dynamically Detect New
 Interfaces
Thread-Index: AQHbvZSB8wxyOnhJyEGxBErOEca9uA==
Date: Mon, 5 May 2025 08:26:38 +0000
Message-ID: 
 <PAWPR05MB10431391F889466D240403A988D8E2@PAWPR05MB10431.eurprd05.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
msip_labels: 
authentication-results: dkim=none (message not signed)
 header.d=none;dmarc=none action=none header.from=deltasoftsolutions.net;
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: PAWPR05MB10431:EE_|AS1PR05MB9323:EE_
x-ms-office365-filtering-correlation-id: f3f5a602-1de1-440e-5981-08dd8bae8e0e
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: 
 BCL:0;ARA:13230040|376014|366016|1800799024|8096899003|38070700018;
x-microsoft-antispam-message-info: 
 =?iso-8859-1?Q?Bkkq5x0+B192Q/jxkjZqTt6hqIUBm6PG8WGaoIgZmCpScfdKs0ZUSBh7MK?=
 =?iso-8859-1?Q?fZH5xdkb7QfoEnEJV/xNOf8x8cgSrsEFMiQt0iLp5Q2/P8KPnVXDzUT6nO?=
 =?iso-8859-1?Q?zPgWsTc37CsxywQeDVB+FXF27J5A10zjszglbkF22x70BgQBCORBW4JWF0?=
 =?iso-8859-1?Q?MFMF9Sg0Oziz5anik8tYiaDWk/bMzCkGsSClb5q71zSu19qlNUg5nAqx0H?=
 =?iso-8859-1?Q?qYLU8Mv1HEWmB0sKro4wtFDIELAmn6Dl20U2EHttECpKfrep7L8V6foiFS?=
 =?iso-8859-1?Q?BYer9EZlcKAXaGyL8IO/OMRmye6v/FdYb1/0455oQZfnIJIoeWCWqYJK4T?=
 =?iso-8859-1?Q?QBI+/j15B0xduIfw0YIbEQXkprGXte2A9+XrRU8cH1oveg7AUU/aydz3sC?=
 =?iso-8859-1?Q?ORCGEymk0TEVjCBrFeAJGPxGfknT+JVix4NpALXXm3piM6IUjYL68ohE+q?=
 =?iso-8859-1?Q?8/4T+bmc85coo9hOxJdot9Dikd8wCd1gPggvIlzUITln/xnjtpYuOwF4UV?=
 =?iso-8859-1?Q?zUDRxJ6lkDneEURiiuW0D7OJPAvxTFrgLrHLZJdOoEN1HfxjWELWmtWymD?=
 =?iso-8859-1?Q?iRKqfeyxfpR2aC4kg346KED2KgaIuDdJnROpDiJ6t1oKiXhfUO+bXPsuuC?=
 =?iso-8859-1?Q?rYdnEmVTcYew/kk4Ld+rZFiDmFThIpAAl1RN1xF9PAJ183wT6VSZ/eJNmL?=
 =?iso-8859-1?Q?p86xs/MbZjNh1+oBsv3L62m/dS5pumAkLWYumAllk6B0PnLrvb145NYq9W?=
 =?iso-8859-1?Q?t4qsj16U8ApPq1PObkQxfddFPSzpUJE2+QeWjQPv86YEiC8pD67sa3DS/c?=
 =?iso-8859-1?Q?PhCuLk9vNnuteHFYCc3rahw9+eKWDcuTuhx36PVwwFu7iYftadplAF38Yf?=
 =?iso-8859-1?Q?EhfTzdaUtNP+flAchoM5+Dx97JdHEemZfGMicKZUott3Fp2H6ViNUkJtQV?=
 =?iso-8859-1?Q?O8XDgTrszvZys1nIwPRhEPUS7re6xCxOPqZtry4mVQEMXg3HU3ldSPkUFD?=
 =?iso-8859-1?Q?WT7aDhuu0VO+SGKtsFV0TCWpTLepH1TvpeJup3G5b9akDY/Mqc2WfVl2pT?=
 =?iso-8859-1?Q?s5lajTNLdFlT97YV4HurZ1MB/l34+kcDMAzmuaNwX8NXWkYR12qdkqk3Ux?=
 =?iso-8859-1?Q?I4x++g62u3Hvc/o4tdOo5IFimzYM3KGpzhhErZzjyW4b48AufoGCaWct6N?=
 =?iso-8859-1?Q?gKx5pvY3IqhP7bLvaqFwBXBmt+onAS0cDBhAWi2k9ZbQHJ+1baUorQSVWJ?=
 =?iso-8859-1?Q?mnwnbAIri2XCp6uuZdNjLny/KvMEgHG5zzovRC5KwVZiavenqaulHKmAAe?=
 =?iso-8859-1?Q?VJm0cDgBXOykKyHy1332CzqtT97kqbzA7bSre63tOUfeDYO+eXa8BSXPB7?=
 =?iso-8859-1?Q?ULPOHBboKjqrLVym6a4bK2NgeOkIufujK0aEnOrljBfUOvG00Aa7d8IQmw?=
 =?iso-8859-1?Q?PMKG/0PEQF6nCKlIzjPzrLMN6RgV6Ldhj5Rw60hLFq19V/dR9Hsr0CshDX?=
 =?iso-8859-1?Q?NamRwpK/U73qFwkYyNXq/xVDnDYRaB9hGcgXbyW+fZmw=3D=3D?=
x-forefront-antispam-report: 
 CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:PAWPR05MB10431.eurprd05.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(376014)(366016)(1800799024)(8096899003)(38070700018);DIR:OUT;SFP:1102;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?iso-8859-1?Q?kn5SyKFxkz1P3d1vUot4Xo38hiI6UibKN1u5GTZsXku9Th+Qf0kOaiglif?=
 =?iso-8859-1?Q?JdQ1s2WCI5FQk3guj+ZGjnkyaRpWIyPOzqf78yKEy/6l+bnR4GN6pC0GVF?=
 =?iso-8859-1?Q?Elt8BX3TMh7Yp4Cd5Jlgp7PyfM6AF+3sXPWHwW7COoLGsBxohLMgP7Kr5l?=
 =?iso-8859-1?Q?ym7W0qDcfjoXJTIxztBxLIMbkxhB5xQ/nK6Tj+WMNuLfxOtbkM2En9hN38?=
 =?iso-8859-1?Q?UgYyJPU7tvAfr3BtbPV7wAR0xxMVs2A+ou0pBLlaiF9LrdCseO4N3RkeTB?=
 =?iso-8859-1?Q?hqdu4MI7gHw4LYxHqTM2+8Dqx0rMq7/CA4GE1zjE9qE6NzTzmrZ5vFeONs?=
 =?iso-8859-1?Q?PFPGMrkh2AzgKndyLn1Xej3IkdqrjEkoMJ+aBSYAn9hcUmQewrVbR0/66m?=
 =?iso-8859-1?Q?y1meNX1H6xE1uPeau8yN3JbgyzzU3i//b5ceEmRpNR/QRtQhZOw+lbZkbv?=
 =?iso-8859-1?Q?qeTzoUhPe2futb2JU5J45OijEE8ucxbNZDZgurqhEcwRC0Lu/XF/oRGcv7?=
 =?iso-8859-1?Q?rPIjjYu8ABYBnTQUkm0pbs+Xrca7mvPCY4Rvr5pCusygI+gJKezvXuO1CV?=
 =?iso-8859-1?Q?Ua98HdbUKKFbVwRVF9Vx4JOGacqIRw3i6AsqaKliEInJRX232MZ31UH/TD?=
 =?iso-8859-1?Q?Y4cqIVjWClpwxaQtGJuB7zQG33gkuFECI3eQ4Wnxv/2wf0n1qskizp7qcv?=
 =?iso-8859-1?Q?6GMaHfVO2T/lTPMEiSDOziGQuKgykIOcRnsNX30XBwMhkhzJlfuzEiV5Zo?=
 =?iso-8859-1?Q?sSVqbWx/28Mt+vcI6riwDO+qYThyHypLnH+C6zFPL8MMUOO9M/QW+wHuaT?=
 =?iso-8859-1?Q?5DSV86CFesNY7+vpAiktfMLSZeCnmubFoEMNjBoT0fx0/H4DrcCoQg384p?=
 =?iso-8859-1?Q?yUPx/CpWESr4TqjXvQEFvu7ihnZ355RSyIx6UCJcNZJCuPNRDw1xorBxVb?=
 =?iso-8859-1?Q?vbnSRe/4yCx6GSv7WaQzI9d1AyZYQGzGUJbflEHYDlAkWNAjXxW7p3CtgW?=
 =?iso-8859-1?Q?vzNZjHjcC7c06Ys38IGspe9V6af+uHVjWbsU2fl4AUaE51Gq/Fg6ayGRhw?=
 =?iso-8859-1?Q?zpnx6oHvvYw8qA7cQZEQJWpeP9N6NIYij8VDy2gCj8qJwkoOIztgUhJpyc?=
 =?iso-8859-1?Q?Pgk7EuqnpKpa8kMyPWOGuq5Kg+owAXAze+AOHn4GLTSzFJ6i8/08GSYcV+?=
 =?iso-8859-1?Q?0/j+IGr9PYRoRpPXdThzLYJVx2rRIgYEaC9ps664cF/MalX3IJPEKg6OVF?=
 =?iso-8859-1?Q?yMmHYth5yqYd6Ai0CGUaT2uHw+etCVJw9VUY9s98HqzUo3tHj6Ec6rLqs4?=
 =?iso-8859-1?Q?yqQDiNC9c4rq5/O3YGYasaPt+0OTovG86im2b/4sAjks+SWXiFRDprGYb+?=
 =?iso-8859-1?Q?ZqXBaAccXvtrlT3a9qpkxphyrGvSTBm2RvGnZkaVZrB7o4+tkbytf5dHGa?=
 =?iso-8859-1?Q?Zsdy73SmRHPxrBLDi5fi0oXn6OqTKWWQJPErTVbh+SzJQNiCYngHWc7llx?=
 =?iso-8859-1?Q?emJ/7yyqHUtA5ObzaPp1/ZKJ8U6nJ0H/NGtd1jQ6GOwMCBF37lXR5qijC4?=
 =?iso-8859-1?Q?rcwpl2P34q/fK3gDiBvIZGGt/SErPNO2iZCe+f4hk7S+qcJGbeGeYuC8kX?=
 =?iso-8859-1?Q?jSwGIRZzbQ+APC4iU//Lm1IzxZvPgNeImVHEWxTzPb/Rc6vESnuwLeIA?=
 =?iso-8859-1?Q?=3D=3D?=
Content-Type: multipart/alternative;
	boundary="_000_PAWPR05MB10431391F889466D240403A988D8E2PAWPR05MB10431eu_"
MIME-Version: 1.0
X-OriginatorOrg: deltasoftsolutions.net
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: PAWPR05MB10431.eurprd05.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 f3f5a602-1de1-440e-5981-08dd8bae8e0e
X-MS-Exchange-CrossTenant-originalarrivaltime: 05 May 2025 08:26:38.0309
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: d063c893-051f-4b02-8460-a8aa24fc54b7
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 AL3g3lHogzz6mdDFAG/3EKmrhVuXMvoF7bFCN1t81op8lY7apgkBFnwSmeLOGFGTvhS1Xvp31dJnYCKcNVYoZgopMCuPGj/uvF7Wq/n6vPVq/ABQtJtX/fz/LCU69wJt
X-MS-Exchange-Transport-CrossTenantHeadersStamped: AS1PR05MB9323
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/PAWPR05MB10431391F889466D240403A988D8E2%40PAWPR05MB10431.eurprd05.prod.outlook.com>
Precedence: bulk

--_000_PAWPR05MB10431391F889466D240403A988D8E2PAWPR05MB10431eu_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

We've scheduled for an IP change for one of our dedicated PostgreSQL server=
s, running on version 13.8.
Our local tests, with listen_addresses =3D '*',  show that the postgres lis=
tener accepts connections immediately to the new IP.
The same behavior is observed when adding a new network interface.  Postgre=
s accepts connections to the new network interface (and IP) immediately wit=
hout requiring a restart.

Is it safe to assume this is the default behaviour ? How does the instance =
detect new interfaces and their IP(s) and begin listening on them without n=
eeding a service reload or restart?

Thanks,

Stelios



--_000_PAWPR05MB10431391F889466D240403A988D8E2PAWPR05MB10431eu_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none;"> P {margin-top:0;margin-bo=
ttom:0;} </style>
</head>
<body dir=3D"ltr">
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; c=
olor: rgb(0, 0, 0);">
Hi,</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; c=
olor: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; c=
olor: rgb(0, 0, 0);">
We've scheduled for an IP change for one of our dedicated PostgreSQL server=
s, running on version 13.8.</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; c=
olor: rgb(0, 0, 0);">
Our local tests, with listen_addresses =3D '*',&nbsp;&nbsp;show that the po=
stgres listener accepts connections immediately to the new IP.</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; c=
olor: rgb(0, 0, 0);">
The same behavior is observed&nbsp;when adding a new network interface.&nbs=
p; Postgres accepts connections to the new network interface (and IP) immed=
iately without requiring a restart.</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; c=
olor: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; c=
olor: rgb(0, 0, 0);">
Is it safe to assume this is the default behaviour ? How does the instance&=
nbsp;detect new interfaces and their IP(s) and begin listening on them with=
out needing a service reload or restart?&nbsp;&nbsp;</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; c=
olor: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; c=
olor: rgb(0, 0, 0);">
Thanks,</div>
<div id=3D"Signature" class=3D"elementToProof">
<p style=3D"margin-right: 0cm; margin-left: 0cm; font-family: Aptos, sans-s=
erif; font-size: 12pt;">
<span style=3D"font-size: 10pt; color: black;"><b>Stelios</b></span></p>
<p style=3D"margin-right: 0cm; margin-left: 0cm; font-family: Aptos, sans-s=
erif; font-size: 12pt;">
&nbsp;</p>
</div>
</body>
</html>

--_000_PAWPR05MB10431391F889466D240403A988D8E2PAWPR05MB10431eu_--