Message-ID: <f57787ec-8e35-cc65-64a6-8b5fb2ce616b@jakobs.com>
Date: Fri, 9 Feb 2024 18:41:39 +0100
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.12.0
Content-Language: de-DE
To: pgsql-admin@lists.postgresql.org
References: 
 <PH0PR22MB33529D6B6891D52EAF8706FCE94B2@PH0PR22MB3352.namprd22.prod.outlook.com>
 <6EF3E79A-DC46-4E47-9088-48230FE235A7@elevated-dev.com>
From: Holger Jakobs <holger@jakobs.com>
Subject: Re: upgrade questions
In-Reply-To: <6EF3E79A-DC46-4E47-9088-48230FE235A7@elevated-dev.com>
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="------------59j8tHVT2R2sgIP7RFr2QTv0"
Archived-At: 
 <https://www.postgresql.org/message-id/f57787ec-8e35-cc65-64a6-8b5fb2ce616b%40jakobs.com>
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--------------59j8tHVT2R2sgIP7RFr2QTv0
Content-Type: multipart/mixed; boundary="------------TGvoiQOlnclKAHh7R6zLrd4h";
 protected-headers="v1"
From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Message-ID: <f57787ec-8e35-cc65-64a6-8b5fb2ce616b@jakobs.com>
Subject: Re: upgrade questions
References: <PH0PR22MB33529D6B6891D52EAF8706FCE94B2@PH0PR22MB3352.namprd22.prod.outlook.com>
 <6EF3E79A-DC46-4E47-9088-48230FE235A7@elevated-dev.com>
In-Reply-To: <6EF3E79A-DC46-4E47-9088-48230FE235A7@elevated-dev.com>

--------------TGvoiQOlnclKAHh7R6zLrd4h
Content-Type: multipart/alternative;
 boundary="------------DcQG602SsyBt1bxpuw9sLaM9"

--------------DcQG602SsyBt1bxpuw9sLaM9
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: base64

QW0gMDkuMDIuMjQgdW0gMTg6MDcgc2NocmllYiBTY290dCBSaWJlOg0KPj4gT24gRmViIDks
IDIwMjQsIGF0IDEwOjAw4oCvQU0sIERhdmlkIEJhcnJvbjxkYXZpZC5iYXJyb25AemVuY29z
LmNvbT4gIHdyb3RlOg0KPj4NCj4+IEnigJl2ZSBhbHNvIHNlZW4gcmVmZXJlbmNlcyB0byBj
b3B5aW5nIG92ZXIgdGhlIHBnX2hiYS5jb25mIGFuZCBwb3N0Z3Jlc3FsLmNvbmYgZmlsZXMg
ZnJvbSB0aGUgb2xkIGRhdGEgZGlyZWN0b3J5IHRvIHRoZSBuZXcuDQo+IFRoZW4geW91IHdp
bGwgYmUgZ2V0dGluZyBkZWZhdWx0IHZhbHVlcyBmb3IgdGhlIG1hbnksIG1hbnkgcGFyYW1l
dGVycyBhZGRlZCB0byBwb3N0Z3Jlc3FsLmNvbmYgYmV0d2VlbiAxMSAmIDE1LS1hbmQgd2ls
bCBoYXZlIG5vIGV4cGxhbmF0b3J5IGVudHJpZXMgZG9jdW1lbnRpbmcgdGhlbS4gQSBtdWNo
IGJldHRlciBzdWdnZXN0aW9uIGlzIHRvIGRpZmYgdGhlIHR3bywgYW5kIGFwcGx5IGN1c3Rv
bWl6YXRpb25zIGZyb20gdGhlIG9sZCB0byB0aGUgbmV3LiAoQWxzbyBza2ltIHJlbGVhc2Ug
bm90ZXMgZm9yIGFueSB0aGF0IGhhdmUgYmVlbiBtb290ZWQuKQ0KDQpTY290dCBpcyByaWdo
dC4gQ29weWluZyBhbiBvbGQgcG9zdGdyZXNxbC5jb25mIG92ZXIgYSBuZXcgb25lIGlzIGEg
DQp0ZXJyaWJsZSBpZGVhLg0KDQpUaGVyZSBpcyB0aGUgZ2VuZXJhbCBhZHZpY2UgdG8gbmV2
ZXIgbWFrZSBjaGFuZ2VzIHRvIHBvc3RncmVzcWwuY29uZiANCihleGNlcHQgYWN0aXZhdGlu
ZyB0aGUgaW5jbHVkZV9kaXIgaW5zdHJ1Y3Rpb24gY2xvc2UgdG8gdGhlIGVuZCBvZiB0aGUg
DQpmaWxlKS4NCg0KaW5jbHVkZV9kaXIgPSAnY29uZi5kJ8KgwqDCoCDCoMKgwqAgwqDCoMKg
ICMgaW5jbHVkZSBmaWxlcyBlbmRpbmcgaW4gJy5jb25mJyBmcm9tDQogwqDCoCDCoMKgwqDC
oCDCoMKgwqAgwqDCoMKgIMKgwqDCoCAjIGEgZGlyZWN0b3J5LCBlLmcuLCAnY29uZi5kJw0K
DQpTb21lIGRpc3RyaWJ1dGlvbnMgaGF2ZSB0aGlzIG9ubHkgYXMgYSBjb21tZW50LCBzbyBy
ZW1vdmUgdGhlICMgYXQgdGhlIA0KYmVnaW5uaW5nIG9mIHRoZSBsaW5lIGFuZCBkb24ndCBm
b3JnZXQgdG8gYXQgbGVhc3QgY3JlYXRlIHRoZSBkaXJlY3RvcnkgDQpjb25mLmQsIGJlY2F1
c2Ugc29tZSBkaXN0cmlidXRpb24gcGFja2FnZXMgZG9uJ3QgY3JlYXRlIGl0Lg0KDQpBTEwg
Y2hhbmdlcyB0byB0aGUgY29uZmlndXJhdGlvbiBzaG91bGQgZ28gaW50byBmaWxlcyB3aXRo
aW4gdGhpcyANCmRpcmVjdG9yeSBoYXZpbmcgbmFtZXMgZW5kaW5nIGluIC5jb25mDQoNCklm
IHlvdSBoYXZlIHRoZXNlLCBpdCdzIHZlcnkgZWFzeSB0byBjb3B5IHRoZW0gb3ZlciB0byBh
IG5ldyBjbHVzdGVyIA0KKHNhbWUgb3IgbmV3ZXIgbWFqb3IgdmVyc2lvbikgYW5kIGFkYXB0
IGlmIG5lY2Vzc2FyeS4NCg0KSXQncyBiZXN0IHRvIGNvcHkgc2VjdGlvbnMgZnJvbSB0aGUg
b3JpZ2luYWwgcG9zdGdyZXNxbC5jb25mIGluY2x1ZGluZyANCmFsbCBjb21tZW50cyBhbmQg
bWFrZSBuZWNlc3NhcnkgY2hhbmdlcyBvbmx5IHdpdGhpbiB0aGUgY29uZi5kIGRpcmVjdG9y
eS4NCg0KUmVnYXJkcywNCg0KSG9sZ2VyDQoNCg0KLS0gDQpIb2xnZXIgSmFrb2JzLCBCZXJn
aXNjaCBHbGFkYmFjaCwgVGVsLiArNDktMTc4LTk3NTkwMTINCg0K
--------------DcQG602SsyBt1bxpuw9sLaM9
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html>
  <head>
    <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF=
-8">
  </head>
  <body>
    <div class=3D"moz-cite-prefix">Am 09.02.24 um 18:07 schrieb Scott
      Ribe:<br>
    </div>
    <blockquote type=3D"cite"
      cite=3D"mid:6EF3E79A-DC46-4E47-9088-48230FE235A7@elevated-dev.com">=

      <blockquote type=3D"cite">
        <pre class=3D"moz-quote-pre" wrap=3D"">On Feb 9, 2024, at 10:00=E2=
=80=AFAM, David Barron <a class=3D"moz-txt-link-rfc2396E" href=3D"mailto:=
david.barron@zencos.com">&lt;david.barron@zencos.com&gt;</a> wrote:

I=E2=80=99ve also seen references to copying over the pg_hba.conf and pos=
tgresql.conf files from the old data directory to the new.
</pre>
      </blockquote>
      <pre class=3D"moz-quote-pre" wrap=3D"">
Then you will be getting default values for the many, many parameters add=
ed to postgresql.conf between 11 &amp; 15--and will have no explanatory e=
ntries documenting them. A much better suggestion is to diff the two, and=
 apply customizations from the old to the new. (Also skim release notes f=
or any that have been mooted.)
</pre>
    </blockquote>
    <p>Scott is right. Copying an old postgresql.conf over a new one is
      a terrible idea.</p>
    <p>There is the general advice to never make changes to
      postgresql.conf (except activating the include_dir instruction
      close to the end of the file).</p>
    <pre>include_dir =3D 'conf.d'=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=
=A0=C2=A0=C2=A0 # include files ending in '.conf' from
=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0=
 =C2=A0=C2=A0=C2=A0 # a directory, e.g., 'conf.d'
</pre>
    <p>Some distributions have this only as a comment, so remove the #
      at the beginning of the line and don't forget to at least create
      the directory conf.d, because some distribution packages don't
      create it.</p>
    <p>ALL changes to the configuration should go into files within this
      directory having names ending in .conf</p>
    <p>If you have these, it's very easy to copy them over to a new
      cluster (same or newer major version) and adapt if necessary.</p>
    <p>It's best to copy sections from the original postgresql.conf
      including all comments and make necessary changes only within the
      conf.d directory.</p>
    <p>Regards,</p>
    <p>Holger<br>
    </p>
    <br>
    <pre class=3D"moz-signature" cols=3D"72">--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012</pre>
  </body>
</html>

--------------DcQG602SsyBt1bxpuw9sLaM9--

--------------TGvoiQOlnclKAHh7R6zLrd4h--

--------------59j8tHVT2R2sgIP7RFr2QTv0
Content-Type: application/pgp-signature; name="OpenPGP_signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="OpenPGP_signature"

-----BEGIN PGP SIGNATURE-----

wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCZcZj0wUDAAAAAAAKCRCKV5yTsxlhunqj
AJ9u3e5CYwzzaau+dLcC25fIbmZC8wCdFTG2fQF0JKdI3n7lOnQIEIk/XUk=
=wZC9
-----END PGP SIGNATURE-----

--------------59j8tHVT2R2sgIP7RFr2QTv0--