Re: Londiste3 - Ubuntu 16.04 - Postgresql 9.3

On 06/03/2016 12:08 PM, Leonardo M. Ramé wrote:
> 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).

That would seem to be if you wanted to install the Skytools binaries.
You are building from source.

What where the steps you took to configure and build the package?

Where there any error/warning messages when building?

My suspicion is the below from the INSTALL file:

"--prefix::
   Path prefix where to install skytools files (default: /usr/local)
"

Best guess is your build put the files somewhere other then $libdir.


>
>
>
>
> Regards,


--
Adrian Klaver
adrian.klaver@aklaver.com