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

pg_probackup process killed during PAGE backup #252

Closed
Labels
Milestone
@beremour

Description

@beremour

I have repository:

bash-4.2$ pg_probackup-12 show     -B /backup/pgsqlBACKUP INSTANCE 'main'======================================================================================================================================== Instance  Version  ID      Recovery Time           Mode  WAL Mode  TLI    Time   Data    WAL  Zratio  Start LSN    Stop LSN     Status======================================================================================================================================== main      12       QFW4NN  2020-08-30 22:58:29+03  FULL  STREAM    2/0  1h:32m  496GB   50GB    1.00  89/E8870760  8D/4870FE80  OK main      12       QFUZQN  2020-08-30 07:13:00+03  PAGE  STREAM    2/2     23s  150MB  192MB    1.00  2/B000110    2/1659BB70   OK main      12       QFUZOL  2020-08-30 07:12:27+03  FULL  STREAM    2/0     12s  182MB   16MB    1.00  2/B000110    2/B000250    OK-bash-4.2$

When I try to take PAGE-backup from STANDBY instance, process get killed abnormaly:

-bash-4.2$ pg_probackup-12 backup   -B /backup/pgsql -U backup --instance main -b PAGE --stream --temp-slot --merge-expired --delete-expired --delete-wal -j 16 --progress --log-directory=/vol/pgsql --log-filename=probackup-page-%y%m%d-%H%M%S.log --log-level-file=verboseINFO: Backup start, pg_probackup version: 2.4.2, instance: main, backup ID: QFXDZ8, backup mode: PAGE, wal mode: STREAM, remote: false, compress-algorithm: none, compress-level: 1INFO: Backup QFXDZ8 is going to be taken from standbyINFO: Wait for WAL segment /backup/pgsql/wal/main/000000020000010D0000002E to be archivedINFO: Parent backup: QFW4NNINFO: PGDATA size: 936GBINFO: Extracting pagemap of changed blocksKilled-bash-4.2$

log file is:probackup-page-200831-141620.log

WAL directory in backup repository has large enouph count of files:

[root@pgbase02 ~]# ls -l /backup/pgsql/wal/main | wc -l68389[root@pgbase02 ~]#

Server has 64GB of memory:

[root@pgbase02 ~]# free -m              total        used        free      shared  buff/cache   availableMem:          64429        2884       44867       16137       16676       44632Swap:           763         760           3[root@pgbase02 ~]#

Can you please help with it ?

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions


      [8]ページ先頭

      ©2009-2025 Movatter.jp