Re: BUG #16317: max_wal_size does not remove WAL files, cause "nospace left" - Mailing list pgsql-bugs

From hubert depesz lubaczewski
Subject Re: BUG #16317: max_wal_size does not remove WAL files, cause "nospace left"
Date
Msg-id 20200325150430.GA21159@depesz.com
Whole thread Raw
In response to RE: BUG #16317: max_wal_size does not remove WAL files, cause "nospace left"  (Fan Liu <fan.liu@ericsson.com>)
Responses RE: BUG #16317: max_wal_size does not remove WAL files, cause "nospace left"  (Fan Liu <fan.liu@ericsson.com>)
List 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




pgsql-bugs by date:

Previous
From: Fan Liu
Date:
Subject: RE: BUG #16317: max_wal_size does not remove WAL files, cause "nospace left"
Next
From: Tomas Vondra
Date:
Subject: Re: BUG #16314: Database Cache Hit Ratio (Warning)