On Thu, Nov 10, 2022 at 4:12 PM sirisha chamarthi
wrote:
>
> On Wed, Nov 9, 2022 at 12:32 AM Kyotaro Horiguchi
> wrote:
>>
>> I don't think walsenders fetching segment from archive is totally
>> stupid. With that feature, we can use fast and expensive but small
>> storage for pg_wal, while avoid
On Thu, Nov 10, 2022 at 4:07 PM sirisha chamarthi
wrote:
>
> On Wed, Nov 9, 2022 at 2:37 AM Amit Kapila wrote:
>>
>> On Fri, Nov 4, 2022 at 1:40 PM sirisha chamarthi
>> wrote:
>> >
>> Is the intent of setting restart_lsn to InvalidXLogRecPtr was to
>> disallow reviving the slot?
>> >
>>
>> I th
On Wed, Nov 9, 2022 at 12:32 AM Kyotaro Horiguchi
wrote:
> I don't think walsenders fetching segment from archive is totally
> stupid. With that feature, we can use fast and expensive but small
> storage for pg_wal, while avoiding replciation from dying even in
> emergency.
>
Thanks! If there is
On Wed, Nov 9, 2022 at 2:37 AM Amit Kapila wrote:
> On Fri, Nov 4, 2022 at 1:40 PM sirisha chamarthi
> wrote:
> >
> Is the intent of setting restart_lsn to InvalidXLogRecPtr was to
> disallow reviving the slot?
> >
>
> I think the intent is to compute the correct value for
> replicationSlotMinL
On Fri, Nov 4, 2022 at 1:40 PM sirisha chamarthi
wrote:
>
Is the intent of setting restart_lsn to InvalidXLogRecPtr was to
disallow reviving the slot?
>
I think the intent is to compute the correct value for
replicationSlotMinLSN as we use restart_lsn for it and using the
invalidated slot's rest
On Wed, Nov 9, 2022 at 3:53 PM Amit Kapila wrote:
>
> On Wed, Nov 9, 2022 at 3:00 PM Bharath Rupireddy
> wrote:
> >
> > On Wed, Nov 9, 2022 at 2:02 PM Kyotaro Horiguchi
> > wrote:
> > >
> > > I don't think walsenders fetching segment from archive is totally
> > > stupid. With that feature, we ca
On Wed, Nov 9, 2022 at 3:00 PM Bharath Rupireddy
wrote:
>
> On Wed, Nov 9, 2022 at 2:02 PM Kyotaro Horiguchi
> wrote:
> >
> > I don't think walsenders fetching segment from archive is totally
> > stupid. With that feature, we can use fast and expensive but small
> > storage for pg_wal, while avoi
On Wed, Nov 9, 2022 at 2:02 PM Kyotaro Horiguchi
wrote:
>
> I don't think walsenders fetching segment from archive is totally
> stupid. With that feature, we can use fast and expensive but small
> storage for pg_wal, while avoiding replciation from dying even in
> emergency.
It seems like a usefu
I don't think walsenders fetching segment from archive is totally
stupid. With that feature, we can use fast and expensive but small
storage for pg_wal, while avoiding replciation from dying even in
emergency.
At Tue, 8 Nov 2022 19:39:58 -0800, sirisha chamarthi
wrote in
> > If it's a streaming
On Mon, Nov 7, 2022 at 11:17 PM Bharath Rupireddy <
bharath.rupireddyforpostg...@gmail.com> wrote:
> On Tue, Nov 8, 2022 at 12:08 PM sirisha chamarthi
> wrote:
> >
> > On Fri, Nov 4, 2022 at 11:02 PM Amit Kapila
> wrote:
> >>
> >> On Fri, Nov 4, 2022 at 1:40 PM sirisha chamarthi
> >> wrote:
> >
On Tue, Nov 8, 2022 at 1:36 AM Amit Kapila wrote:
> On Tue, Nov 8, 2022 at 12:08 PM sirisha chamarthi
> wrote:
> >
> > On Fri, Nov 4, 2022 at 11:02 PM Amit Kapila
> wrote:
> >>
> >> On Fri, Nov 4, 2022 at 1:40 PM sirisha chamarthi
> >> wrote:
> >> >
> >> > A replication slot can be lost when a
On Tue, Nov 8, 2022 at 12:08 PM sirisha chamarthi
wrote:
>
> On Fri, Nov 4, 2022 at 11:02 PM Amit Kapila wrote:
>>
>> On Fri, Nov 4, 2022 at 1:40 PM sirisha chamarthi
>> wrote:
>> >
>> > A replication slot can be lost when a subscriber is not able to catch up
>> > with the load on the primary a
On Tue, Nov 8, 2022 at 12:08 PM sirisha chamarthi
wrote:
>
> On Fri, Nov 4, 2022 at 11:02 PM Amit Kapila wrote:
>>
>> On Fri, Nov 4, 2022 at 1:40 PM sirisha chamarthi
>> wrote:
>> >
>> > A replication slot can be lost when a subscriber is not able to catch up
>> > with the load on the primary a
Hi Amit,
Thanks for your comments!
On Fri, Nov 4, 2022 at 11:02 PM Amit Kapila wrote:
> On Fri, Nov 4, 2022 at 1:40 PM sirisha chamarthi
> wrote:
> >
> > A replication slot can be lost when a subscriber is not able to catch up
> with the load on the primary and the WAL to catch up exceeds
> ma
On Fri, Nov 4, 2022 at 1:40 PM sirisha chamarthi
wrote:
>
> A replication slot can be lost when a subscriber is not able to catch up with
> the load on the primary and the WAL to catch up exceeds
> max_slot_wal_keep_size. When this happens, target has to be reseeded
> (pg_dump) from the scratch
15 matches
Mail list logo