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

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: BUG #16317: max_wal_size does not remove WAL files, cause "nospace left"
Дата
Msg-id 20200325150430.GA21159@depesz.com
обсуждение исходный текст
Ответ на RE: BUG #16317: max_wal_size does not remove WAL files, cause "nospace left"  (Fan Liu <fan.liu@ericsson.com>)
Ответы RE: BUG #16317: max_wal_size does not remove WAL files, cause "nospace left"  (Fan Liu <fan.liu@ericsson.com>)
Список 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 по дате отправления:

Предыдущее
От: Fan Liu
Дата:
Сообщение: RE: BUG #16317: max_wal_size does not remove WAL files, cause "nospace left"
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: BUG #16314: Database Cache Hit Ratio (Warning)