- Notifications
You must be signed in to change notification settings - Fork86
Open
Description
Hi, there.
I met a weird situation.
I have two instance (e.g., a, b).
; instance 'a' is fine.
$ pg_probackup-13 backup -B {backup-dir} --instance a -b FULL --stream
; instance 'b' is weird. Wal files in Backup of 'pg_wal' are NOT b' BUT a's.
$ pg_probackup-13 backup -B {backup-dir} --instance b -b FULL --stream
Backups
[postgres@db-pgsql]$ pg_probackup-13 backup -B /backup/pgsql/13 --instance vns -b FULL --streamINFO: Backup start, pg_probackup version: 2.4.15, instance: vns, backup ID: QYSRQR, backup mode: FULL, wal mode: STREAM, remote: false, compress-algorithm: none, compress-level: 1WARNING: This PostgreSQL instance was initialized without data block checksums. pg_probackup have no way to detect data block corruption without them. Reinitialize PGDATA with option '--data-checksums'.WARNING: Current PostgreSQL role is superuser. It is not recommended to run backup or checkdb as superuser.INFO: wait for pg_start_backup()INFO: Wait for WAL segment /backup/pgsql/13/backups/vns/QYSRQR/database/pg_wal/00000001000000000000001E to be streamedINFO: PGDATA size: 39MBINFO: Start transferring data filesINFO: Data files are transferred, time elapsed: 0INFO: wait for pg_stop_backup()INFO: pg_stop backup() successfully executedINFO: Syncing backup files to diskINFO: Backup files are synced, time elapsed: 0INFO: Validating backup QYSRQRINFO: Backup QYSRQR data files are validINFO: Backup QYSRQR resident size: 71MBINFO: Backup QYSRQR completed[postgres@db-pgsql]$[postgres@db-pgsql]$ pg_probackup-13 backup -B /backup/pgsql/13 --instance laps -b FULL --streamINFO: Backup start, pg_probackup version: 2.4.15, instance: laps, backup ID: QYSRSG, backup mode: FULL, wal mode: STREAM, remote: false, compress-algorithm: none, compress-level: 1WARNING: This PostgreSQL instance was initialized without data block checksums. pg_probackup have no way to detect data block corruption without them. Reinitialize PGDATA with option '--data-checksums'.WARNING: Current PostgreSQL role is superuser. It is not recommended to run backup or checkdb as superuser.INFO: wait for pg_start_backup()INFO: Wait for WAL segment /backup/pgsql/13/backups/laps/QYSRSG/database/pg_wal/000000010000000000000020 to be streamedINFO: PGDATA size: 39MBINFO: Start transferring data filesINFO: Data files are transferred, time elapsed: 0INFO: wait for pg_stop_backup()INFO: pg_stop backup() successfully executedINFO: Syncing backup files to diskINFO: Backup files are synced, time elapsed: 1sINFO: Validating backup QYSRSGINFO: Backup QYSRSG data files are validINFO: Backup QYSRSG resident size: 71MBINFO: Backup QYSRSG completed[postgres@db-pgsql]$[postgres@db-pgsql]$ ll /datadata1/ data2/ data3/[postgres@db-pgsql]$ ll /data3/pgsql/13/lapsdata/pg_wal/합계 32768-rw------- 1 postgres postgres 16777216 9월 2 15:22 000000010000000000000004-rwx------ 1 postgres postgres 16777216 9월 2 15:22 000000010000000000000005drwx------ 2 postgres postgres 6 9월 2 15:22 archive_status[postgres@db-pgsql]$[postgres@db-pgsql]$ cat /backup/pgsql/13/backups/laps/pg_probackup.conf# Backup instance informationpgdata = /data3/pgsql/13/lapsdatasystem-identifier = 6999874746676600137xlog-seg-size = 16777216[postgres@db-pgsql]$
Show Information
[postgres@db-pgsql]$ pg_probackup-13 show -B /backup/pgsql/13/BACKUP INSTANCE 'vns'================================================================================================================================== Instance Version ID Recovery Time Mode WAL Mode TLI Time Data WAL Zratio Start LSN Stop LSN Status================================================================================================================================== vns 13 QYSRQR 2021-09-02 17:04:04+09 FULL STREAM 1/0 5s 23MB 48MB 1.00 0/1E000028 0/1E000168 OKBACKUP INSTANCE 'laps'================================================================================================================================== Instance Version ID Recovery Time Mode WAL Mode TLI Time Data WAL Zratio Start LSN Stop LSN Status================================================================================================================================== laps 13 QYSRSG 2021-09-02 17:05:05+09 FULL STREAM 1/0 6s 23MB 48MB 1.00 0/20000028 0/20000168 OK[postgres@db-pgsql]$
Wal lsn information
vns : 5432
laps : 5433
[postgres@db-pgsql]$ psql --port=5432 --command='select pg_current_wal_lsn()' pg_current_wal_lsn-------------------- 0/21000148(1개 행)[postgres@db-pgsql]$ psql --port=5433 --command='select pg_current_wal_lsn()' pg_current_wal_lsn-------------------- 0/4000148(1개 행)[postgres@db-pgsql]$