Re: BUG #16317: max_wal_size does not remove WAL files, cause "no space left"

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Fan Liu <fan(dot)liu(at)ericsson(dot)com>
Cc: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #16317: max_wal_size does not remove WAL files, cause "no space left"
Date: 2020-03-25 15:04:30
Message-ID: 20200325150430.GA21159@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, Mar 25, 2020 at 12:26:22PM +0000, Fan Liu wrote:
> >>postgres=# ps uwwxf | grep -C3 archive
> >>postgres-# \q
> >>ss7-db-pg-1:/ # ps uwwxf | grep -C3 archive

I asked for this ps/grep from shell of postgres. not from psql as
postgres, and not from root shell.

But it's not really important.

can you show me:

select pg_walfile_name( pg_current_wal_lsn());

and then, as postgres:
cd /var/lib/postgresql/data/pgdata/wal (or wherever wal is), and do:
ls -l

and show us the output (possiblky using some paste site).

Best regards,

depesz

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tomas Vondra 2020-03-25 19:21:27 Re: BUG #16314: Database Cache Hit Ratio (Warning)
Previous Message Fan Liu 2020-03-25 12:26:22 RE: BUG #16317: max_wal_size does not remove WAL files, cause "no space left"