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@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...
