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 1pgtne-0004Cf-EJ for pgsql-admin@arkaria.postgresql.org; Mon, 27 Mar 2023 20:50:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pgtnc-0001iu-Kq for pgsql-admin@arkaria.postgresql.org; Mon, 27 Mar 2023 20:50:40 +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 1pgtnc-0001ig-5k for pgsql-admin@lists.postgresql.org; Mon, 27 Mar 2023 20:50:40 +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 1pgtnZ-0001wI-LV for pgsql-admin@lists.postgresql.org; Mon, 27 Mar 2023 20:50:39 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 2EEB7380413; Mon, 27 Mar 2023 22:50:35 +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 h2w_der2h5M2; Mon, 27 Mar 2023 22:50:35 +0200 (CEST) Received: from [192.168.1.105] (lab.linuxhotel.de [185.232.103.116]) by rs.plausibolo.de (Postfix) with ESMTPSA id C36B938025E; Mon, 27 Mar 2023 22:50:34 +0200 (CEST) Message-ID: <3ffb1572-28d1-9ae0-5de7-9cfc18600239@jakobs.com> Date: Mon, 27 Mar 2023 22:50:34 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.8.0 Content-Language: de-DE, en-US To: pgsql-admin@lists.postgresql.org References: From: Holger Jakobs Subject: Re: Installing PostGreSQLon Redhat Linux - Help needed In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------fQjiTOG5lGkO0wR7cBDMajkN" 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) --------------fQjiTOG5lGkO0wR7cBDMajkN Content-Type: multipart/mixed; boundary="------------f62AVSbBAY7n4WsW8cy900nq"; protected-headers="v1" From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Message-ID: <3ffb1572-28d1-9ae0-5de7-9cfc18600239@jakobs.com> Subject: Re: Installing PostGreSQLon Redhat Linux - Help needed References: In-Reply-To: --------------f62AVSbBAY7n4WsW8cy900nq Content-Type: multipart/alternative; boundary="------------LKMn9GVXQrXaoi4Jp3kk5yIX" --------------LKMn9GVXQrXaoi4Jp3kk5yIX Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 QW0gMjcuMDMuMjMgdW0gMjE6MTcgc2NocmllYiBTZXJ2ZXQgS2FocmFtYW4gVHVyYW46DQo+ IEhpIFNlbmRodSwNCj4gWW91IHNob3VsZCBkb3dubG9hZCBhbmQgaW5zdGFsbCBmb2xsb3dp bmcgcnBtcyBvbiBsaW5rcw0KPg0KPiBodHRwczovL2Rvd25sb2FkLnBvc3RncmVzcWwub3Jn L3B1Yi9yZXBvcy95dW0vMTUvcmVkaGF0L3JoZWwtOS14ODZfNjQvcG9zdGdyZXNxbDE1LWxp YnMtMTUuMi0xUEdERy5yaGVsOS54ODZfNjQucnBtDQo+DQo+IGh0dHBzOi8vZG93bmxvYWQu cG9zdGdyZXNxbC5vcmcvcHViL3JlcG9zL3l1bS8xNS9yZWRoYXQvcmhlbC05LXg4Nl82NC9w b3N0Z3Jlc3FsMTUtMTUuMi0xUEdERy5yaGVsOS54ODZfNjQucnBtDQo+DQo+IGh0dHBzOi8v ZG93bmxvYWQucG9zdGdyZXNxbC5vcmcvcHViL3JlcG9zL3l1bS8xNS9yZWRoYXQvcmhlbC05 LXg4Nl82NC9wb3N0Z3Jlc3FsMTUtc2VydmVyLTE1LjItMVBHREcucmhlbDkueDg2XzY0LnJw bQ0KPg0KPiBPcHRpb25hbCBmb3IgZXh0ZW5zaW9ucw0KPiBodHRwczovL2Rvd25sb2FkLnBv c3RncmVzcWwub3JnL3B1Yi9yZXBvcy95dW0vMTUvcmVkaGF0L3JoZWwtOS14ODZfNjQvcG9z dGdyZXNxbDE1LWNvbnRyaWItMTUuMi0xUEdERy5yaGVsOS54ODZfNjQucnBtDQo+DQo+DQpT dGlsbCwgd2hlbiB5b3Ugb3BlcmF0ZSB5b3VyIFBvc3RncmVTUUwgc2VydmVyIG9uIGEgbWFj aGluZSB3aGljaCBjYW5ub3QgDQpjb25uZWN0IHRvIHRoZSBJbnRlcm5ldCB0byBjaGVjayBm b3IgdXBkYXRlcywgaXQgd2lsbCBnZXQgb3V0ZGF0ZWQgYW5kIA0KYmUgbGFja2luZyBzZWN1 cml0eSB1cGRhdGVzIGluIHRoZSBsb25nIHJ1bi4NCg0KVGhlcmVmb3JlLCB0aGlzIGlzIHVu ZGVzaXJhYmxlIGFuZCBub3QgYXQgYWxsIHJlY29tbWVuZGVkLg0KDQpLZWVwIGluIG1pbmQg dGhhdCByb3VnaCBndWVzc2VzIHNheSB0aGF0IGFib3V0IGhhbGYgb2YgYWxsIGF0dGFja3Mg Y29tZSANCmZyb20gaW5zaWRlIG9yZ2Fuc2F0aW9ucywgYW5kIG9ubHkgdGhlIG90aGVyIGhh bGYgZnJvbSBvdXRzaWRlLg0KDQpUaHVzIGl0J3MgbmVjZXNzYXJ5IHRvIGtlZXAgc29mdHdh cmUgc2FmZSBhbmQgdXBkYXRlZCwgZXZlbiBpZiB0aGUgDQpzeXN0ZW0gaXNuJ3QgY29ubmVj dGVkIHRvIHRoZSBJbnRlcm5ldC4NCg0KU28geW91IGhhdmUgdG8gY2hlY2sgbWFudWFsbHks IGJ1dCByZWd1bGFybHkgZm9yIHVwZGF0ZXMgKGVzcGVjaWFsbHkgDQptaW5vciB1cGRhdGVz ISkgYW5kIGluc3RhbGwgdGhlbS4NCg0KUmVnYXJkcywNCkhvbGdlcg0KDQoNCi0tIA0KSG9s Z2VyIEpha29icywgQmVyZ2lzY2ggR2xhZGJhY2gsIFRlbC4gKzQ5LTE3OC05NzU5MDEyDQoN Cg== --------------LKMn9GVXQrXaoi4Jp3kk5yIX Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Am 27.03.23 um 21:17 schrieb Servet Kahraman Turan:

Still, when you operate your PostgreSQL server on a machine which cannot connect to the Internet to check for updates, it will get outdated and be lacking security updates in the long run.

Therefore, this is undesirable and not at all recommended.

Keep in mind that rough guesses say that about half of all attacks come from inside organsations, and only the other half from outside.

Thus it's necessary to keep software safe and updated, even if the system isn't connected to the Internet.

So you have to check manually, but regularly for updates (especially minor updates!) and install them.

Regards,
Holger 


--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
--------------LKMn9GVXQrXaoi4Jp3kk5yIX-- --------------f62AVSbBAY7n4WsW8cy900nq-- --------------fQjiTOG5lGkO0wR7cBDMajkN Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCZCIBmgUDAAAAAAAKCRCKV5yTsxlhum9g AKCmFRFbUzF7E2huOXZ8wXODhPSSqQCfYrgWjnA0rFIRovsIDaSW29egtNU= =Z5gT -----END PGP SIGNATURE----- --------------fQjiTOG5lGkO0wR7cBDMajkN--