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.92) (envelope-from ) id 1jBKfy-0001jz-C0 for pgsql-bugs@arkaria.postgresql.org; Mon, 09 Mar 2020 15:50:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jBKfx-0000NC-5X for pgsql-bugs@arkaria.postgresql.org; Mon, 09 Mar 2020 15:50:41 +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 1jBKEI-0007q6-8M for pgsql-bugs@lists.postgresql.org; Mon, 09 Mar 2020 15:22:06 +0000 Received: from mout-p-101.mailbox.org ([2001:67c:2050::465:101]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_CHACHA20_POLY1305:256) (Exim 4.92) (envelope-from ) id 1jBKEF-0004Gj-A8 for pgsql-bugs@lists.postgresql.org; Mon, 09 Mar 2020 15:22:05 +0000 Received: from smtp2.mailbox.org (smtp2.mailbox.org [IPv6:2001:67c:2050:105:465:1:2:0]) (using TLSv1.2 with cipher ECDHE-RSA-CHACHA20-POLY1305 (256/256 bits)) (No client certificate requested) by mout-p-101.mailbox.org (Postfix) with ESMTPS id 48bhlr1Lc0zKmR9; Mon, 9 Mar 2020 16:22:00 +0100 (CET) Authentication-Results: spamfilter01.heinlein-hosting.de (amavisd-new); dkim=pass (2048-bit key) reason="pass (just generated, assumed good)" header.d=mailbox.org DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mailbox.org; s=mail20150812; t=1583767318; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:autocrypt:autocrypt; bh=z7kkjUMgVU9Irnu4ALHhxFMpG5TFpvPdGLZqOeM2nlc=; b=kSZu6e7yJ1Hvm/lWQKA7O+87/Txavy+3ufbumXnr+93zIrphZxhSvRX4pSx1YR8XZr3Gn6 aATgSZwcl9oDfpxxKMOKo3flLtZFlz3f4sABTCs34y2RNlHxdIbiYmzUvs0cSdkdkNJd43 rbrQ8lDS8jsGIHUbvxFAljFeGPbWVkecjd1Fw3pSt+MWWVSUz4MX3BZcWn16xdLyYCfpbJ vEBf+uAm+k1J+0pKO955isxLOHuXIuJqGn5hGW6eEDUuonFJXROeexH8gLh4luUZ9vPHwT PzAZd5M9Q2LiLzizUgKkK4Z/XVOD1BUSOfP6Q6/DvHADmldeDv4VujFcbmoE1g== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=mailbox.org; h= content-transfer-encoding:content-language:content-type :content-type:in-reply-to:mime-version:date:date:message-id:from :from:references:subject:subject:received; s=mail20150812; t= 1583767317; bh=qnK0NoqhmCTgwkSCkub4U/dJNcXd0ewxpbjnyeorffc=; b=J WkVQfFt6piRYuS1YrWnR0u9F7rudkd0TRtNQD+oedaqOyxnx2DXrSc+R1BK5k3zm 7zfcBSr0dgwevl8pOoMl86IpXqveo42fPhaP8V7f4xivjaiaWj8MSPHtH6ZiI9FY 1tbBOMyPgZlmOUy8sNuEYmurIk+man5ide0ASdZt2xCZ4DH2JWLxlyno13tJkrI2 3q3Y78M3N5MrhLwQETaRnON4spZCvZbfz0CvLKUrERGnQ7IgQy3uSAVtfx9lS2vl YSFOP2gO9EVdB5XVVt6bWXscMm1xgkZtQjtYzH17M2Ihb3epHoLsP3A+olkQwJ9K A3+KbrO7N3iTQfP+D2YTA== X-Virus-Scanned: amavisd-new at heinlein-support.de Received: from smtp2.mailbox.org ([80.241.60.241]) by spamfilter01.heinlein-hosting.de (spamfilter01.heinlein-hosting.de [80.241.56.115]) (amavisd-new, port 10030) with ESMTP id HUYZ3lMDpl9z; Mon, 9 Mar 2020 16:21:57 +0100 (CET) Subject: Re: BUG #16288: application_name from client's primary_conninfo not set in pg_stat_replication on master To: Sergei Kornilov , "daff@ptmx.at" , "pgsql-bugs@lists.postgresql.org" References: <16288-67b2b6ad2d4178c6@postgresql.org> <4325811583763530@vla5-dcf36e533bf7.qloud-c.yandex.net> From: Andreas Ntaflos Autocrypt: addr=daff@mailbox.org; keydata= xsFNBFSHkbUBEADRZaoNudpTstWKX9LkktOpaKMnP67Iu3vdE0H+KSHMJp0A2ttF7TgIU5sQ cCBjsx9lKnLQWiZTozXOySrhnHavkQE9Ke3KeOSgQjPJxnNHyLlsH+xCXITjw7Jedydo639i HHpbUy2hnvcG4daWGbmaciY+aLl2kB6++jEC99jokgXZ6xgUML7BlCcW1IeH0PQvxcIbZE9c wzew5qOQxtd7kF6aErEQ7jmIMHEbcgfRBVpGeP2d4xogZZIc8Ss2z7AlffS88jY1eU9QD2H8 KZtviDowncEGue0YgDVZ8cumeTPDKvskVGjj4sFQm8X10ph8I6PcXHT5lTBiBz8+ozppZVpg E/azsAkVKFHJiGxInT2I5yyQOqx+9CAVAmBdFyXkngLLGmKzMCmkczzEm0znyCZq3s7Ge7UT Jim84YoP5qaOUR5ej8CZwjT/tiV4cu5IFdBtTSWe8XYnOWBx3Zlcp+vRM75ev62rZPHpc4tV IJv2r3K6G3sOU+a/f9m9w/UAPEaA77co2742RJgJa8en2pOvfk7KaZes3Vt6Jg4F3dbgusqV rtTWotP24U1rXSSEodgyrz2omvrAch93/kWLRucSeQAbQy0sAb9ewf9gzD5jR0czChHJcU1X OrR3I4EHCfIWq9i0zA9z1fANmxYbB16RsJI1d+pBYeJy8vnWEQARAQABzR5BbmRyZWFzIE50 YWZsb3MgPGRhZmZAcHRteC5hdD7Cwa8EEwECAEICGyMGCwkIBwMCBhUIAgkKCwQWAgMBAh4B AheAAhkBFiEEZHhotZH6nLIFXg4DHiTp8RCCO7MFAl3unS4FCRLNDPkAIQkQHiTp8RCCO7MW IQRkeGi1kfqcsgVeDgMeJOnxEII7szj1D/956n6gP9YecV8YcQFmJLeQoPt3XjxdOgDfk8WT lL2K214vpcWuwrNfFyJdEclTqq7+BYCYVwikdhYdCY+abbOqNvqDgsOzCayfpas+vk7MHurb XZ07qLWnyqIHMA3e3xLEzVmEUamu/crL6rKuBMPHKh7yu2mhN/K/W3r1RFoRbv67ObT4M2ep 8jJVL3eSy53FFSfpUWjLnsVPpMpysyhkFvEITmb/w8h4sWHTj65FGoxCSOZ+1xYJEQRYC1Uh rqwX7aL8mOyQ3bSeutdmJV5F8xpFDZZFu76dHaI903vygQVSiLEca6S4z5bJVG0HhtK2uWTR BUJwYNkdJweZzlN7F7h7csl2FtC/TQHM1DE3NYFYzJ9Dxd6i5aJ37uijeqzUHiJebKW3BM02 ilgdkl1THzro2EIcCsS3TIQbvgDmzY0dNNZu2yhRvRaebEOVqPIAvK8w/0dn1XErUsk3Ku7y aRBHwkenMWtPFlpaZElwAW5CsbC8ckwEMr9Jr29dCGJSZa8AHJfRfCDHheFi+xU558ln9LEM HuBoPiRM2TvS+NYAipINOspG75ttBXMNYa3cIAGKPprars8IP3nVGsFy/Vpdhy7VXOEN4L9U 3TwY20lKPVVmfxopummYlUGENotCXEGT0F2ekQ5E9zjc45i028lca/zVYNOTFAIyjyfChc7B TQRUh5G1ARAAvMwvFxqdjdi5EOhzxFMwhbh8voyz2aetIdAGtPVtaW+lxRjEbja5aYIS1ZrT y7s5v+wOnD9AbF+EoixqdqgbFAo9JHuAK9w9Zkaoo0ymfh53JqT+CyEaEPh7Xh6HsktaLWzQ U9Eli+yrUbu8YhrnWcezt3k1zeSGtxK1k83mdolN4JRxzHZPmoKh9lUiSbR4Dxu5Tyn+vQhD DC9OqxaR2R8QsahZ2FY9P9xeXULUrkWZ2R0PW0K4zXMLTqNRKPeLn9gpZfoefrAfCvxr/q3p KuSa2XXqzJW/FGGGtuYxivvKZCm0r8zU4N4rE6OYK148c8HLJNpmorcH+1cci9Q6ZDnIvS8D dU1fx1r0mXmerq0oLdjeUNaWbLdpwDnp8D2jdOotpDahbwfZVVueYkA1xQwq9XkkaX0StlEv QI5/icmTBoFgm87qZBgAfzQb97OMNI7jRUHmnj/7do3Pdsfs12+heDaWlYIqtfjt5vmxlE2y 81ncKGZ3G/KalR7fW5eGD1B3NVVLza89npWxhi1iRNzZmcIhoEMv9JK5XeJAX/rPuykLuBch YORMXdRQFv8LT/7PRx2mFflVASIGt9lN2J02N+T2IfzagdYGfuqhxotjuWIX7NG4s6bz1ztE bTpRE1fRYk3tpFP7zI/r8kZ8S3MDDlepTQh66orgu8AR0FcAEQEAAcLBZQQYAQIADwUCVIeR tQIbDAUJCWYBgAAKCRAeJOnxEII7s7HjD/9ApNyMNN//vMHK20nskSX34nzIZufJy2OPbFvZ O26xGry0Gt+nGVQopmp35Hy0DZlbQu670k5kodrKdfLq8K09W4AD8hhqwxn904RhquHIGber Q1poMTc9Ark73PrCjCnznOmI1bjV/x6jybbaZnaijAWsRIJdmHdEEahvwuIubNvCoDVmEYj0 GGhSsMEDCda6mqcHPTGFLFPIRyMIHFXmGoDUFb+yKtY8QTadNmziKr26nExhv+UGAcXT/oO/ iyI/34LT+shn+6RNZ+VGg59ZnH8AKVqT/eNTNk6Ykre5t7zxEfFxcFxTPiYVzgkiZIr34w3T tMYBdoDmsPqtopDR1M9Hz9bEThpc0rlzvP2gdVH5n0wfyDdETtGUtzpQqPZlIY12K0g3ysz8 c1DlfJnDR9KSJWb5PbW9m6tXDzPcis4H+sIZ6MYzOxDCIe12I6wcuPC3PaBRP4qv4Is9vLi5 FypfqHfVG/SnZwrJ8Fk8KIT3q8yOlQjvXcHqY51r39aivTHk+iXskNUeJ7Gsfyj/pnSiXwiA UJ4IrEjWkd2uIfzze8Vt5QwTGB1D/6XoIJu/o+WLJuy2utQuGiSCiXBwyNgTsV8nJK7PF32i Jw2TOaFlHZpPCC4agVc8Pp0U22NeyCCRF55sWDzhX8PhKARRc8lAShvXeHA+366D2vgMicLB kwQYAQIAJgIbDBYhBGR4aLWR+pyyBV4OAx4k6fEQgjuzBQJd7p00BQkSzQz/ACEJEB4k6fEQ gjuzFiEEZHhotZH6nLIFXg4DHiTp8RCCO7OHgxAAlfLlhQCcFbeazlaYqkouTGy9v2m18s6q xNS9CiGPV+wlbFkZCNP3cOpKLKw9+jPu2MBi6DodkIFoBpCilMkg2vkgKusH36Cy2S5UA6on L1+WtGSR+b3YImfFYWaKi3BS7WdIwtEkyJImxwg1oPfjSO5YgI/S/dSa+xEfw80yeNicmVLr y237F3OIKHPlVRNk5JxIA8z0CaFOLyPpWZJIZJ8z4s2InRwltP9yY94Oub9McMrxF/deoiQR xuFGpsS4GmCWA4cVyNhX/kQzczkdA3fPEyEUeGtrqNb/WEItjZjO5NiJ6xfa8nBf8MiJ341s 9jqwgarysUimRhsxvgl2mq6MELdpeAL0lF4zrACEBrFVSXTmdDoPXdGcV8gwuOn+xTlfRubu v+hOFLIT9ty7pL4phepmoljBNn6IBX1GI7irgolp4hyNPlvVp6V+ZXSuHERZRVASbkyQVjk+ njkGIL1vZTJ5uFban8asfMADY4FVYywY04VlV/coU9+Hz1b28M/XWFD0Q8FAcxjk2Yg7sa2g Pgb/9KVXK4WY3sjV2dmJMy0wcO6cJKNJDpo+RZzqAHfrlYJkd6nZIYx7yoesm07S8pMN6KcC GuEddfPBPfq6nJaWhn2a1RP+w6naICnkTdNgIWmi06NNXAGgJZtHow06MH1LfNR4KX1QnM8J QV0= Message-ID: <3cff229b-0929-46de-1fd4-687810d97d91@mailbox.org> Date: Mon, 9 Mar 2020 16:21:55 +0100 MIME-Version: 1.0 In-Reply-To: <4325811583763530@vla5-dcf36e533bf7.qloud-c.yandex.net> Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 09.03.20 15:31, Sergei Kornilov wrote: > Hello > > Works for me. Thank you very much for the quick reply and pointing me to the solution! > Please share results of such queries: > > select * from pg_stat_wal_receiver; > select * from pg_file_settings where name = 'primary_conninfo'; > > Cluster name will be used as fallback application name when no application_name was provided. I think you have several primary_conninfo, one of which is in postgresql.auto.conf that was created by pg_basebackup -R You are absolutely right, there was a postgresql.auto.conf created by pg_basebackup -R that did not contain the application_name field in the primary_conninfo setting. Once I deleted that file and reloaded the PostgreSQL streaming client everything started working as expected. In the past the Pacemaker resource agent would overwrite any recovery.conf file that might have been left by pg_basebackup -R so this discrepancy in primary_conninfo fields would never be a problem. But now, in accordance with PostgreSQL 12, the Pacemaker resource agent manages the file /var/lib/pgsql/tmp/recovery.conf which contains the primary_conninfo setting. That file is included from postgresql.conf: include '/var/lib/pgsql/tmp/recovery.conf' # added by pgsql RA So the file postgresql.auto.conf is no longer deleted or overwritten, but remains in place, containing a "wrong" primary_conninfo setting. This trips up the Pacemaker resource agent. Thank you again for the most valuable pointer! I did not really believe this could be a proper bug in PostgreSQL itself but I was thoroughly out of ideas because I did not know or realize that postgresql.auto.conf even existed. Much appreciated! Best regards, Andreas