Re: Function to move the position of a replication slot

From: Petr Jelinek <petr(dot)jelinek(at)2ndquadrant(dot)com>
To: Dmitry Dolgov <9erthalion6(at)gmail(dot)com>, Craig Ringer <craig(at)2ndquadrant(dot)com>
Cc: Magnus Hagander <magnus(at)hagander(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Function to move the position of a replication slot
Date: 2017-05-10 20:58:29
Message-ID: 6d1e8546-8b11-636b-9a87-85d45edb8c3a@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 10/05/17 22:17, Dmitry Dolgov wrote:
>> On 4 May 2017 at 20:05, Magnus Hagander <magnus(at)hagander(dot)net
> <mailto:magnus(at)hagander(dot)net>> wrote:
>>
>> PFA a patch that adds a new function, pg_move_replication_slot, that
> makes it
>> possible to move the location of a replication slot without actually
>> consuming all the WAL on it.
>
> Just a few questions just a few questions out of curiosity:
>
> * does it make sense to create a few tests for this function in
> `contrib/test_decoding` (as shown in attachment)?
>

As Craig said this will not work correctly for logical slots so it
should throw error on those at the moment (at least until we write
something that works, but that's far more complex than this patch).

--
Petr Jelinek http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Petr Jelinek 2017-05-10 20:59:51 Re: Should pg_current_wal_location() become pg_current_wal_lsn()
Previous Message Dmitry Dolgov 2017-05-10 20:43:10 Re: [PATCH] Generic type subscripting