Обсуждение: Londiste3 - Ubuntu 16.04 - Postgresql 9.3
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). 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
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
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
El 03/06/16 a las 16:29, Adrian Klaver escribió: > 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. > Finally it worked, added the 9.3 repository: sudo tee /etc/apt/sources.list.d/pgdg.list <<EOF deb http://apt.postgresql.org/pub/repos/apt/ utopic-pgdg main EOF wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - sudo apt-get update then installed the packages: sudo apt-get install postgresql-server-dev-9.3 sudo apt-get install postgresql-9.3-pgq3 then again: ./configure --prefix=/usr/local --with-pgconfig=/usr/lib/postgresql/9.3/bin/pg_config make sudo make install then: sudo su postgres and: londiste3 /home/leonardo/replication/pacsio_master.ini create-root master_node "dbname=test host=127.0.0.1" Done! 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