From: Dmitry O Litvintsev <litvinse@fnal.gov>
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: Seeing new stuff in log after upgrading from 11 to 15
Thread-Topic: Seeing new stuff in log after upgrading from 11 to 15
Thread-Index: AQHapx4yTBk/dPtCZUK+q2HV1X+7lLGY9zgAgAACHGw=
Date: Thu, 16 May 2024 00:00:36 +0000
Message-ID:
 <SA1PR09MB7311C351A55835B6C58903BDB9EC2@SA1PR09MB7311.namprd09.prod.outlook.com>
References:
 <PH0PR09MB730858270F65D1E2CBBF6708B9EC2@PH0PR09MB7308.namprd09.prod.outlook.com>
 <1921891.1715817056@sss.pgh.pa.us>
In-Reply-To: <1921891.1715817056@sss.pgh.pa.us>
Accept-Language: en-US
Content-Language: en-US
msip_labels:
authentication-results: dkim=none (message not signed)
 header.d=none;dmarc=none action=none header.from=fnal.gov;
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: SA1PR09MB7311:EE_|SA1PR09MB9929:EE_
x-ms-office365-filtering-correlation-id: 2e94b420-07bc-4835-bf50-08dc753b36c5
x-fermilab-ob: 1
x-fermilab-sender-location: inside
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;ARA:13230031|1800799015|366007|38070700009;
x-microsoft-antispam-message-info:
 =?Windows-1252?Q?60SNXQfDzDIe2QFj+bUWtYDn5gdJN2TVjXWEU9aMWDiimiITQF10Ce1e?=
 =?Windows-1252?Q?ISO2dNuY44jUFmCv7PhKTlhb0oaBleUslbdGG1u7vor/x7bRZxk++ukA?=
 =?Windows-1252?Q?TAfmJ9M0KqnKb9yuPbVNpVK/QfvKcE4OCZH3kStBNptJwTBmLMri6uaP?=
 =?Windows-1252?Q?LToNfHrpEbhuFzOiFF685w2F7CoQx3tIGEqNS1+T/0Fu7LgE1NQClvMW?=
 =?Windows-1252?Q?ITkrAgd7a9yhFVkoVH5shcbVbsiMpAKs/evV3xAL9mdiOHPaoMs/C81n?=
 =?Windows-1252?Q?TaLBBjRXFwO8F8G6huaN83j+6QuIsz0q3yqhyK3NHe7ZWf3RKPBEw2VA?=
 =?Windows-1252?Q?bSg+MuWLogFq4Jr7z6Xu9bMnP/bHS0LSwYWu2wSXTAk8K8jxv0QWT1aa?=
 =?Windows-1252?Q?YBoeSkkerjoSbwPmkV2qC9qyDE2kOKOM2KMj4x4PHkoHF+X/rpPKb+q0?=
 =?Windows-1252?Q?RpXFp6abEahB2bqXWuGA0AVZwhS5g9rGiDXUxI/Gu57GTIOHMzy6WLHZ?=
 =?Windows-1252?Q?GhvUqTpAlmPKX80/GeJBB5bLJ8CnTjEZD5LqaFCWMt0ko8sHkq8/PK70?=
 =?Windows-1252?Q?HuAM70tK5hkh+OdJ1YNnuRSWm8stPE2cvRUa/6zjXwoUWeTr7tRa2VEl?=
 =?Windows-1252?Q?QoP1AC7JySVgWlAJZs650IyPHM+jt9UN/09oZ+ezEIBcCVHgfiXVIEu9?=
 =?Windows-1252?Q?UuVRv4XywiPKz91E+WbPWjMy9yZ1hXX9xN9c1QgfHYg4r7A4BGvR1veK?=
 =?Windows-1252?Q?4RLasMPnJ/lIY6RnybulAu3IyQzewu0En9kPWFRvOge0xO3lckRsF5sA?=
 =?Windows-1252?Q?1pkIWxzbpey9iXZssLLxOHMYtqNizNcujfchKgYQYBEuKkBK1Zq5AEb+?=
 =?Windows-1252?Q?V1Kc+tFitmUv8/67zcuDlN7isQHbxFUFV4kw5EleqtGmFDXJOaPt/nRb?=
 =?Windows-1252?Q?lRY9HQtdyjW5OA50ilCo2I+A+LQHhnllEVCqDo7x626jgko4WMWLBpP9?=
 =?Windows-1252?Q?zgJOwpo/CHeftlD1E0ROtzq8TSKy6lrDIJqn2VkMCrzcMutYDLv9bYya?=
 =?Windows-1252?Q?YLwCnJfPcoRfKQ5NVJ9XLje/96XBPOwRwjuxZqrJKOVkgfAPmgY/AfVb?=
 =?Windows-1252?Q?k5MnSYixl2c62/8I9gjgWsqr9AhYiwvAVm7gW31Dejl/dm7GvU/09XZR?=
 =?Windows-1252?Q?2rDWKIoqy29hhPcYtAXiuDYPzq62CUfftXUszDMPMxys5AiUG/Gep1hq?=
 =?Windows-1252?Q?J1GxVdDuPq2vrbv1Yd3VBQtdighRmcxcoweXydd3QAznR7gW/Rj5rK22?=
 =?Windows-1252?Q?SX/dkDLqdbSTX37mtQ7XTrikMjZ/gdJK14Rl1DTr7o46e65vxYfjsGw0?=
 =?Windows-1252?Q?3g+MSX2H8twBIkQSdqkaBSPYH3KJ2eD41HrG9lftvnnaHRzJ0IXECTGD?=
 =?Windows-1252?Q?G5SzLw3U4IeMQ3Q8i6ytSg=3D=3D?=
x-forefront-antispam-report:
 CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:SA1PR09MB7311.namprd09.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230031)(1800799015)(366007)(38070700009);DIR:OUT;SFP:1101;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?Windows-1252?Q?TcfYpd9564lfuF/hSh574B+pynPqed3I4vvJP8G6FYz8emyVXHiA5ham?=
 =?Windows-1252?Q?/e5bEYAdAwueGSNoB2PjTdbPxLFHYm+5Fz+5jHNABD1EOHPkjT2Mr0OH?=
 =?Windows-1252?Q?WMWWxSuU0kkx7189Xee2JM+Cu5DaxXjKRLekMKSQqcXMrQfGKGgB9uBc?=
 =?Windows-1252?Q?lwv+32QadEGWR8e4ifNoMmYgqma508QTtIt/w8kRgzIZ1PN1Mjplh6wq?=
 =?Windows-1252?Q?4QstT69xe89inblx36ts2zHj5vl2F7Kry6iezlPlxomQoUiNSchMXopi?=
 =?Windows-1252?Q?WHmJs4Hez2fKcFNvuMDGmX/OMOCyYXoQhWwn5YRJsV/08bSi5ZNz1Iip?=
 =?Windows-1252?Q?phiVHYaIx3eF7tw2mFO71ZW6WGSmtinp7MvXpjIGjj9wc8RBobSFQWNI?=
 =?Windows-1252?Q?0wYfe79DjagCXMNsysB2HEydGB6J3c0lNzWsvXrCy6D6Uy09mmPrehq5?=
 =?Windows-1252?Q?JeUXYDyERO3IpefWxAqB50SyBTMKG3xQqwFfYDMYP2sO37XdMAP2T2lD?=
 =?Windows-1252?Q?uzum0Uiu2+hADK+tzev7Jr98fvpnt1ZlbTqzjupWT+GDZCzwhW97CIHE?=
 =?Windows-1252?Q?1Fi0wQYgmNcwHCADY5urYnyPZ9osGX+STvczSDas5srHKPl/o4y19evw?=
 =?Windows-1252?Q?nh+WKawC6steDnY4nT4xylPdfgmZmxD0jh3dCKEUH4tr8D711ncL4FUn?=
 =?Windows-1252?Q?/dLeTbvykT5rPbFQE9YEKuyFz2B7YTE1tK6jhqzz1/tqorwYJ05NZxyr?=
 =?Windows-1252?Q?Jh2fvHdzOqypSydWw4Duzrmo0fG5smJ8IiqJQ5Fmn9o/7mAqlXFYklng?=
 =?Windows-1252?Q?DwgGvsShhx+F3wabnSHwgguByxkC15VZUxZzY1ZwWpbozfeltw/mAaOK?=
 =?Windows-1252?Q?CPP0u4qa9KCzf+Og0S91cJUGNoRvvgvv6zinl1eHXhePdyPd8XWjmlUh?=
 =?Windows-1252?Q?5/zrO7sPepmeso14JY29VYLGtmiAURSqOqqGFq/feWiJtQVB+fK0qNPv?=
 =?Windows-1252?Q?hcd6c6Y+8efWKwCussre20JHoW+oObMNbtPc0UBcSLJzxpWJn4aW+TXl?=
 =?Windows-1252?Q?SFdTBOjIbT8KP74jgRkfUvXWIiEX+K8M2PjQtMohDQaoi/NNUqiHevpG?=
 =?Windows-1252?Q?W72QwA6AE/7KtGGB9SkYuWAe8ZlGdY2u8yGsXfH8FsR5A/3lsLiKmFIc?=
 =?Windows-1252?Q?VUZY6To/J5WGmy7EfZuE5mj/5Ba71AN2WDNk4vmrWSbE16FGSJ8g43hQ?=
 =?Windows-1252?Q?49+qYFnL7ed7F9TT45ZLHPjyKRc82alDbpw+pH8r7kkB/a1TdxSZzpPH?=
 =?Windows-1252?Q?rj7rGpPFw0m7MKFBvCMGGePi6X5Qxcq55/YP5Z4roAaPO4n7A1cRHSI9?=
 =?Windows-1252?Q?bnh6yo9eco9P5EXa0kvhiW4ANifZkX2KVcszlIEm20QzOSW2MOJDvNcD?=
 =?Windows-1252?Q?8oq+6f3PwTiGuHq/ekHDpkFoL35/jQVok7RYzMwa45a+vF26t3U2GiC7?=
 =?Windows-1252?Q?DkKJdFfaX3CcWzfipSd8X+sCMo1PJUyFWWpNt1zdb2/Uj8zUKvfRiHeh?=
 =?Windows-1252?Q?36tpswAVIjZrtQny3aLS75Ty5QnTdMqb60zhMrFRkQ0o/wHmjng7IbPb?=
 =?Windows-1252?Q?5VD4e7H0A8zEayBk03tEt8J3+Mgq2/zoZ9+q6mZnUUjSEJggmbDtuwLH?=
 =?Windows-1252?Q?rwqJzNKwCwGDwvaqxAboo/AT0W8Nkxo7?=
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-OriginatorOrg: fnal.gov
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: SA1PR09MB7311.namprd09.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 2e94b420-07bc-4835-bf50-08dc753b36c5
X-MS-Exchange-CrossTenant-originalarrivaltime: 16 May 2024 00:00:36.2111
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 9d5f83d3-d338-4fd3-b1c9-b7d94d70255a
X-MS-Exchange-Transport-CrossTenantHeadersStamped: SA1PR09MB9929
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/SA1PR09MB7311C351A55835B6C58903BDB9EC2%40SA1PR09MB7311.namprd09.prod.outlook.com>
Precedence: bulk

Thanks for the quick reply! NP, I was just being extra cautious after upgra=
de.


________________________________________
From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Wednesday, May 15, 2024 6:50 PM
To: Dmitry O Litvintsev
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Seeing new stuff in log after upgrading from 11 to 15

[EXTERNAL] =96 This message is from an external sender

Dmitry O Litvintsev <litvinse@fnal.gov> writes:
> After upgrade 11 -> 15 started to see these messages in hot standby log:

> < 2024-05-15 17:20:24.164 CDT  151879 > LOG:  restartpoint complete: wrot=
e 296338 buffers (28.3%); 0 WAL file(s) added, 134 removed, 0 recycled; wri=
te=3D1619.469 s, sync=3D0.022 s, total=3D1619.539 s; sync files=3D1492, lon=
gest=3D0.002 s, average=3D0.001 s; distance=3D2195446 kB, estimate=3D417134=
7 kB
> < 2024-05-15 17:20:24.164 CDT  151879 > LOG:  recovery restart point at 1=
7AB8/47000140
> < 2024-05-15 17:20:24.164 CDT  151879 > DETAIL:  Last completed transacti=
on was at log time 2024-05-15 17:20:24.138362-05.
> < 2024-05-15 17:20:24.167 CDT  151879 > LOG:  restartpoint starting: wal

> while running 11 the log was almost empty, and I did not modify verbosity=
 settings...
> Queston : are above harmless and just informational?

This is checkpoint logging, which is on by default now (a decision
I didn't particularly approve of).  Feel free to set
"log_checkpoints =3D off" if you don't want it.

                        regards, tom lane