From: | Leonardo M(dot) Ramé <l(dot)rame(at)griensu(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: londiste re-create leaf node |
Date: | 2016-09-09 14:15:40 |
Message-ID: | d071b73a-f576-8c97-b4d1-753c7b35b6ec@griensu.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
--
Leonardo M. Ramé
Medical IT - Griensu S.A.
Av. Colón 636 - Piso 8 Of. A
X5000EPT -- Córdoba
Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19
Cel.: +54 9 (011) 40871877
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2016-09-09 14:24:54 | Re: londiste re-create leaf node |
Previous Message | Leonardo M. Ramé | 2016-09-09 13:53:41 | londiste re-create leaf node |