From: | Matthias Apitz <guru(at)unixarea(dot)de> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | pg_basebackup && long time storage of wal_archive/ content |
Date: | 2020-04-14 15:00:22 |
Message-ID: | 20200414150022.GA4613@sh4-5.1blu.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
The run (as user 'postgres') on the server of the cmd:
pg_basebackup -U ${DBSUSER} -Ft -z -D /data/postgresql11/backup-wal_archive-20200414-1/
produces correctly the following situtation on the server:
srap32dxr1:/data/postgresql11 # ls -ltrh backup-20200414-1
total 1.7G
-rw------- 1 postgres postgres 1.7G Apr 14 16:20 base.tar.gz
-rw------- 1 postgres postgres 17K Apr 14 16:20 pg_wal.tar.gz
srap32dxr1:/data/postgresql11 # ls -ltrh data/pg_wal
total 81M
-rw------- 1 postgres postgres 16M Apr 14 15:11 000000010000000C0000009F
-rw------- 1 postgres postgres 16M Apr 14 15:20 000000010000000C000000A0
-rw------- 1 postgres postgres 16M Apr 14 16:10 000000010000000C000000A1
-rw------- 1 postgres postgres 16M Apr 14 16:20 000000010000000C000000A2
-rw------- 1 postgres postgres 342 Apr 14 16:20 000000010000000C0000009D.00000028.backup
drwx------ 2 postgres postgres 36K Apr 14 16:25 archive_status
-rw------- 1 postgres postgres 16M Apr 14 16:50 000000010000000C0000009E
srap32dxr1:/data/postgresql11 # ls -ltrh wal_archive/
total 49M
-rw------- 1 postgres postgres 16M Apr 14 15:20 000000010000000C0000009B
-rw------- 1 postgres postgres 16M Apr 14 16:10 000000010000000C0000009C
-rw------- 1 postgres postgres 16M Apr 14 16:20 000000010000000C0000009D
-rw------- 1 postgres postgres 342 Apr 14 16:20 000000010000000C0000009D.00000028.backup
The content of the dir wal_archive/ is growing and growing over the
time.
The pg_wat.tar.gz contains:
srap32dxr1:/data/postgresql11 # tar tzf backup-20200414-1/pg_wal.tar.gz
000000010000000C0000009D
i..e. the files 000000010000000C0000009B ... 000000010000000C0000009D
could be removed in wal_archive/
Correct? Or how is the long time storage of this dir?
matthias
--
Matthias Apitz, ✉ guru(at)unixarea(dot)de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2020-04-14 15:28:35 | Re: pg_basebackup && long time storage of wal_archive/ content |
Previous Message | Ц | 2020-04-14 14:32:56 | Re[2]: Invalid name syntax on to_regrole(session_user) |