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 1rO2ay-000iyI-B2 for pgsql-admin@arkaria.postgresql.org; Thu, 11 Jan 2024 21:28:13 +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 1rO2ax-00FFVG-K3 for pgsql-admin@arkaria.postgresql.org; Thu, 11 Jan 2024 21:28:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rO2Z2-00FBms-8j for pgsql-admin@lists.postgresql.org; Thu, 11 Jan 2024 21:26:12 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rO2Yz-0014cF-6O for pgsql-admin@lists.postgresql.org; Thu, 11 Jan 2024 21:26:11 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 707EC38040C; Thu, 11 Jan 2024 22:26:07 +0100 (CET) Received: from rs.plausibolo.de ([IPv6:::1]) by localhost (h2367442.stratoserver.net [IPv6:::1]) (amavisd-new, port 10024) with ESMTP id R1LfaY32cOYL; Thu, 11 Jan 2024 22:26:07 +0100 (CET) Received: from [192.168.178.88] (xdsl-78-34-120-1.nc.de [78.34.120.1]) by rs.plausibolo.de (Postfix) with ESMTPSA id E370238040A; Thu, 11 Jan 2024 22:26:06 +0100 (CET) Message-ID: <983811fd-e0ad-5606-ce9e-3110f73feaec@jakobs.com> Date: Thu, 11 Jan 2024 22:26:05 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.12.0 Subject: Re: Test mail for pgsql-admin Content-Language: de-DE To: Andrew Wang Cc: pgsql-admin@lists.postgresql.org References: <383812ba-230f-9d66-cebe-dd02c4c4f210@jakobs.com> From: Holger Jakobs In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------bsaOTQR7Hvn0L4xl1gfc0FYd" 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) --------------bsaOTQR7Hvn0L4xl1gfc0FYd Content-Type: multipart/mixed; boundary="------------1loFRdK5ln3rdG9sxXA9qsMS"; protected-headers="v1" From: Holger Jakobs To: Andrew Wang Cc: pgsql-admin@lists.postgresql.org Message-ID: <983811fd-e0ad-5606-ce9e-3110f73feaec@jakobs.com> Subject: Re: Test mail for pgsql-admin References: <383812ba-230f-9d66-cebe-dd02c4c4f210@jakobs.com> In-Reply-To: --------------1loFRdK5ln3rdG9sxXA9qsMS Content-Type: multipart/alternative; boundary="------------7ZPwwk3i0roa5FFJLZIOBlBh" --------------7ZPwwk3i0roa5FFJLZIOBlBh Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 VW5sZXNzIHlvdSByZWFkIGFsbCBvZiB0aGUgUG9zdGdyZVNRTCBzb3VyY2UgY29kZSBhbmQg bWltaWMgaXRzIA0KYmVoYXZpb3VyLCBJIHJlZ2FyZCB0aGlzIGltcG9zc2libGUuIFRob3Nl IGZpbGVzIGZyb20gdGhlIERBVEEgZGlyZWN0b3J5IA0KYXJlbid0IHNpbXBsZSBDU1YgZmls ZXMgb3Igc2ltaWxhci4NCg0KDQpBbSAxMS4wMS4yNCB1bSAyMjoyNCBzY2hyaWViIEFuZHJl dyBXYW5nOg0KPiBUaGVzZSBmaWxlcyB3ZXJlIGJhY2tlZCB1cCB0byBhbm90aGVyIExpbnV4 IHN5c3RlbS4gSXMgaXQgcG9zc2libGUgdG8gDQo+IGNvbnZlcnQgaXQgaW50byBhIHByb2dy YW0gcmVhZGFibGUgZm9ybWF0PyBJIGNhbiB3cml0ZSBhIHNjcmlwdCBpbiANCj4gbW9zdCBs YW5ndWFnZXMgdG8gcmVhZCB0aGVtLg0KPiBCZXN0LA0KPg0KPg0KPg0KPj4gT24gSmFuIDEx LCAyMDI0LCBhdCAzOjE44oCvUE0sIEhvbGdlciBKYWtvYnMgPGhvbGdlckBqYWtvYnMuY29t PiB3cm90ZToNCj4+DQo+PiDvu78NCj4+DQo+PiBZb3UgY2FuIGFsd2F5cyBkdW1wIHRoZSBj b250ZW50cyBvZiBhIHJ1bm5pbmcgaW5zdGFuY2UgKGNhbGxlZCANCj4+IGNsdXN0ZXIpIHVz aW5nIHBnX2R1bXBhbGwgY3JlYXRpbmcgYSB0ZXh0IGZpbGUgd2l0aCBTUUwgY29tbWFuZHMs IA0KPj4gd2hpY2ggY2FuIGJlIGZlZCBzdWJzZXF1ZW50bHkgaW50byBhbnkgZW1wdHksIGJ1 dCBydW5uaW5nIA0KPj4gaW5zdGFsbGF0aW9uIG9mIHRoZSBzYW1lIG9yIG1vcmUgcmVjZW50 IHZlcnNpb24gb2YgdGhlIHNlcnZlciB1c2luZyBwc3FsLg0KPj4NCj4+IFdoYXQgaXNuJ3Qg cG9zc2libGUgaXMgZ2V0dGluZyBhIGNvcnJ1cHRlZCBjb3B5IG9mIHRoZSBkYXRhIGRpcmVj dG9yeSANCj4+IGJhY2sgdG8gbGlmZS4NCj4+DQo+PiBVbmxlc3MgeW91IHRvb2sgdGhlIGNv cHkgd2hpbGUgdGhlIGRhdGFiYXNlIHNlcnZlciB3YXMgY29tcGxldGVseSANCj4+IGRvd24s IHJlZ2FyZCBpdCB1bnVzYWJsZS4NCj4+DQo+PiBJZiB0aGUgY29weSBpc24ndCBjb3JydXB0 LCB5b3UgY2FuIHN0YXJ0IGl0IG9uIHRoZSBzYW1lIGFyY2hpdGVjdHVyZSANCj4+IHdpdGgg dGhlIHNhbWUgbWFqb3IgdmVyc2lvbiBvZiB0aGUgc29mdHdhcmUgYWdhaW4gdXNpbmcgcGdf Y3RsLiBMb29rIA0KPj4gYXQgdGhlIGhlbHAgb2YgdGhlIHByb2dyYW0gZm9yIGRldGFpbHMu DQo+Pg0KPj4gV2hlbiB0aGUgZGF0YWJhc2Ugc3lzdGVtIGlzIHJ1bm5pbmcgYWdhaW4sIHRh a2UgYSBkdW1wIHdpdGggcGdfZHVtcGFsbC4NCj4+DQo+PiBBbSAxMS4wMS4yNCB1bSAyMjox MiBzY2hyaWViIEFuZHJldyBXYW5nOg0KPj4+IFRoZXkgd2VyZSBzZXBhcmF0ZWQuIFRoZSBz b3VyY2UgbGlzdCBpbiBVYnVudHUgMTggd2FzIG1vdmVkIGJlY2F1c2UgDQo+Pj4gdGhlIDE2 IGlzIGRpZmZlcmVudCBmcm9tIGZvcm1lciB2ZXJzaW9ucywgd2hpY2ggY2F1c2VkIHRoZSBw cm9ibGVtLCANCj4+PiBhcyBJIHVwZ3JhZGVkIHRoZSBMaW51eCBzeXN0ZW0gYmVmb3JlLCBp dCB3b3JrZWQgdmVyeSB3ZWxsLg0KPj4+DQo+Pj4gSSB0cmllZCB0byBpbnN0YWxsIHRoZSAx NSBhbmQgMTYsIGJ1dCB0aGUgY29uZmlndXJhdGlvbiBjb21wbGFpbmVkIA0KPj4+IHBvcnRz IGFuZCBvdGhlciB0aGluZ3MuIEFueSB3YXkgdG8gZHVtcCBhbGwgaW50byBhIGZvcm1hdCBm cm9tIA0KPj4+IGFub3RoZXIgY29tcHV0ZXIgYW5kIHRoZW4gcmVhZCB0aGVtIGludG8gdGhl IG5ldyAxNj8NCj4+PiBCZXN0LA0KPj4+DQo+Pj4NCj4+Pg0KPj4+PiBPbiBKYW4gMTEsIDIw MjQsIGF0IDI6MjjigK9QTSwgUm9uIEpvaG5zb24gPHJvbmxqb2huc29uanJAZ21haWwuY29t PiANCj4+Pj4gd3JvdGU6DQo+Pj4+DQo+Pj4+IO+7vw0KPj4+PiAiSSBhc3N1bWVkIHRoZXkg Y2FuIG1lcmdlZCBpbnRvIDE2IGJ1dCB0aGV5IHdlcmUgbm90IGFmdGVyIA0KPj4+PiB1cGdy YWRpbmcgbXkgc3lzdGVtLiINCj4+Pj4NCj4+Pj4gWWVhaC4uLiB0aGF0J3MgYSBwcmV0dHkg dW5mb3VuZGVkIGFzc3VtcHRpb24uDQo+Pj4+DQo+Pj4+IEZvcnR1bmF0ZWx5LCB5b3VyIGRh dGEgKm1pZ2h0KsKgYmUgc2FsdmFnZWFibGUsIGlmIHRoZcKgbmV3IHN5c3RlbSANCj4+Pj4g aGFzIHNlcGFyYXRlIC0tIGFuZCBwb3B1bGF0ZWQgLS0gZGlyZWN0b3JpZXMgZm9yIDEyLCAx MyBhbmQgMTQuwqAgDQo+Pj4+IFdlcmUgYW55IG9mIHRoZSBzb3VyY2Ugc3lzdGVtIFBvc3Rn cmVzcWwgaW5zdGFuY2VzIHJ1bm5pbmcgd2hlbiB5b3UgDQo+Pj4+IHJhbiByc3luYz8NCj4+ Pj4NCj4+Pj4gSWYgbm90LCB0aGVuIHlvdSBjYW4gaW5zdGFsbCB0aGUgb2xkIHZlcnNpb25z IG9mIFBvc3RncmVzcWwgaW4gDQo+Pj4+IHBhcmFsbGVsIHdpdGggMTYsIGFuZCB0aGVuIHJ1 biBwZ191cGdyYWRlLg0KPj4+Pg0KPj4+PiBPbiBUaHUsIEphbiAxMSwgMjAyNCBhdCAzOjEx 4oCvUE0gQW5kcmV3IFdhbmcgDQo+Pj4+IDxhbmRyZXcud2FuZy4yMDA5QGdtYWlsLmNvbT4g d3JvdGU6DQo+Pj4+DQo+Pj4+ICAgICBJIHVzZWQg4oCccnN5bmPigJ0gaW4gTGludXggdG8g YmFja3VwIHRoZSB0aGUgZW50aXJlIGRpcmVjdG9yeSB0aGF0DQo+Pj4+ICAgICBjb250YWlu ZWQgZGF0YSBmb3IgMTIsMTMgYW5kIDE1LiBUaGUgbGFzdCAxNSB3YXMgZ29uZSBhZnRlcg0K Pj4+PiAgICAgdXBncmFkaW5nIHRvIDE2IHdpdGggVWJ1bnR1IDIyLjA0LiBJIGFzc3VtZWQg dGhleSBjYW4gbWVyZ2VkDQo+Pj4+ICAgICBpbnRvIDE2IGJ1dCB0aGV5IHdlcmUgbm90IGFm dGVyIHVwZ3JhZGluZyBteSBzeXN0ZW0uDQo+Pj4+ICAgICBCZXN0LA0KPj4+Pg0KPj4+Pg0K Pj4+Pg0KPj4+Pj4gICAgIE9uIEphbiAxMSwgMjAyNCwgYXQgMTo0NuKAr1BNLCBSYWplc2gg S3VtYXINCj4+Pj4+ICAgICA8cmFqZXNoa3VtYXIuZGJhMDlAZ21haWwuY29tPiB3cm90ZToN Cj4+Pj4+DQo+Pj4+PiAgICAg77u/DQo+Pj4+PiAgICAgRGlkIHlvdSB0YWtlIGJhc2ViYWNr dXA/DQo+Pj4+Pg0KPj4+Pj4gICAgIE9uIEZyaSwgMTIgSmFuIDIwMjQsIDAwOjU1IFJvbiBK b2huc29uLA0KPj4+Pj4gICAgIDxyb25sam9obnNvbmpyQGdtYWlsLmNvbT4gd3JvdGU6DQo+ Pj4+Pg0KPj4+Pj4gICAgICAgICAxLiBXaGF0IGlzIHRoZSBzb3VyY2Ugb2YgdGhlIGRhdGEg dGhhdCB5b3UgY29waWVkIHRvDQo+Pj4+PiAgICAgICAgICovdmFyL2xpYi9wZ3NxbC8xNS9t YWluKj8NCj4+Pj4+ICAgICAgICAgMi4gV2hhdCBlcnJvcnMgb3IgcHJvYmxlbXMgYXJlIHlv dSBoYXZpbmc/DQo+Pj4+Pg0KPj4+Pj4gICAgICAgICBPbiBUaHUsIEphbiAxMSwgMjAyNCBh dCAxMjo0M+KAr1BNIEFuZHJldyBXYW5nDQo+Pj4+PiAgICAgICAgIDxhbmRyZXcud2FuZy4y MDA5QGdtYWlsLmNvbT4gd3JvdGU6DQo+Pj4+Pg0KPj4+Pj4gICAgICAgICAgICAgRGVhciBz dGFmZiBhdCBwcXNxbCwNCj4+Pj4+ICAgICAgICAgICAgIMKgSSB0cnkgdG8gKnJlc3RvcmUg YWxsIGRhdGEgZnJvbQ0KPj4+Pj4gICAgICAgICAgICAgL3Zhci9saWIvcGdzcWwvMTUvbWFp biwqIGJ1dCBkbyBub3Qga25vdyBob3cgYW5kIGhhdmUNCj4+Pj4+ICAgICAgICAgICAgIG5v dCBmb3VuZCBoaXRzIGZyb20geW91ciB3ZWIgYXMgZGV0YWlsZWQgYmVsb3cuIENvdWxkDQo+ Pj4+PiAgICAgICAgICAgICB5b3UgcHJvdmlkZSBhIHRpcCBmb3IgdGhhdD9UaGFua3MuIFJl Z2FyZHMNCj4+Pj4+ICAgICAgICAgICAgIFlvdXIgc2VhcmNoIGZvciAqcmVzdG9yZSBkYXRh IGZyb20gL3Zhci9saWIvcGdzcWwvKg0KPj4+Pj4gICAgICAgICAgICAgcmV0dXJuZWQgbm8g aGl0cy4NCj4+Pj4+DQo+Pj4+PiAgICAgICAgICAgICBBbmRyZXcNCj4+Pj4+DQo+Pj4+PiAg ICAgICAgICAgICBPbiBUaHUsIEphbiAxMSwgMjAyNCBhdCAxMTozNeKAr0FNIHBnc3FsLWFk bWluIE93bmVyDQo+Pj4+PiAgICAgICAgICAgICA8cGdzcWwtYWRtaW4tb3duZXJAbGlzdHMu cG9zdGdyZXNxbC5vcmc+IHdyb3RlOg0KPj4+Pj4NCj4+Pj4+ICAgICAgICAgICAgICAgICBI ZWxsbyENCj4+Pj4+DQo+Pj4+PiAgICAgICAgICAgICAgICAgVGhpcyBpcyBhIHRlc3QgbWFp bCBmb3IgdGhlIGxpc3QNCj4+Pj4+DQo+Pj4+PiAgICAgICAgICAgICAgICAgcGdzcWwtYWRt aW5AbGlzdHMucG9zdGdyZXNxbC5vcmcNCj4+Pj4+DQo+Pj4+PiAgICAgICAgICAgICAgICAg YXMgcmVxdWVzdGVkLiBUaGUgbWFpbCBoYXMgdGhlIHNhbWUgbGlzdC1pZCBoZWFkZXINCj4+ Pj4+ICAgICAgICAgICAgICAgICBhcyBlbWFpbCBkZWxpdmVyZWQgdG8gdGhlIGxpc3QsIGFu ZCBjYW4gYmUgdXNlZCB0bw0KPj4+Pj4gICAgICAgICAgICAgICAgIGZvciBleGFtcGxlIHRl c3QgbG9jYWwgbWFpbCBmaWx0ZXJzLg0KPj4+Pj4NCj4+Pj4+DQo+Pj4+Pg0KPj4+Pj4gICAg ICAgICAgICAgLS0gDQo+Pj4+PiAgICAgICAgICAgICBCZXN0LA0KPj4+Pj4NCj4+Pj4+ICAg ICAgICAgICAgIEFuZHJldyBXYW5nDQo+Pj4+Pg0KPj4gLS0gDQo+PiBIb2xnZXIgSmFrb2Jz LCBCZXJnaXNjaCBHbGFkYmFjaCwgVGVsLiArNDktMTc4LTk3NTkwMTINCg0KLS0gDQpIb2xn ZXIgSmFrb2JzLCBCZXJnaXNjaCBHbGFkYmFjaCwgVGVsLiArNDktMTc4LTk3NTkwMTINCg0K --------------7ZPwwk3i0roa5FFJLZIOBlBh Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Unless you read all of the PostgreSQL source code and mimic its behaviour, I regard this impossible. Those files from the DATA directory aren't simple CSV files or similar.


Am 11.01.24 um 22:24 schrieb Andrew Wang:
These files were backed up to another Linux system. Is it possible to convert it into a program readable format? I can write a script in most languages to read them.
Best,



On Jan 11, 2024, at 3:18=E2=80=AFPM, Ho= lger Jakobs <holger@jakobs.com> wrote:

=EF=BB=BF

You can always dump the contents of a running instance (called cluster) using pg_dumpall creating a text file with SQL commands, which can be fed subsequently into any empty, but running installation of the same or more recent version of the server using psql.

What isn't possible is getting a corrupted copy of the data directory back to life.

Unless you took the copy while the database server was completely down, regard it unusable.

If the copy isn't corrupt, you can start it on the same architecture with the same major version of the software again using pg_ctl. Look at the help of the program for details.

When the database system is running again, take a dump with pg_dumpall.

Am 11.01.24 um 22:12 schrieb Andrew Wang:
They were separated. The source list in Ubuntu 18 was moved because the 16 is different from former versions, which caused the problem, as I upgraded the Linux system before, it worked very well.

I tried to install the 15 and 16, but the configuration complained ports and other things. Any way to dump all into a format from another computer and then read them into the new 16?
=
Best,



On Jan 11, 2024, at 2:28=E2=80=AF= PM, Ron Johnson <ronljohnsonjr@gmail.com&= gt; wrote:

=EF=BB=BF
"I assumed they can merged into 16 but they were not after upgrading my system."
=

Yeah... that's a pretty unfounded assumption.

Fortunately, your data might=C2=A0be salvageable, if the=C2=A0new system has separate --= and populated -- directories for 12, 13 and 14.=C2=A0 W= ere any of the source system Postgresql instances running when you ran rsync?

If not, then you can install the old versions of Postgresql in parallel with 16, and then run pg_upgrade.

On Thu, Jan 1= 1, 2024 at 3:11=E2=80=AFPM Andrew Wang <andrew.wang.200= 9@gmail.com> wrote:
I used =E2=80=9Crsync=E2=80=9D = in Linux to backup the the entire directory that contained data for 12,13 and 15. The last 15 was gone after upgrading to 16 with Ubuntu 22.04. I assumed they can merged into 16 but they were not after upgrading my system.
Best,



On Jan 11, 2024, at= 1:46=E2=80=AFPM, Rajesh Kumar <rajeshkum= ar.dba09@gmail.com> wrote:

=EF=BB=BF
Did you take basebackup?=C2= =A0

On Fri, 12 Jan 2024, 00:55 Ron Johnson, <ronlj= ohnsonjr@gmail.com> wrote:
1. What is the source of the data that you copied to=C2=A0/var/lib/pgsql/15/main?
2. What errors or problems are you having?

On Thu, Jan 11, 2024 at 12:43=E2=80=AF= PM Andrew Wang <andrew.wang.2009@gmail.com> wrote:
Dear staff at pqsql,
=
=C2=A0I try to res= tore all data from /var/lib/pgsql/15/main, but do not know how and have not found hits from your web as detailed below. Could you provide a tip for that?Thanks. Regards
Your search for re= store data from /var/lib/pgsql/ returned no hits.

Andrew

On Thu, Jan 11, 2024 at 11:35=E2=80=AF= AM pgsql-admin Owner <pgsql-admin-owner@lists.postgresql.org> wrote:
Hello!

This is a test mail for the list

pgsql-admin@lists.postgresql.org

as requested. The mail has the same list-id header
as email delivered to the list, and can be used to
for example test local mail filters.


--
Best,

Andrew Wang
--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
--------------7ZPwwk3i0roa5FFJLZIOBlBh-- --------------1loFRdK5ln3rdG9sxXA9qsMS-- --------------bsaOTQR7Hvn0L4xl1gfc0FYd Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCZaBc7QUDAAAAAAAKCRCKV5yTsxlhurd4 AKDMqUuCsLaT1sxNgPg2ba6DULbAvACg39H7OW+i3MnWC/vWlNC3bPo3sJs= =uMAn -----END PGP SIGNATURE----- --------------bsaOTQR7Hvn0L4xl1gfc0FYd--