From: | pgdba pgdba <postgresdba12(at)outlook(dot)com> |
---|---|
To: | Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> |
Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Ynt: Postgres Wal Full |
Date: | 2022-03-03 08:47:20 |
Message-ID: | DB8P189MB1014A89436967D2E4BC4D88FA3049@DB8P189MB1014.EURP189.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi, thanks your feedback but not have same error in my log file. I am using streaming replication and have 1 master and 2 slave nodes in async. master node different size file wal from slave nodes such as;
[root(at)master1 pg_wal]# ls | wc -l
6400
[root(at)slave2 pg_wal]# ls | wc -l
332
[root(at)slave3 pg_wal]# ls | wc -l
344
wal_keep_segments = 512
max_wal_size = 2GB
min_wal_size = 1GB
data size : 290G
cpu:8
ram:16
________________________________
Gönderen: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
Gönderildi: 3 Mart 2022 Perşembe 11:22
Kime: postgresdba12(at)outlook(dot)com <postgresdba12(at)outlook(dot)com>
Bilgi: pgsql-general(at)lists(dot)postgresql(dot)org <pgsql-general(at)lists(dot)postgresql(dot)org>
Konu: Re: Postgres Wal Full
At Thu, 3 Mar 2022 07:46:45 +0000, pgdba pgdba <postgresdba12(at)outlook(dot)com> wrote in
> I have a problem from pg_wal. I am using postgresql version 11 and taking backup and writing archive_command in postgresql.conf but did not archive wal and my disk ise full from pg_wal. I research why is my wal is full and dont found anything could you help me please ?
The immediate cause of the WAL retension is the archive failure.
PostgreSQL, while archiving is enabled, won't remove a WAL file until
it is successfully archived.
You will see the lines like the following in sergver log if archive
failure happened.
> 2022-03-03 17:15:21.314 JST LOG: archive command failed with exit code 1
If the archive command emitted some error messages, it can be caught
in the server log together. The follwoing error is emitted by the
archive_command "cp %p /archive/%f".
> cp: cannot create regular file '/archive/000000010000000000000001': No such file or directory
regards.
--
Kyotaro Horiguchi
NTT Open Source Software Center
From | Date | Subject | |
---|---|---|---|
Next Message | Bharath Rupireddy | 2022-03-03 09:50:25 | Re: Postgres Wal Full |
Previous Message | Kyotaro Horiguchi | 2022-03-03 08:22:15 | Re: Postgres Wal Full |