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 1gvmVp-0004sB-FE for pgsql-admin@arkaria.postgresql.org; Mon, 18 Feb 2019 17:15:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gvmVo-0000qw-4b for pgsql-admin@arkaria.postgresql.org; Mon, 18 Feb 2019 17:15:24 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gvmVn-0000qo-N1 for pgsql-admin@lists.postgresql.org; Mon, 18 Feb 2019 17:15:23 +0000 Received: from mout.perfora.net ([74.208.4.197]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gvmVj-0003U2-5G for pgsql-admin@postgresql.org; Mon, 18 Feb 2019 17:15:22 +0000 Received: from [192.168.1.101] ([98.169.208.73]) by mrelay.perfora.net (mreueus002 [74.208.5.2]) with ESMTPSA (Nemesis) id 0MY5Qs-1gZhHz3EUC-00UoJc; Mon, 18 Feb 2019 18:15:11 +0100 Message-ID: <5C6AE81D.2010605@sqlexec.com> Date: Mon, 18 Feb 2019 12:15:09 -0500 From: MichaelDBA User-Agent: Postbox 5.0.25 (Windows/20180328) MIME-Version: 1.0 To: "S. Bob" CC: pgsql-admin Subject: Re: Unique cluster / instance identifier? References: <92d53982-cf1d-ce3f-c541-60a252f85aef@quadratum-braccas.com> In-Reply-To: <92d53982-cf1d-ce3f-c541-60a252f85aef@quadratum-braccas.com> Content-Type: multipart/alternative; boundary="------------090208010003000807000908" X-Provags-ID: V03:K1:F3dkA87gKhLqIqQz6hdTGUgk+OA44BLJ324y0yfjGpRkhqv3REz yEHcRU5rj+Aa3L74oJvpCHNF/nJf1HjlqOcfDJjencTPUZBMo/Wk9WxOmvKUyzAdsMbVK/t QNP/Ho+rubtS9Cr/gYMGggMzSCdJycBRl1AvTvXJpiPg3IPuKX5e3fq95TD4d3wna7lqe78 K5LgtUUk+SIM0dJNVawng== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:WM+8DlWka7M=:wvnnY+rlSqYl4sNJnPKviZ /GaZN3PauVH1w1RpmVLa8vJfDUBdtxuUA1+RbgBzX9tfVXbEDdhL+Jqn8FKnP7czX4kue/IgH uw/DHUyFLZUNG8kFRboCdCseLzHNa9JMmtucQ6w9/ieaGf7UwVHeUOyqL7Z9URD42i8zPk2eD Ld3md4LsuwsB4Gx2Iz++CXVWEy4R0oIzdHHxZxkzcovGov2mdv+XH/vdXs2Vwo8SCUIYhR+Lh G8rN2QBnC/rWgq126/sFQ892fLyIg1Fm9PxGlpCyrGDOLjJdR166hvQdCBxtP3yP0pqIeQV8O uWgkHlRgTCtCQO1YQTfSx+xYY48GBg094r2kRs6tFAhQli5IwnQZ/QRjVM1uQSP/1WWilEAQd 1PxmZ5KbchDNP0IOuZ7gXYMbc6L0i3LUrsE5mSsTy32keGJF+6/aV2XufVg9UZHKI7VU1gCPo SkOa6wKqJRXM/fg0dgVRpc27by3+9in4OlUJ72yolLEL5FP36bHzV7w1JmI6D5FoGKte98X11 /BzuRrLtOMWZqRpbj2pl3+gQarOivzMtaTYdFpFYgrIxh+qpx4yz0wFs40UglwypP5TW1hnO8 HwysC+TcozCqYhadL1kxpLOeJ6TQEaeO2wLIbf7/rXgBCxfgHeaHNiLBavRKpXobOfNFGEHDG ju/OUOjCnZqrN9a0PdRLg90lNb0HATdg8CMevZ7KF0pEJXisszKSnlpqr17bZY8Loa/HXuMbG 0qloOJ4U9tRcGDIoEBdRnz7lA6t0MA5OCP7skZhC6uEl23vfs+INu19nXaA= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------090208010003000807000908 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Since 9.5, you could use cluster_name for this purpose. > S. Bob > Monday, February 18, 2019 12:08 PM > Hi all; > > > Does PostgreSQL store a unique cluster or instance identifier that we > can access to identify our instances? > > > Thanks in advance > > --------------090208010003000807000908 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit Since 9.5, you could use cluster_name for this purpose.

Monday, February 18, 2019 12:08 PM
Hi all;


Does PostgreSQL store a unique cluster or instance identifier that we can access to identify our instances?


Thanks in advance



--------------090208010003000807000908--