Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_replslotdata - a tool for displaying replication slot information - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: pg_replslotdata - a tool for displaying replication slot information
Date
Msg-id f3f6b5f6-df1d-d604-df8a-6ad11ce67f4d@enterprisedb.com
Whole thread Raw
In response to pg_replslotdata - a tool for displaying replication slot information  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
Responses Re: pg_replslotdata - a tool for displaying replication slot information
List pgsql-hackers
Tree view 
On 23.11.21 06:09, Bharath Rupireddy wrote:
> The replication slots data is stored in binary format on the disk under 
> the pg_replslot/<<slot_name>> directory which isn't human readable. If 
> the server is crashed/down (for whatever reasons) and unable to come up, 
> currently there's no way for the user/admin/developer to know what were 
> all the replication slots available at the time of server crash/down to 
> figure out what's the restart lsn, xid, two phase info or types of slots 
> etc.

What do you need that for?  You can't do anything with a replication 
slot while the server is down.

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Skipping logical replication transactions on subscriber side
Next
From: Stephen Frost
Date:
Subject: Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file