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 ) id 1rFuvW-00CmCw-E4 for pgsql-admin@arkaria.postgresql.org; Wed, 20 Dec 2023 11:39:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rFuvV-00BsR9-1A for pgsql-admin@arkaria.postgresql.org; Wed, 20 Dec 2023 11:39:49 +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 ) id 1rFuvU-00BsQi-J8 for pgsql-admin@lists.postgresql.org; Wed, 20 Dec 2023 11:39:48 +0000 Received: from mailout2.med.uni-muenchen.de ([138.245.1.13] helo=srvproofp3.srv.med.uni-muenchen.de) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rFuvR-00Cx9t-Rh for pgsql-admin@lists.postgresql.org; Wed, 20 Dec 2023 11:39:47 +0000 Received: from pps.filterd (srvproofp3.srv.med.uni-muenchen.de [127.0.0.1]) by srvproofp3.srv.med.uni-muenchen.de (8.17.1.19/8.17.1.19) with ESMTP id 3BK5vm3u017333; Wed, 20 Dec 2023 12:39:41 +0100 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=med.uni-muenchen.de; h=from : to : cc : subject : date : message-id : references : in-reply-to : content-type : content-transfer-encoding : mime-version; s=gw1201801; bh=bWZzw/sXwcCN6RZrtntWOf7fy7E20//7nI6+Til+tiE=; b=c7S14wvvAKbckakOWvFjAkbF64DXVRBZNlHo2r57UVtdrgAh0g/k5PeFcZe8IqB6V3mC 7wkXlhMauNOQ25H8zoyXNQ7lxS6CvuCJRljMY/sz9C3kbVA1ruVrmgc9aGHmJS3vnk9d stuDXKi1IH/3EmPt5wVNPapFs3urXrPzGHE= Received: from mailout1.med.uni-muenchen.de ([192.168.21.11]) by srvproofp3.srv.med.uni-muenchen.de (PPS) with ESMTPS id 3v10r97ttc-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Wed, 20 Dec 2023 12:39:41 +0100 Received: from mitseppm1 (localhost [127.0.0.1]) by mitseppm1.srv.med.uni-muenchen.de (Postfix) with SMTP id 4SwBRx0CFTz2KZT; Wed, 20 Dec 2023 12:39:41 +0100 (CET) Received: from srvmb2.helios.med.uni-muenchen.de (unknown [172.17.14.136]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mitseppm1.srv.med.uni-muenchen.de (Postfix) with ESMTPS; Wed, 20 Dec 2023 12:39:40 +0100 (CET) Received: from srvmb1.helios.med.uni-muenchen.de (172.17.14.135) by srvmb2.helios.med.uni-muenchen.de (172.17.14.136) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1258.28; Wed, 20 Dec 2023 12:39:40 +0100 Received: from srvmb1.helios.med.uni-muenchen.de ([fe80::2d7a:c5d:25b8:3ce]) by srvmb1.helios.med.uni-muenchen.de ([fe80::2d7a:c5d:25b8:3ce%16]) with mapi id 15.02.1258.028; Wed, 20 Dec 2023 12:39:40 +0100 From: "Dischner, Anton" To: "'depesz@depesz.com'" , Rajesh Kumar CC: Pgsql-admin Subject: AW: Truncate data from whole cluster Thread-Topic: Truncate data from whole cluster Thread-Index: AQHaMyPUoM3HSbeKa0CNSlciqlQQ+bCx5imAgAAk7ZA= Date: Wed, 20 Dec 2023 11:39:40 +0000 Message-ID: References: In-Reply-To: Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [172.17.13.17] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-SM-outgoing: yes X-Proofpoint-GUID: 5S9Dc78C_IWJ-TCxE2G9ejK7GPei961e X-Proofpoint-ORIG-GUID: 5S9Dc78C_IWJ-TCxE2G9ejK7GPei961e List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGkgYWxsLA0KDQppZiB5b3UgYXNrIEJhcmQgTExNIGRvIGRvIHRoaXMgeW91IGdldDoNCg0KIyEv YmluL2Jhc2gNCg0KIyBMaXN0IGFsbCBkYXRhYmFzZXMgaW4gdGhlIFBvc3RncmVTUUwgaW5zdGFu Y2UgZGF0YWJhc2VzPSQocHNxbCAtdCAtYyAiU0VMRUNUIGRhdG5hbWUgRlJPTSBwZ19kYXRhYmFz ZTsiKQ0KDQojIFRydW5jYXRlIHRhYmxlIGRhdGEgZm9yIGVhY2ggZGF0YWJhc2UNCmZvciBkYXRh YmFzZSBpbiAkZGF0YWJhc2VzOyBkbw0KICBlY2hvICJQcm9jZXNzaW5nIGRhdGFiYXNlICckZGF0 YWJhc2UnLi4uIg0KICBwc3FsIC1kICRkYXRhYmFzZSAtYyAiU0VUIEZPUkVJR05fS0VZX0NIRUNL Uz0wOyINCiAgdGFibGVzPSQocHNxbCAtZCAkZGF0YWJhc2UgLXQgLWMgIlNFTEVDVCB0YWJsZW5h bWUgRlJPTSBwZ19jYXRhbG9nLnBnX3RhYmxlcyBXSEVSRSBzY2hlbWFuYW1lID0gJ3B1YmxpYyc7 IikNCiAgZm9yIHRhYmxlIGluICR0YWJsZXM7IGRvDQogICAgZWNobyAiVHJ1bmNhdGluZyB0YWJs ZSAnJHRhYmxlJyBpbiBkYXRhYmFzZSAnJGRhdGFiYXNlJy4uLiINCiAgICBwc3FsIC1kICRkYXRh YmFzZSAtYyAiVFJVTkNBVEUgVEFCTEUgJHRhYmxlOyINCiAgZG9uZQ0KICBwc3FsIC1kICRkYXRh YmFzZSAtYyAiU0VUIEZPUkVJR05fS0VZX0NIRUNLUz0xOyINCmRvbmUNCg0KVGhpcyBtYXkgYmUg YSBnb29kIHNjcmlwdCB0byBzdGFydC4NCllvdSB3aWxsIGRlZmluZXRseSB0ZXN0IHRoaXMgZmly c3Qgb24gYSB0ZXN0IGluc3RhbGxhdGlvbiENCg0KQmVzdCwNCg0KQW50b24NCg0KLS0tLS1VcnNw csO8bmdsaWNoZSBOYWNocmljaHQtLS0tLQ0KVm9uOiBkZXBlc3pAZGVwZXN6LmNvbSA8ZGVwZXN6 QGRlcGVzei5jb20+IA0KR2VzZW5kZXQ6IE1pdHR3b2NoLCAyMC4gRGV6ZW1iZXIgMjAyMyAxMToy NA0KQW46IFJhamVzaCBLdW1hciA8cmFqZXNoa3VtYXIuZGJhMDlAZ21haWwuY29tPg0KQ2M6IFBn c3FsLWFkbWluIDxwZ3NxbC1hZG1pbkBsaXN0cy5wb3N0Z3Jlc3FsLm9yZz4NCkJldHJlZmY6IFJl OiBUcnVuY2F0ZSBkYXRhIGZyb20gd2hvbGUgY2x1c3Rlcg0KDQpPbiBXZWQsIERlYyAyMCwgMjAy MyBhdCAwMjozNTo1MlBNICswNTMwLCBSYWplc2ggS3VtYXIgd3JvdGU6DQo+IEhpIGFsbCwNCj4g DQo+IEkgYW0gdXNpbmcgcG9zdGdyZXMgMTUuMi4gb25lIGxlYWRlciBhbmQgb25lIHJlcGxpY2Eu IEkgaGF2ZSBtdWx0aXBsZSANCj4gZGJzIGFuZCBtdWx0aXBsZSB0YWJsZXMuIEkgd2FudCB0byBr ZWVwIGRlZmluaXRpb25zIGFuZCBvbmx5IHdhbnQgdG8gDQo+IGRlbGV0ZSAnZGF0YSBvbmx5JyBm cm9tIGFsbCBkYnMgYW5kIHRhYmxlcy4NCj4gDQo+IEFueSBjb21tYW5kIHRvIGRvIHRoYXQgaW5z dGVhZCBvZiB0cnVuY2F0aW5nIGFsbCB0YWJsZXMgb25lIGJ5IG9uZT8NCg0KTm8gc3VjaCBjb21t YW5kIGV4aXN0cy4gRm9yIHN0YXJ0ZXJzLCBubyBjb21tYW5kIGluIFNRTCBjYW4gZG8gc3R1ZmYg aW4gb3RoZXIgZGF0YWJhc2VzIHRoYW4gdGhlIG9uZSB5b3UgYXJlIGNvbm5lY3RlZCB0by4NCg0K WW91IGNhbiB3cml0ZSBhIHNpbXBsZSBvbmUtbGluZXIgdGhhdCB3aWxsIGRvIGl0LCBpbiB5b3Vy IHNoZWxsLg0Kc2hvdWxkbid0IGJlIHJlYWxseSBjb21wbGV4IC0gZ2V0IGxpc3Qgb2YgZGJzLCBh bmQgaW4gZWFjaCBkYiBjb25uZWN0IHdpdGggcHNxbCBhbmQgdHJ1bmNhdGUgYWxsIHRhYmxlcy4g YmFzaWNhbGx5OiBgcHNxbCB8IHhhcmdzIHBzcWxgDQoNCmRlcGVzeg0KDQoNCg==