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 --stream
INFO: 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: 1
WARNING: 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 streamed
INFO: PGDATA size: 39MB
INFO: Start transferring data files
INFO: Data files are transferred, time elapsed: 0
INFO: wait for pg_stop_backup()
INFO: pg_stop backup() successfully executed
INFO: Syncing backup files to disk
INFO: Backup files are synced, time elapsed: 0
INFO: Validating backup QYSRQR
INFO: Backup QYSRQR data files are valid
INFO: Backup QYSRQR resident size: 71MB
INFO: Backup QYSRQR completed
[postgres@db-pgsql]$
[postgres@db-pgsql]$ pg_probackup-13 backup -B /backup/pgsql/13 --instance laps -b FULL --stream
INFO: 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: 1
WARNING: 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 streamed
INFO: PGDATA size: 39MB
INFO: Start transferring data files
INFO: Data files are transferred, time elapsed: 0
INFO: wait for pg_stop_backup()
INFO: pg_stop backup() successfully executed
INFO: Syncing backup files to disk
INFO: Backup files are synced, time elapsed: 1s
INFO: Validating backup QYSRSG
INFO: Backup QYSRSG data files are valid
INFO: Backup QYSRSG resident size: 71MB
INFO: Backup QYSRSG completed
[postgres@db-pgsql]$
[postgres@db-pgsql]$ ll /data
data1/ 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 000000010000000000000005
drwx------ 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 information
pgdata = /data3/pgsql/13/lapsdata
system-identifier = 6999874746676600137
xlog-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 OK
BACKUP 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]$