On 3/8/24 14:04, Steve Baldwin wrote:
>
>
> On Sat, Mar 9, 2024 at 8:56 AM Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> wrote:
>
>
> What are the rest of the values in pg_replication_slots?
>
> b2bcreditonline=> select * from pg_replication_slots;
> slot_name | plugin | slot_type |
> datoid | database | temporary | active | active_pid | xmin |
> catalog_xmin | restart_lsn | confirmed_flush_lsn | wal_status |
> safe_wal_size | two_phase
>
---------------------------------------------+----------+-----------+--------+-----------------+-----------+--------+------------+------+--------------+---------------+---------------------+------------+---------------+-----------
> b2bcreditonline_prod_e_master | pgoutput | logical |
> 16404 | b2bcreditonline | f | t | 13700 | |
> 456150233 | 2E2F/AC07B760 | 2E2F/AEEEA478 | reserved |
> | f
> b2bcreditonline_prod_sandbox_d_master | pgoutput | logical |
> 16404 | b2bcreditonline | f | t | 9232 | |
> 456150233 | 2E2F/AC07B760 | 2E2F/AEEEA560 | reserved |
> | f
> b2bcreditonline_prod_e_master_only | pgoutput | logical |
> 16404 | b2bcreditonline | f | t | 13710 | |
> 456150233 | 2E2F/AC07B760 | 2E2F/AEEEA560 | reserved |
> | f
> pg_378075177_sync_60067_7343845372910323059 | pgoutput | logical |
> 16404 | b2bcreditonline | f | f | | |
> 455719618 | 2E2A/1C0972E0 | 2E2A/1C097318 | extended |
> | f
> b2bcreditonline_prod_e_shard | pgoutput | logical |
> 16404 | b2bcreditonline | f | t | 13718 | |
> 456150233 | 2E2F/AC07B760 | 2E2F/AEEEA560 | reserved |
> | f
> (5 rows)
>
For future reference the above would be easier to follow if you did \x
before the select * from pg_replication_slots;
Someone with more experience will need to comment further but to me:
restart_lsn confirmed_flush_lsn
2E2A/1C0972E0 2E2A/1C097318
does not look like enough data was transferred before the slot stopped
transmitting.
--
Adrian Klaver
adrian.klaver@aklaver.com