Re: pg_replslotdata - a tool for displaying replication slot information

2023-04-13 Thread Gurjeet
On Mon Jan 17, 2022 at 5:11 AM PST, Julien Rouhaud wrote: > On Mon, Jan 17, 2022 at 04:10:13PM +0530, Bharath Rupireddy wrote: > > > > Thanks Juilen. I'm okay if the patch gets dropped. > > Ok, I will take care of that soon. I find this utility interesting and useful, especially for the reason

Re: pg_replslotdata - a tool for displaying replication slot information

2022-01-17 Thread Julien Rouhaud
Hi, On Mon, Jan 17, 2022 at 04:10:13PM +0530, Bharath Rupireddy wrote: > > Thanks Juilen. I'm okay if the patch gets dropped. Ok, I will take care of that soon. > But, I'm curious to > know why the above error occurred. Is it because I included the nls.mk > file in the patch which I'm not

Re: pg_replslotdata - a tool for displaying replication slot information

2022-01-17 Thread Bharath Rupireddy
On Sat, Jan 15, 2022 at 2:20 PM Julien Rouhaud wrote: > > Bharath, perhaps you should maintain this outside of core PostgreSQL > > for now. If some compelling use-cases ever surface that make it seem > > worth the added maintenance burden, this thread could probably be > > revisited. > >

Re: pg_replslotdata - a tool for displaying replication slot information

2022-01-15 Thread Julien Rouhaud
Hi, On Mon, Dec 06, 2021 at 07:16:12PM +, Bossart, Nathan wrote: > On 12/5/21, 11:10 PM, "Michael Paquier" wrote: > > On Thu, Dec 02, 2021 at 08:32:08AM +0530, Bharath Rupireddy wrote: > >> On Thu, Dec 2, 2021 at 4:22 AM Andres Freund wrote: > I don't have any other compelling use-

Re: pg_replslotdata - a tool for displaying replication slot information

2021-12-06 Thread Bossart, Nathan
On 12/5/21, 11:10 PM, "Michael Paquier" wrote: > On Thu, Dec 02, 2021 at 08:32:08AM +0530, Bharath Rupireddy wrote: >> On Thu, Dec 2, 2021 at 4:22 AM Andres Freund wrote: I don't have any other compelling use- cases at the moment, but I will say that it is typically nice from an

Re: pg_replslotdata - a tool for displaying replication slot information

2021-12-05 Thread Michael Paquier
On Thu, Dec 02, 2021 at 08:32:08AM +0530, Bharath Rupireddy wrote: > On Thu, Dec 2, 2021 at 4:22 AM Andres Freund wrote: >>> I don't have any other compelling use- cases at the moment, but I will say >>> that it is typically nice from an administrative standpoint to be able to >>> inspect things

Re: pg_replslotdata - a tool for displaying replication slot information

2021-12-01 Thread Bharath Rupireddy
On Thu, Dec 2, 2021 at 4:22 AM Andres Freund wrote: > > Hi, > > On 2021-11-30 18:43:23 +, Bossart, Nathan wrote: > > On 11/30/21, 6:14 AM, "Peter Eisentraut" > > wrote: > > > On 23.11.21 06:09, Bharath Rupireddy wrote: > > >> The replication slots data is stored in binary format on the disk

Re: pg_replslotdata - a tool for displaying replication slot information

2021-12-01 Thread Andres Freund
Hi, On 2021-11-30 18:43:23 +, Bossart, Nathan wrote: > On 11/30/21, 6:14 AM, "Peter Eisentraut" > wrote: > > 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/<> directory which isn't human readable.

Re: pg_replslotdata - a tool for displaying replication slot information

2021-11-30 Thread SATYANARAYANA NARLAPURAM
On Tue, Nov 30, 2021 at 9:47 PM Bharath Rupireddy < bharath.rupireddyforpostg...@gmail.com> wrote: > On Wed, Dec 1, 2021 at 12:13 AM Bossart, Nathan > wrote: > > > > On 11/30/21, 6:14 AM, "Peter Eisentraut" < > peter.eisentr...@enterprisedb.com> wrote: > > > On 23.11.21 06:09, Bharath Rupireddy

Re: pg_replslotdata - a tool for displaying replication slot information

2021-11-30 Thread Bharath Rupireddy
On Wed, Dec 1, 2021 at 12:13 AM Bossart, Nathan wrote: > > On 11/30/21, 6:14 AM, "Peter Eisentraut" > wrote: > > 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/<> directory which isn't human readable.

Re: pg_replslotdata - a tool for displaying replication slot information

2021-11-30 Thread Bossart, Nathan
On 11/30/21, 6:14 AM, "Peter Eisentraut" wrote: > 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/<> directory which isn't human readable. If >> the server is crashed/down (for whatever reasons) and unable

Re: pg_replslotdata - a tool for displaying replication slot information

2021-11-30 Thread Peter Eisentraut
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/<> 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

Re: pg_replslotdata - a tool for displaying replication slot information

2021-11-24 Thread Bharath Rupireddy
On Wed, Nov 24, 2021 at 9:40 PM Japin Li wrote: > > > On Wed, 24 Nov 2021 at 23:59, Bharath Rupireddy > wrote: > > On Wed, Nov 24, 2021 at 9:09 PM Bharath Rupireddy > >> > Thoughts? > >> > >> Attaching the rebased v2 patch. > > > > On windows the previous patches were failing, fixed that in the

Re: pg_replslotdata - a tool for displaying replication slot information

2021-11-24 Thread Japin Li
On Wed, 24 Nov 2021 at 23:59, Bharath Rupireddy wrote: > On Wed, Nov 24, 2021 at 9:09 PM Bharath Rupireddy >> > 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. > Cool! When I try

Re: pg_replslotdata - a tool for displaying replication slot information

2021-11-24 Thread Bharath Rupireddy
On Wed, Nov 24, 2021 at 9:09 PM Bharath Rupireddy wrote: > > On Tue, Nov 23, 2021 at 10:39 AM Bharath Rupireddy > wrote: > > > > Hi, > > > > The replication slots data is stored in binary format on the disk under the > > pg_replslot/<> directory which isn't human readable. If the > > server is

Re: pg_replslotdata - a tool for displaying replication slot information

2021-11-24 Thread Bharath Rupireddy
On Tue, Nov 23, 2021 at 10:39 AM Bharath Rupireddy wrote: > > Hi, > > The replication slots data is stored in binary format on the disk under the > pg_replslot/<> directory which isn't human readable. If the server > is crashed/down (for whatever reasons) and unable to come up, currently >

pg_replslotdata - a tool for displaying replication slot information

2021-11-22 Thread Bharath Rupireddy
Hi, The replication slots data is stored in binary format on the disk under the pg_replslot/<> 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