From: Dmitry O Litvintsev <litvinse@fnal.gov>
To: "David G. Johnston" <david.g.johnston@gmail.com>
CC: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Confusing error message in 15.6
Thread-Topic: Confusing error message in 15.6
Thread-Index: AQHaq9YQlDzfYejIo02QEYFHwIzly7GiWXKAgAAD7xY=
Date: Tue, 21 May 2024 23:58:42 +0000
Message-ID:
 <SA1PR09MB7311DDDF1550079AD61D9D7FB9EA2@SA1PR09MB7311.namprd09.prod.outlook.com>
References:
 <SA1PR09MB731160449C3C97197555F1F3B9EA2@SA1PR09MB7311.namprd09.prod.outlook.com>
 <CAKFQuwaBvMX671=AUsuukkeU2hv0iSSA9=ixDXzBWM8WLCtRwg@mail.gmail.com>
In-Reply-To:
 <CAKFQuwaBvMX671=AUsuukkeU2hv0iSSA9=ixDXzBWM8WLCtRwg@mail.gmail.com>
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_|PH8PR09MB9530:EE_
x-ms-office365-filtering-correlation-id: c682f3b8-3d80-430f-60ff-08dc79f1f197
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?gbvKBacTyskfFlCZnMDQEgftl5Z10pJoBh+KGRCBSlDmWpsotDXTd+oj?=
 =?Windows-1252?Q?onIjP/PabG3w6Kw4H7+m21HrCa3tIeo+/xJrCWn/fXzQzx6kq0W2zUeG?=
 =?Windows-1252?Q?dcKkoyd8GE0aQSz04zYDB+WKIH4SzKMY79WUEPo4D8hMa246R8MYVdAc?=
 =?Windows-1252?Q?1AXaE3iZopoE2MpcKBUQeP9B1uyZO7ojD0cLjRbdgiLGM5hTBJyCogXP?=
 =?Windows-1252?Q?VGL6h9uzvvuTtcEMrqz7jt0Ogj5xyMgbT4cEIAnK0wFDIIJlq80LKgta?=
 =?Windows-1252?Q?3J3ZmmOYMdHCLaLuFdi98JSchpdbkobsaYVPCOOkPSE60yNMfeHdE6aU?=
 =?Windows-1252?Q?AOw8FVCVU8/gsWtby2D92xyJ91+p0wTLMBryJjxaEhwXGyDtEKm+H3Pl?=
 =?Windows-1252?Q?EUT/6P6OOdGMFYlpzw6u9j4PKKxbSS/wfnjJDOAHBN6H6UmeSRl2k5Tk?=
 =?Windows-1252?Q?OVVJC1VPYl4HD+1zI358zEDtFpTaMU8nYrexzNjeccUG5vwZpfJ+9qMY?=
 =?Windows-1252?Q?yLGDbyrcDC841wwFX1wMehcXbB+ufGqfCFbGkBsSwXuSrdTqEXbO4KVz?=
 =?Windows-1252?Q?fSH5qNwNbwAbhS7I0t7ntgo9UMM4v6+wR7Qvtl5KESoc6MMRBkpzIaqY?=
 =?Windows-1252?Q?98InIcl3YvrRIV4yLbscFU3rx1NsCaatD4Zi5rB+SX2NXBEzHerUmhqL?=
 =?Windows-1252?Q?FON85gD3y5pylqlPhfEBUHiGsJjlmeoYt+5wjvtw/KF1BX9gHS3IIrSR?=
 =?Windows-1252?Q?0kfCLmneNcnigsPMv+KshxRbKihIUyeWns5yWMexzaXBFTggS517zs0e?=
 =?Windows-1252?Q?gNML4BvCPRjsCGqFIvwhLFVH/ZjSPjOv6PIVN5ZTxlDoHUQ+wnw444Cu?=
 =?Windows-1252?Q?YPLBuIs5l/V0SeYmaHQj1ox4gLvCd4nQeCg/ur5k8bc3uHsny6Rr4hM4?=
 =?Windows-1252?Q?Z+BByORWnOswfmZr0WWB1kbFfeDLy0JVB5ekE5XUdGxpX/UCbjP6c+jy?=
 =?Windows-1252?Q?CkCXx7CvjqIx2pO7fX1UCSBM5h4nAHNL7MDDGzW5j2FQvcSH1dmxbRvt?=
 =?Windows-1252?Q?FOX7i1ppAIlRnwQkrwfPDpO2/riqrR5Cb8n3zUaXlD1QmLeXkbgVrL8u?=
 =?Windows-1252?Q?w14OPUWgx54oKQ+X8/0VBoeWfYVyUjZHCJvvEnYEqIFGmdkIA5NRvUaT?=
 =?Windows-1252?Q?sHI6/ZCd8RU6SXD+ho+EiNF2lwS6ko5aSoohtQHNY0MSZxghvipjh6JC?=
 =?Windows-1252?Q?rjTkdGZjZZJF928YmfmfqcuQhX41o0xIf/oh9QKBGg5ywXWq2zC+BiHc?=
 =?Windows-1252?Q?szkR+RMVyLsRVh0Z2ZU/Tf/hVnTlZiVQiQTKO10f4iNQmEkX4lhvGiSh?=
 =?Windows-1252?Q?5U/5+mSxVbQKy24P9/jrWc7YUi359mYn2Ma3LRj6Ow635ilbL8Lo2pR8?=
 =?Windows-1252?Q?cGu7awS2YSHtHIFJ0MSZLw=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?XrerfIOIL0xjNiHZA4ldtwtFWTMEHr+osZEFPtXEI+ixnTQMb0aIT7cg?=
 =?Windows-1252?Q?LDN3L/bJ5Gj06EAc+9LHEp8LdF4PT5G4v23N81cUE6ZXG+167lpUe7EZ?=
 =?Windows-1252?Q?xHB2FrfX4Xog8rhRZNiE0M+Hywb2jxq/D789mPC3rnh2BMSYEqbvh03/?=
 =?Windows-1252?Q?XCJ+f0hc1uoDWfVEh1l/o7WFmIah9pChL7ARyqkRWF2AhEi6O6GPQy7H?=
 =?Windows-1252?Q?ZRFs39SsoHKxWjTzlfVsVAkuDF/jRHtg1uZZTXrWZMcoF0cSQD4qoJ3O?=
 =?Windows-1252?Q?JPmzNsbAAf0cq3yb/loBVIYKKW7kwItBWVcGsjwtmyomlpDcHIpHYskE?=
 =?Windows-1252?Q?S5sQgew7k5e9cFJ3xvVkcYG3HHN73Voym20WQZSciLoF7hjaUDf5XzCK?=
 =?Windows-1252?Q?/prmN7Lcjg6ShS2nrmpUcKDq8kX3mphIOEu3MwF7Zm6BacUI6k+mcoVa?=
 =?Windows-1252?Q?LvwaivXQYEtfUpbAPIQ/+gwkYSS95hZzlHy/L4s+bDQle5vsQNyUDMHD?=
 =?Windows-1252?Q?l7UaQEI8Ymn6ATaHsbp44vi6K+khZnvDGyzxcMIgIUX8xLcIOMbY8Yzz?=
 =?Windows-1252?Q?P1GyEl9QkMt0/qgE57Xt6Whk4sPsv0bqfo3sI3vaozbUoKCl7mxlQu/m?=
 =?Windows-1252?Q?W2XuO5FDSKmXx9W1Y3TT8+PktcL0ivrWc6DP8u3tKvAnCif4hsqdUYke?=
 =?Windows-1252?Q?3tTMm2uvfweLRsXCL4pVAXqBM+Y5YphpMvrV8C31p61UX3Cjh3s2y727?=
 =?Windows-1252?Q?atStuiU1ZXRiMd7Isu0o9XbLjje2hrax5M80+kA5nRA1de49hd20qy/l?=
 =?Windows-1252?Q?wcooAQXBu7j+fSMNXPz/cqaoQkGSkXg0WbcrcpaozZiK8ZczB5NM9m8g?=
 =?Windows-1252?Q?Jw3DiX2qlRZn63G3W3uBWIPBmbOgGXkgC4TswZILLC0HMHR3FHqWNFPM?=
 =?Windows-1252?Q?krtS1HmPrOorYcH9qKvPTAii8COap46HBEljQWn4mK9/yDi3NlgVvlIW?=
 =?Windows-1252?Q?L8TW2+GImDQf8c0Ik9z1oRsuWr+FYZKMoW/f50JVUukTEBhakTc64udB?=
 =?Windows-1252?Q?mGmaSQHVwWunHAbnqbyNI32NcPxXro9ilkZRqeGOXHa25eL2DWfc+TUC?=
 =?Windows-1252?Q?g+9JLTbrlNVKj0TesYnnjzm5RCSkjBnPgA35mBkmM2oxtbGMyDLRWHd7?=
 =?Windows-1252?Q?fT/4FHMYHrxazGMO7cXYqOh+ax2I/kyIrZ/1NS8+RQ8nPLhw0hiHZNR+?=
 =?Windows-1252?Q?pc93eyWy9VDe4SYkL6ZiejrAGUtYECYA96LSy3Uglt3PZspSpyRz9rbw?=
 =?Windows-1252?Q?hf70bmr+BapsppsmUNY4fK/bxoLYcUjJMUY4888egHHtCtsiYqEz+BHI?=
 =?Windows-1252?Q?wm5oGX/dtXK+MDwn8q4T0OT7Spk9/fZbvpCBpDZPiNFby0BfLUGv6aG+?=
 =?Windows-1252?Q?tf6dbRTR+VkNmIT7/x9WOHfX5Epoi85Imwu3dR9yOIwFx8Zifwq3Kj71?=
 =?Windows-1252?Q?82uam6OB8hn6BxwA2nE8kn7jRZdD4jMjkUand7/PAIvOUrkKykmmtLTp?=
 =?Windows-1252?Q?lrrqHM9SEa7zzM7nvVlRaRok97QR7fGpSqgYGeU/5jS4RPhgS8UsCTgB?=
 =?Windows-1252?Q?gj1CCc9kl2aEgwiGVO7y1JpU8HfpkzYI1Q5S/3HPccGZ09gP7ZaXKq34?=
 =?Windows-1252?Q?MgeE0/zIC8+UBe6FZsB5Pno8D8xii8dt?=
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: c682f3b8-3d80-430f-60ff-08dc79f1f197
X-MS-Exchange-CrossTenant-originalarrivaltime: 21 May 2024 23:58:42.7023
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 9d5f83d3-d338-4fd3-b1c9-b7d94d70255a
X-MS-Exchange-Transport-CrossTenantHeadersStamped: PH8PR09MB9530
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/SA1PR09MB7311DDDF1550079AD61D9D7FB9EA2%40SA1PR09MB7311.namprd09.prod.outlook.com>
Precedence: bulk

Oops. This means major rewrite of my backup procedure.  Thanks for pointing=
 this out. I will likely just switch to pg_basebackup. What I have is somet=
hing old and gnarly from the days of psql version 8.

________________________________________
From: David G. Johnston <david.g.johnston@gmail.com>
Sent: Tuesday, May 21, 2024 6:42 PM
To: Dmitry O Litvintsev
Cc: pgsql-generallists.postgresql.org
Subject: Re: Confusing error message in 15.6

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


On Tue, May 21, 2024, 17:29 Dmitry O Litvintsev <litvinse@fnal.gov<mailto:l=
itvinse@fnal.gov>> wrote:
Hi,

I am observing the following error which confuses me:

#  psql -U postgres template1 -c "checkpoint; select pg_backup_start('${des=
t}.tar.Z', true)"
CHECKPOINT
 pg_backup_start
-----------------
 17BF7/3009498
(1 row)

#  psql -U postgres template1 -c "select pg_backup_stop(true)"
ERROR:  backup is not in progress
HINT:  Did you call pg_backup_start()?

This is postgresql 15.6 running on RH 7.

This is not just amusing, it is breaking my backup script after update from=
 11 to 15 (and change from pg_{start,stop}_backup to pg_backup_{start_stop}=
)


Yep, nowadays you must keep the transaction where you issued backup start o=
pen until you issue backup end.  Using -c isn't going to cut it.

David J.