Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

WITH hot_backup AS (
    SELECT 'pg_basebackup: initiating base backup, waiting for checkpoint to complete' || e'\n' ||
           'pg_basebackup: checkpoint completed' || e'\n' ||
           'pg_basebackup: write-ahead log start point: 4294/761C8F0 on timeline 1' || e'\n' ||
           'pg_basebackup: starting background WAL receiver' || e'\n' ||
           'pg_basebackup: created temporary replication slot "pg_basebackup_78757"' || e'\n' ||
           '0/92649519 kB (0%), 0/1 tablespace (...p/5432/2022-05-20_08_08/base.tar)' || e'\n' ||
           '46451/92649519 kB (0%), 0/1 tablespace (...p/5432/2022-05-0_08_08/base.tar)' || e'\n' ||
           '359630/92649519 kB (0%), 0/1 tablespace (...p/5432/2022-050_08_08/base.tar)' || e'\n' ||
           '721390/92649519 kB (0%), 0/1 tablespace (...p/5432/2022-05-_08_08/base.tar)' || e'\n' ||
           '<<<TRUNCATED>>>>' || e'\n' ||
           '91974979/92649519 kB (99%), 0/1 tablespace (...p/5432/2022-05-20_08_08/base.tar)' || e'\n' ||
           '92136675/92649519 kB (99%), 0/1 tablespace (...p/5432/2022-05-20_08_08/base.tar)' || e'\n' ||
           '92393347/92649519 kB (99%), 0/1 tablespace (...p/5432/2022-05-20_08_08/base.tar)' || e'\n' ||
           '92701040/92701040 kB (100%), 0/1 tablespace (...p/5432/2022-05-20_08_08/base.tar)' || e'\n' ||
           '92702617/92702617 kB (100%), 0/1 tablespace (...p/5432/2022-05-20_08_08/base.tar)' || e'\n' ||
           '92702617/92702617 kB (100%), 1/1 tablespace' || e'\n' ||
           'pg_basebackup: write-ahead log end point: 4294/F0CAB50' || e'\n' ||
           'pg_basebackup: waiting for background process to finish streaming ...' || e'\n' ||
           'pg_basebackup: syncing data to disk ...' || e'\n' ||
           'pg_basebackup: renaming backup_manifest.tmp to backup_manifest' || e'\n' ||
           'pg_basebackup: base backup completed' AS log
)

SELECT REGEXP_REPLACE(log, e'^(.*?\n.*?\n.*?\n.*?\n.*?)\n.*(.*?\n.*?\n.*?\n.*?\n.*?\n.*?)$', '\1\2')
FROM hot_backup;

regexp_replace
pg_basebackup: initiating base backup, waiting for checkpoint to complete pg_basebackup: checkpoint completed pg_basebackup: write-ahead log start point: 4294/761C8F0 on timeline 1 pg_basebackup: starting background WAL receiver pg_basebackup: created temporary replication slot "pg_basebackup_78757" pg_basebackup: write-ahead log end point: 4294/F0CAB50 pg_basebackup: waiting for background process to finish streaming ... pg_basebackup: syncing data to disk ... pg_basebackup: renaming backup_manifest.tmp to backup_manifest pg_basebackup: base backup completed

regexp_replace

pg_basebackup: initiating base backup, waiting for checkpoint to complete
pg_basebackup: checkpoint completed
pg_basebackup: write-ahead log start point: 4294/761C8F0 on timeline 1
pg_basebackup: starting background WAL receiver
pg_basebackup: created temporary replication slot "pg_basebackup_78757"
pg_basebackup: write-ahead log end point: 4294/F0CAB50
pg_basebackup: waiting for background process to finish streaming ...
pg_basebackup: syncing data to disk ...
pg_basebackup: renaming backup_manifest.tmp to backup_manifest
pg_basebackup: base backup completed