From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Andrew Anderson <forumwriter007(at)gmail(dot)com> |
Cc: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: WAL-files is not removing authomaticaly |
Date: | 2021-03-16 15:44:18 |
Message-ID: | 3253337.1615909458@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Andrew Anderson <forumwriter007(at)gmail(dot)com> writes:
>> - replication slot (you said that is not it)
> The replication slot is the same on master:
> postgres=# select * from pg_replication_slots ;
> slot_name | plugin | slot_type | datoid | database | temporary |
> active | active_pid | xmin | catalog_xmin | restart_lsn |
> confirmed_flush_lsn
> ------------------+--------+-----------+--------+----------+-----------+--------+------------+------+--------------+--------------+---------------------
> stanby_slot | | physical | | | f | t
> | 94341 | | | 145/F6ECC190 |
> (1 row)
> $ grep slot ${PGDATA}/recovery.done
> primary_slot_name = 'stanby_slot'
> and on slave:
> postgres=# select * from pg_replication_slots ;
> slot_name | plugin | slot_type | datoid | database | temporary |
> active | active_pid | xmin | catalog_xmin | restart_lsn |
> confirmed_flush_lsn
> ------------------+--------+-----------+--------+----------+-----------+--------+------------+------+--------------+--------------+---------------------
> stanby_slot | | physical | | | f | f
> | | | | 13E/981E2DD0 |
> (1 row)
> $ grep slot ${PGDATA}/recovery.conf
> primary_slot_name = 'stanby_slot'
Uh ... that slot's restart_lsn seems to correspond to where the
standby is refusing to truncate WAL beyond. So I think your
problem is exactly that this slot isn't advancing. What's
using it?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Fred Habash | 2021-03-16 16:12:00 | Re: Allowing John to Drop Triggers On Chad's Tables |
Previous Message | Laurenz Albe | 2021-03-16 14:56:08 | Re: WAL-files is not removing authomaticaly |