Movatterモバイル変換


[0]ホーム

URL:


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

Sign up
Appearance settings

Multiple Cluster(instance) backup Issue #429

Open
@sms1222

Description

@sms1222

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

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


      [8]ページ先頭

      ©2009-2025 Movatter.jp