El 03/06/16 a las 16:08, Leonardo M. Ramé escribió:
> Hi again, I'm trying to create the root node using londiste3 from Ubuntu
> 16.04 connected to a PostgreSql 9.3 db, but I get this:
>
> londiste3 /home/leonardo/replication/pacsio_master.ini create-root
> master_node "dbname=test host=127.0.0.1"
>
>
> 2016-06-03 16:03:39,257 27600 INFO plpgsql is installed
> 2016-06-03 16:03:39,257 27600 INFO Installing pgq
> 2016-06-03 16:03:39,258 27600 INFO Reading from
> /usr/local/share/skytools3/pgq.sql
> 2016-06-03 16:03:40,013 27600 ERROR Job job_repli_test_master got error
> on connection 'db': could not access file "$libdir/pgq_lowlevel": No
> existe el archivo o el directorio. 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 147, in cmd_create_root
> return self.create_node('root', 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/local/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
> existe el archivo o el directorio
>
> P.S.: Here there's a suggestion of installing postgresql-9.4-pgq3, but
> as I have 9.3 I cannot install the recommended package (it will install
> 9.4 and start a new cluster).
>
Sorry, I meant: Here
https://blog.lateral.io/2015/09/postgresql-replication-with-londiste-from-skytools-3/
--
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