Re: londiste re-create leaf node

On 09/09/2016 07:15 AM, Leonardo M. Ramé wrote:
> El 09/09/16 a las 10:53, Leonardo M. Ramé escribió:
>> Hi, I had a londiste3 slave server that no longer works and I want to
>> re-create.
>>
>> I dropped all the pgq and londiste schemas in the leaf node
>> manually...now I want to create the node again, but I'm getting this
>> error:
>>
>> londiste3 /home/londiste/replicacion/db_esclavo.ini create-leaf
>> node_esclavo "dbname=database host=192.65.214.199"
>> --provider="dbname=database host=192.65.214.204"
>>
>> ProgrammingError: schema "pgq_node" does not exist
>>
>> This is obvious, the question is how can I re-create that schema.
>>
>> I tried generating the leaf node again, from the master database, but
>> I get this:
>>
>> 2016-09-09 10:58:41,925 9680 INFO plpgsql is installed
>> 2016-09-09 10:58:41,926 9680 INFO Installing pgq
>> 2016-09-09 10:58:41,957 9680 INFO Reading from
>> /usr/local/share/skytools3/pgq.sql
>> 2016-09-09 10:58:45,130 9680 ERROR Job job_repli_ris_master got error
>> on connection 'db': could not access file "$libdir/pgq_lowlevel": No
>> such file or directory.
>>
>> This is weird, because master is working without issues.
>>
>> Regards,
>
> Mmm, built and reinstalled skytools-3.2, but now I'm getting this:
>
> InternalError: could not load library
> "/usr/lib/postgresql/9.5/lib/pgq_lowlevel.so":
> /usr/lib/postgresql/9.5/lib/pgq_lowlevel.so: undefined symbol: oid_hash

Well if I read correctly:

http://pgfoundry.org/forum/forum.php?forum_id=1951

support only goes up to 9.4

>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com