From: | Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: pg_replslotdata - a tool for displaying replication slot information |
Date: | 2021-11-24 15:59:51 |
Message-ID: | CALj2ACX8yeYdn8KFzmRqeSgxYPq=xG9jW6EGQgLCJoFy_wBF5Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, Nov 24, 2021 at 9:09 PM Bharath Rupireddy
<bharath(dot)rupireddyforpostgres(at)gmail(dot)com> wrote:
>
> On Tue, Nov 23, 2021 at 10:39 AM Bharath Rupireddy
> <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> wrote:
> >
> > Hi,
> >
> > 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.
> >
> > pg_replslotdata is a tool that interprets the replication slots information and displays it onto the stdout even if the server is crashed/down. The design of this tool is similar to other tools available in the core today i.e. pg_controldata, pg_waldump.
> >
> > Attaching initial patch herewith. I will improve it with documentation and other stuff a bit later.
> >
> > Please see the attached picture for the sample output.
> >
> > Thoughts?
>
> Attaching the rebased v2 patch.
On windows the previous patches were failing, fixed that in the v3
patch. I'm really sorry for the noise.
Regards,
Bharath Rupireddy.
Attachment | Content-Type | Size |
---|---|---|
v3-0001-pg_replslotdata.patch | application/octet-stream | 21.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Japin Li | 2021-11-24 16:10:51 | Re: pg_replslotdata - a tool for displaying replication slot information |
Previous Message | Robert Haas | 2021-11-24 15:50:13 | Re: Rename dead_tuples to dead_items in vacuumlazy.c |