Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kRZUm-0003XS-14 for pgsql-admin@arkaria.postgresql.org; Sun, 11 Oct 2020 11:26:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kRZUj-0007Ax-1W for pgsql-admin@arkaria.postgresql.org; Sun, 11 Oct 2020 11:26:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kRZUi-0007Aq-Q3 for pgsql-admin@lists.postgresql.org; Sun, 11 Oct 2020 11:26:28 +0000 Received: from mail.unimaticaspa.it ([89.97.230.136]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kRZUc-0005ZW-AB for pgsql-admin@lists.postgresql.org; Sun, 11 Oct 2020 11:26:28 +0000 Received: from pc-ortensi.unimatica.lan ([10.143.90.16]) by mail.unimaticaspa.it with esmtpsa (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94) (envelope-from ) id 1kRZUa-000EMT-Lp for pgsql-admin@lists.postgresql.org; Sun, 11 Oct 2020 13:26:20 +0200 Subject: Re: Dropping database in replica To: pgsql-admin@lists.postgresql.org References: <1kQrX8-000DtR-G0@unimaticaspa.it> <5a3a8be1138b856f5af6b934f2f34bdd9a901a4d.camel@cybertec.at> From: Massimo Ortensi Autocrypt: addr=mortensi@unimaticaspa.it; keydata= mQINBF2S/Y4BEACh4Cyxq2iu0zyLEzofc8UYjcUeMOo5X47C1JRx9RlQkgE0mzUW0Zn+Lkzb O0mJMQHenwykzwzEPiyKvrs4taBMyUiQYo4plw0K1WE2qP3rr4kfPvWIsgZBRxvQbHCDbhzE Fni46eevSBHK34xlFuIasaoBDFrvhEl5dBut03fZ+QfqIc1jj6/LvhRNfsQclxYoUHVziZ1H wGxgWG9NgaWPpSnQDb57yfEV/eppjakNFn9MoVLheczaMcDcO/VEoS9oI71Af4Kv1n0KhbJf rX7cJ2bAgEUmiePKVpOxyelalIQiPwlnGDEo500JNgCF8GeQudJbGY+YNBpz9KQYDTZ6lKKN IxoK/ZOX8cEWWSPwiJgTgRZ3F7oP3aN2mE3azNuJTMERDwsY0F/vSz/8RI5904kKHSvDOQxM KxtBYYbaNZM+jGlC8e+t3X+a0fPVkEP8xHBoAQwZuAYX26kbJeYEhZfrNX/JWsrbqxlw/bxt zy54ogU1zByMJreegnv3Xahrih0nSB3pkjGyf/63P8rENqhY5cPiaFpvTXyhApE/JRjSJqV9 XbZ3HERPpwOgaZYSwCxhs8r3ilVxxqlATukGis0TCT2bgRzQbO5QV3MYjHwxJfYw7hRaY+Yf o1mPtrrmiotAP842cVysMveUHA/eqalz8qU10oxv2qkK+1rwyQARAQABtCpNYXNzaW1vIE9y dGVuc2kgPG1vcnRlbnNpQHVuaW1hdGljYXNwYS5pdD6JAlQEEwEIAD4WIQTMk4yfoqpMTht3 UT1fqauQuN8NyAUCXZL9jgIbIwUJCWYBgAULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRBf qauQuN8NyNteD/sFx4Pa8lwhr1tHBs0wKazYTUtjX8fmv2Z8Df+XHjhtz3JeSF8k3CZNnIlV YxU/ozbFy8tJeIafsRdLq8NhahsHl0o8CH0HeEiXIwHzn5TnQ3o2CLIGXncQM2NxDYE9UFum lFrc/ZtqJlcJBgcF+s6tVaW0QoM7llWG14DCqlU/dBQU3EoM0MyZrVBgh9UQc4MV/1aa+SeB 54I4gXrtJ0oiNflTsHbm6FuOu6y376KolaqS3vYcBzwBJXC32KqWhN6BVFv+/XzaRG6/Y6Ko xJWexonPkuOXRNpjo2DvPuFPKPqpQAUKIY8ygfmRp9Eh3B0XbQHoGGX4Kdkaw45K4QjfAhc5 ZelDXXMxAclXYeMHzKjfwcTaAtaeGwzCUcGc9h9TJN/gRr8hdYBRPGg+ykO0n7Om+TlVfZe1 HW2WUU0qq3AWdIjelaFeN2AHTxuJY0qIrZgukGa6vhZv3Pdx2sBNdnnG16mY6JqglgoXjr10 MIMslLL0AF8fLmDAHmXEc1zEOBFBTa97tjUJ+ZmzIE1MzZThke8sC9XuC5zID1J2bqkJE7MZ epyhip+m7uA8xD5RPq6B29BThsdV7osxAqt2EWyeNhKeJzuJdib/XxfyWeJzFw3mBPo786Zg 5bbEBDZt8UKHji/IYI/gbD74Za2gvvKPPCQwHymdUfaKefv2RrkCDQRdkv2OARAAs93sU+uq 9VHrCMo2fjwC1uhAH7nkVFAu7TNZV45SjwQLKjMkPtI09/IFa9xMu3EtiBxNCBARGfUjQ92n K931XKvXQ2Q8kxn0a/bY2PN85XXSND5PNzB8KxtvAiyFWZVS4Mw7iVHyJsIuFM5Yb3oPBmkM ru8PaQS7D4Qxu8O0VE1UdWo3Y9ABOhr1qdTSw44yjgQ/ZM8vpYAse/a7ve4v6D3JF0AzsFfR FJwwlPSOmBhNy2zhkfgjg0C1yBm5/3PN4vILRw8XhfujSGgn2RUQIfAebREaIEq4FJq5yVtb 3F5eaMnwwC92plwbGV7QJTv9YUbwp7NYIlSkO4d/tBK6Xjfs3e061eKtw2c/nw6UJuUZzITA 1Z90dFlYOYDt+o+24T1/v2Vpc6+1SE7E0luvSnsMH46GnvcNRSXSyv3C3EtxPU7+5dDM19rR xhLCngJy1K0W9LcqhcU+ntbESa/ldPlDOIBi4tzWoK8GiXsym7O0bLBU2NDq+lGGSkJiYD9+ iIzQZwSDAhovXA9EvdzZaEW1mnHzRa7IFhyusyR7tAcyOkKBaFj8PI7zlOqLVgXBzq9RtcYf 3nvDymR0+jSL2ErdoHooUCOS3VlK38C+mqw7f6BCq1Aw0JWOoMLLvOAiXIqJWBq1GnRRk8MR GJXqpvWH9KnXArcVUv162PxJBLUAEQEAAYkCPAQYAQgAJhYhBMyTjJ+iqkxOG3dRPV+pq5C4 3w3IBQJdkv2OAhsMBQkJZgGAAAoJEF+pq5C43w3Ixm0QAJ3rECbB5D9BNVuk8/k7sYCaTPwU v405LI/hK5W5ucFPV+scTyTqGX+6Eza//+Ad8yMJCsQUH9UiJwIX4gE0wmJu7hYiaNtobnDj YskxEh5A4nXz/T//JhGzC6aSV5uh0ccQNn/E10ATKzwtL5iCb6Iodq0icTpsDsnBNZVdmTbD XqzkeBAi5xMs1jYVZzbzRR4hgYeMq5dhBPa19/BINKadxXUh0VxAxetTfFMsYAXTrS7O/Kz7 yJr0mcqZ06tfJ26vDjG1fd0ZX0daDwV6FOjQfEkIA42Cko6HpiBsRiiif4ObXw5v+u29krT7 1fENVLJLehiw+hV6I6OgD3Usx8h5Oi8gFJi3iiPS62goqL3tUMOzz8eCuYOakyuBbUYRZFOY IuUSyjhJ9Qu9aTA5nsIuQW/XF+CvO1+1uZ3ZceDJX/qTgAy1ghiDyLE3RcYSDxJSoCvdFNKD gOIXmXL4Yn97oG7HAEQlkTqEBiwVeVkuj6ilUGrnaoTD160aRPsUR6XDCpi01M4X3zoNkLjK CfGa1d1tNjEUq/gnYbXzIFzwTEO740W0At0ajfQwGBABrN+HJrRtw0LOqzoLB58b5MinoTKm EBffhZRqHb9Dd0Iv1UdFE5CSYRYyOZD+cK4+cpTZPWzZdH0yrahinyPQ24s+8IdR61cSxTRU XD9vlVms Date: Sun, 11 Oct 2020 13:26:17 +0200 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:68.0) Gecko/20100101 Thunderbird/68.12.0 MIME-Version: 1.0 In-Reply-To: <5a3a8be1138b856f5af6b934f2f34bdd9a901a4d.camel@cybertec.at> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Content-Language: it X-Unimatica-LocalUser: true Message-Id: <1kRZUa-000EMT-Lp@unimaticaspa.it> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk No, replication is running correctly, and the databases existing in the master are up to date Unfortunately replication db logs of the drop database date have been rewritten Il 09/10/2020 17.04, Laurenz Albe ha scritto: > > There must be something that broke replication. > Look into the PostgreSQL log of the standby server. > > Yours, > Laurenz Albe