londiste re-create leaf node

Поиск
Список
Период
Сортировка
Искать
От
Leonardo M. Ramé
Тема
londiste re-create leaf node
Дата
Msg-id
672cecdc-c4d8-5de7-f507-2c3aeb524291@griensu.com
Список
Дерево обсуждения
londiste re-create leaf node Leonardo M. Ramé <l.rame@griensu.com>
Re: londiste re-create leaf node Leonardo M. Ramé <l.rame@griensu.com>
Re: londiste re-create leaf node Tom Lane <tgl@sss.pgh.pa.us>
Re: londiste re-create leaf node Adrian Klaver <adrian.klaver@aklaver.com>
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,
-- 
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

В списке pgsql-general по дате отправления
От: Merlin Moncure
Дата:
От: Leonardo M. Ramé
Дата:
FAQ