pg15 and VM snapshots with pg_backup_start

oernii+pg@xxxxxxxxxx · Thu, 30 Mar 2023 11:50:29 +0200



    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