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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
