pg15 and VM snapshots with pg_backup_start

From: oernii+pg(at)axonpro(dot)sk
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: pg15 and VM snapshots with pg_backup_start
Date: 2023-03-30 09:50:29
Message-ID: 1bd4e56c-f6ad-f711-255a-4432b5f20a62@axonpro.sk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi, we run a lot of PG14 and lower. We do VM snapshots, which we backup.
Before the snapshot we run a quiesce script which also runs
pg_start_backup(). After a few seconds the snapshot if finished and we
call pg_stop_backup.

This is working file for us, but pg15 removed this function and replaced
it with pg_backup_start(), which however requires the session to be
open, otherwise we get:

    WARNING:  aborting backup due to backend exiting before
pg_backup_stop was called

For pg15 do I need to keep the session open, will the snapshot contain
uncorruped data?

thank you.

--
OE

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2023-03-30 10:45:39 Re: pg15 and VM snapshots with pg_backup_start
Previous Message Ron 2023-03-29 14:28:29 Re: Host name in .pgpass