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 1kQraK-0003LI-Ia for pgsql-admin@arkaria.postgresql.org; Fri, 09 Oct 2020 12:33:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kQraJ-0002k0-HV for pgsql-admin@arkaria.postgresql.org; Fri, 09 Oct 2020 12:33:19 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kQrXD-0006sY-DD for pgsql-admin@lists.postgresql.org; Fri, 09 Oct 2020 12:30:07 +0000 Received: from mail.unimaticaspa.it ([89.97.230.136]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kQrXA-0007SV-UR for pgsql-admin@lists.postgresql.org; Fri, 09 Oct 2020 12:30:06 +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 1kQrX8-000DtR-G0 for pgsql-admin@lists.postgresql.org; Fri, 09 Oct 2020 14:30:02 +0200 To: pgsql-admin@lists.postgresql.org 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 Subject: Dropping database in replica Date: Fri, 9 Oct 2020 14:30:01 +0200 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:68.0) Gecko/20100101 Thunderbird/68.12.0 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-15 Content-Transfer-Encoding: quoted-printable Content-Language: it X-Unimatica-LocalUser: true Message-Id: <1kQrX8-000DtR-G0@unimaticaspa.it> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi everybody. I have a stand-by database replicated sending wals In the master cluster I dropped one of the databases, but the db is still present in the replica cluster. Is this normal or a misbehaviour of replication ? Then I tried to drop db manually in the standby db but of course got an error because the db is in read only mode. Any suggestion of a clean way to drop the db in D/R site ? Thanks in advance