Re: [MASSMAIL] Problemas réplica 9.4 con londiste3

Buenos días amigos, problema solucionado instalando en el esclavo
apt-get install skytools-modules

Saludos.

----- Mensaje original -----

De: "Yoan Manuel Pérez Piñero" <ymperez(at)uci(dot)cu>
CC: "Lista Postgres ES" <pgsql-es-ayuda(at)postgresql(dot)org>
Enviados: Miércoles, 16 de Diciembre 2015 13:42:39
Asunto: [MASSMAIL] [pgsql-es-ayuda] Problemas réplica 9.4 con londiste3

Hola amigos,
Escribo para ver si me pueden ayudar, estoy intentando utilizar Londiste3 para replicar ciertas tablas de una base de datos A hacia una B. Cuando llego a este paso:

root(at)debian8-db-master:/usr/local/londiste-config# londiste3 slave.ini create-branch slave 'dbname=name_db_slave host=X.X.X.X port=5432 user=user_db password=passwd_db' --provider='dbname=name_db_master host=X.X.X.X port=5432 user=user_db password=passwd_db'

Da este error:

2015-12-16 12:50:49,794 5011 INFO plpgsql is installed
2015-12-16 12:50:49,797 5011 INFO Installing pgq
2015-12-16 12:50:49,798 5011 INFO Reading from /usr/local/share/skytools3/pgq.sql
2015-12-16 12:50:50,610 5011 ERROR Job slave got error on connection 'db': could not access file "$libdir/pgq_lowlevel": No such file or directory. Query: CREATE OR REPLACE FUNCTION pgq.insert_event_raw(
queue_n ...
Traceback (most recent call last):
File "/usr/local/lib/python2.7/dist-packages/skytools/scripting.py", line 579, in run_func_safely
r = func()
File "/usr/local/lib/python2.7/dist-packages/skytools/adminscript.py", line 62, in work
fn(*cmdargs)
File "/usr/local/lib/python2.7/dist-packages/pgq/cascade/admin.py", line 150, in cmd_create_branch
return self.create_node('branch', args)
File "/usr/local/lib/python2.7/dist-packages/pgq/cascade/admin.py", line 198, in create_node
self.install_code(db)
File "/usr/local/lib/python2.7/dist-packages/londiste/setup.py", line 29, in install_code
CascadeAdmin.install_code(self, db)
File "/usr/local/lib/python2.7/dist-packages/pgq/cascade/admin.py", line 425, in install_code
skytools.db_install(db.cursor(), objs, self.log)
File "/usr/local/lib/python2.7/dist-packages/skytools/sqltools.py", line 531, in db_install
obj.create(curs, log)
File "/usr/local/lib/python2.7/dist-packages/skytools/sqltools.py", line 490, in create
curs.execute(stmt)
File "/usr/lib/python2.7/dist-packages/psycopg2/extras.py", line 120, in execute
return super(DictCursor, self).execute(query, vars)
OperationalError: could not access file "$libdir/pgq_lowlevel": No such file or directory

Características:

Sistema Operativo: Debian 8

PostgreSQL: 9.4

Skytools: 3.2

Agradezco la ayuda...