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 1nqajC-0005y1-U9 for pgsql-admin@arkaria.postgresql.org; Mon, 16 May 2022 13:25:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nqajB-0004ma-Ht for pgsql-admin@arkaria.postgresql.org; Mon, 16 May 2022 13:25:37 +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 1nqahN-0005ar-Co for pgsql-admin@lists.postgresql.org; Mon, 16 May 2022 13:23:45 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nqahI-0007wR-QJ for pgsql-admin@lists.postgresql.org; Mon, 16 May 2022 13:23:44 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 0E324380D36; Mon, 16 May 2022 15:23:38 +0200 (CEST) Received: from rs.plausibolo.de ([127.0.0.1]) by localhost (h2367442.stratoserver.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 9nV6abXKBYLf; Mon, 16 May 2022 15:23:37 +0200 (CEST) Received: from [192.168.178.86] (p5b249905.dip0.t-ipconnect.de [91.36.153.5]) by rs.plausibolo.de (Postfix) with ESMTPSA id B2862380CBD; Mon, 16 May 2022 15:23:37 +0200 (CEST) Message-ID: <288d84eb-9b46-dbae-ceb4-4d2e5bc7f94e@jakobs.com> Date: Mon, 16 May 2022 15:23:37 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.9.0 Content-Language: de-DE To: pgsql-admin@lists.postgresql.org References: <49351195.20220516095634@am-soft.de> <1969313827.20220516145030@am-soft.de> From: Holger Jakobs Subject: Re: How to get a more RSYNC compatible output of pg_dump? In-Reply-To: <1969313827.20220516145030@am-soft.de> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------VtlvoMzFZ5ayQiPCfu5qBmTP" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------VtlvoMzFZ5ayQiPCfu5qBmTP Content-Type: multipart/mixed; boundary="------------9qmVcQ4d2uPXdaRkO5u7XW3O"; protected-headers="v1" From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Message-ID: <288d84eb-9b46-dbae-ceb4-4d2e5bc7f94e@jakobs.com> Subject: Re: How to get a more RSYNC compatible output of pg_dump? References: <49351195.20220516095634@am-soft.de> <1969313827.20220516145030@am-soft.de> In-Reply-To: <1969313827.20220516145030@am-soft.de> --------------9qmVcQ4d2uPXdaRkO5u7XW3O Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 QW0gMTYuMDUuMjIgdW0gMTQ6NTAgc2NocmllYiBUaG9yc3RlbiBTY2jDtm5pbmc6DQo+IEd1 dGVuIFRhZyBIb2xnZXIgSmFrb2JzLA0KPiBhbSBNb250YWcsIDE2LiBNYWkgMjAyMiB1bSAx Mjo1MiBzY2hyaWViZW4gU2llOg0KPg0KPj4gSWYgeW91IHdhbnQgdG8gc3luYyBhIG5ldyB2 ZXJzaW9uIG9mIGEgZmlsZSB3aXRob3V0IHRyYW5zZmVycmluZw0KPj4gdGhlIHdob2xlIHRo aW5nLCB5b3UgaGF2ZSB0byB1c2UgdGhlIG9wdGlvbiAtYyBvciAtLWNoZWNrc3VtLg0KPiBO bywgLS1jaGVja3N1bSBpcyBvbmx5IGZvciAoc2xvd2x5KSByZWNvZ25pemluZyBjaGFuZ2Vz IGF0IGFsbCwNCj4gdHJhbnNmZXIgaXMgZGlmZmVyZW50aWFsIGJ5IGRlZmF1bHQgd2l0aCBv ciB3aXRob3V0IHRoYXQgb3B0aW9uLg0KWWVzLCB0aGUgb3B0aW9uIGNhdXNlcyByc3luYyB0 byBhbHNvIGRldGVjdCBjaGFuZ2VzIGlmIHRoZSBzaXplIGFuZCANCnRpbWVzdGFtcHMgaGF2 ZW4ndCBjaGFuZ2VkLg0KPj4gICAtYywgLS1jaGVja3N1bSAgICAgICAgICAgICAgc2tpcCBi YXNlZCBvbiBjaGVja3N1bSwgbm90IG1vZC10aW1lICYgc2l6ZQ0KPiBodHRwczovL2xpbnV4 LmRpZS5uZXQvbWFuLzEvcnN5bmMNCj4NCj4+IFRoaXMgd29ya3Mgd2VsbCBvbmx5IGlmIHNv bWUgYmxvY2tzIG9mIHRoZSBmaWxlIGhhdmUgY2hhbmdlZCwgd2hpbGUNCj4+IG1vc3Qgb3Ro ZXJzIGhhdmVuJ3QuIFRoaXMgd29uJ3QgYmUgdGhlIGNhc2Ugb2YgYSBwZ19kdW1wLg0KPiBJ dCBpcyB0aGUgY2FzZSBmb3Igc29tZSBkdW1wcyBJJ20gY3JlYXRpbmcsIGJ1dCB0aG9zZSBh cmUgYSBsb3QNCj4gc21hbGxlciBhbmQgZG9uJ3Qgc3RvcmUgbGFyZ2Ugb2JqZWN0cyBsaWtl IGZpbGVzLiBUaGVyZWZvcmUgSSB3YXMNCj4gd29uZGVyaW5nIGFib3V0IHRoZSBvcmRlciBp biB3aGljaCBwZ19kdW1wIG91dHB1dHMgdGFibGVzLCByb3dzIGV0Yy4sDQo+IGUuZy4gaWYg dGhhdCBpcyB0aGUgc2FtZSBhbHdheXMgb3IgY2hhbmdpbmcgd2l0aCBlYWNoIGV4ZWMgZm9y IHNvbWUNCj4gcmVhc29uLg0KPg0KSWYgb25seSBvbmUgYnl0ZSBjbG9zZSB0byB0aGUgYmVn aW5uaW5nIG9mIHRoZSBmaWxlIGlzIGFkZGVkLCB0aGlzIHdvdWxkIA0Kc2hpZnQgYWxsIGZv bGxvd2luZyBieXRlcyBieSAxLCBzbyBubyBibG9jayBvZiB0aGUgZmlsZSB3aWxsIGJlIA0K aWRlbnRpY2FsIGFuZCBoYXZlIHRvIGJlIHJlLXRyYW5zZmVycmVkLg0KDQpUaGVyZm9yZSwg dGhlIG9ubHkgb3B0aW9uIGlzIGNyZWF0aW5nIHNlcGFyYXRlIGZpbGVzIGZvciBlYWNoIHRh YmxlLiANClRoaXMgd291bGQgdHJhbnNmZXIgb25seSB0aG9zZSBmaWxlcyB3aGVyZSB0aGUg Y29udGVudCBvZiB0aGUgdGFibGUgaGFzIA0KYmVlbiBjaGFuZ2VkIHNpbmNlIHRoZSBsYXN0 IHRyYW5zbWlzc2lvbi4gVGhlcmUgaGFzIGJlZW4gYW5vdGhlciBhbnN3ZXIgDQpieSBkZXBl c3ogc3VnZ2VzdGluZyB0aGF0Lg0KDQpSZWdhcmRzLA0KDQpIb2xnZXINCg0KLS0gDQpIb2xn ZXIgSmFrb2JzLCBCZXJnaXNjaCBHbGFkYmFjaCwgVGVsLiArNDktMTc4LTk3NTkwMTINCg0K --------------9qmVcQ4d2uPXdaRkO5u7XW3O-- --------------VtlvoMzFZ5ayQiPCfu5qBmTP Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCYoJQWQUDAAAAAAAKCRCKV5yTsxlhuixV AKDiXJQ+JOgO7j96MYQFAE4ewscjtwCfYVAXbbw3l29qJTKuOCaYPy7ApJI= =CXLK -----END PGP SIGNATURE----- --------------VtlvoMzFZ5ayQiPCfu5qBmTP--