Re: Time based lag tracking for logical replication

On 12/05/17 15:09, Neha Khatri wrote:
> On Fri, May 12, 2017 at 8:19 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
>>
>> On 11 May 2017 at 18:29, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
>>> On 11 May 2017 at 18:13, Andres Freund <andres(at)anarazel(dot)de> wrote:
>>>
>>>>> New patch, v3.
>>>>>
>>>>> Applying in 90 minutes, barring objections.
>>>>
>>>> Could you please wait till tomorrow? I've bigger pending fixes for related code pending/being tested that I plan to push today. I'd also like to take a look before...
>>>
>>> Sure.
>>
>> The changes I've added are very minor, so I'm not expecting debate.
>> The main part of the patch is the same as Petr posted 19days ago.
>>
>> I'm travelling now, so after waiting till tomorrow as you requested I
>> have committed the patch.
>>
>
> Prior to this commit CREATE SUBSCRIPTION used to work smoothly.
>
> After this commit 024711bb544645c8b1061e9f02b261e2e336981d I get
> following error while executing CREATE SUBSCRIPTION:
>
> CREATE SUBSCRIPTION sub1 CONNECTION 'dbname=postgres host=localhost
> user=neha port=5432' PUBLICATION mypub;
> NOTICE: synchronized table states
> ERROR: could not create replication slot "sub1": ERROR: could not
> load library "/home/neha/postgres/PGCurrentInstall/lib/pgoutput.so":
> /home/neha/postgres/PGCurrentInstall/lib/pgoutput.so: undefined
> symbol: OutputPluginUpdateProgress
>

Hmm, that sounds like partial rebuild/install (old postgres binary with
new pgoutput one).

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