Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Multiple Cluster(instance) backup Issue #429

Copy link
Copy link
Open
@sms1222

Description

@sms1222
Issue body actions

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]$

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      Morty Proxy This is a proxified and sanitized view of the page, visit original site.