londiste re-create leaf node

El 09/09/16 a las 10:53, Leonardo M. Ram� escribi�:

Hi, I had a londiste3 slave server that no longer works and I want to
re-create.

I dropped all the pgq and londiste schemas in the leaf node
manually...now I want to create the node again, but I'm getting this
error:

londiste3 /home/londiste/replicacion/db_esclavo.ini create-leaf
node_esclavo "dbname=database host=192.65.214.199"
--provider="dbname=database host=192.65.214.204"

ProgrammingError: schema "pgq_node" does not exist

This is obvious, the question is how can I re-create that schema.

I tried generating the leaf node again, from the master database, but
I get this:

2016-09-09 10:58:41,925 9680 INFO plpgsql is installed
2016-09-09 10:58:41,926 9680 INFO Installing pgq
2016-09-09 10:58:41,957 9680 INFO Reading from
/usr/local/share/skytools3/pgq.sql
2016-09-09 10:58:45,130 9680 ERROR Job job_repli_ris_master got error
on connection 'db': could not access file "$libdir/pgq_lowlevel": No
such file or directory.

This is weird, because master is working without issues.

Regards,

Mmm, built and reinstalled skytools-3.2, but now I'm getting this:

InternalError: could not load library
"/usr/lib/postgresql/9.5/lib/pgq_lowlevel.so":
/usr/lib/postgresql/9.5/lib/pgq_lowlevel.so: undefined symbol: oid_hash

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

On 09/09/2016 07:15 AM, Leonardo M. Ram� wrote:

El 09/09/16 a las 10:53, Leonardo M. Ram� escribi�:

Hi, I had a londiste3 slave server that no longer works and I want to
re-create.

I dropped all the pgq and londiste schemas in the leaf node
manually...now I want to create the node again, but I'm getting this
error:

londiste3 /home/londiste/replicacion/db_esclavo.ini create-leaf
node_esclavo "dbname=database host=192.65.214.199"
--provider="dbname=database host=192.65.214.204"

ProgrammingError: schema "pgq_node" does not exist

This is obvious, the question is how can I re-create that schema.

I tried generating the leaf node again, from the master database, but
I get this:

2016-09-09 10:58:41,925 9680 INFO plpgsql is installed
2016-09-09 10:58:41,926 9680 INFO Installing pgq
2016-09-09 10:58:41,957 9680 INFO Reading from
/usr/local/share/skytools3/pgq.sql
2016-09-09 10:58:45,130 9680 ERROR Job job_repli_ris_master got error
on connection 'db': could not access file "$libdir/pgq_lowlevel": No
such file or directory.

This is weird, because master is working without issues.

Regards,

Mmm, built and reinstalled skytools-3.2, but now I'm getting this:

InternalError: could not load library
"/usr/lib/postgresql/9.5/lib/pgq_lowlevel.so":
/usr/lib/postgresql/9.5/lib/pgq_lowlevel.so: undefined symbol: oid_hash

Well if I read correctly:

http://pgfoundry.org/forum/forum.php?forum_id=1951

support only goes up to 9.4

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

"=?UTF-8?Q?Leonardo_M._Ram=c3=a9?=" <l.rame@griensu.com> writes:

Mmm, built and reinstalled skytools-3.2, but now I'm getting this:

InternalError: could not load library
"/usr/lib/postgresql/9.5/lib/pgq_lowlevel.so":
/usr/lib/postgresql/9.5/lib/pgq_lowlevel.so: undefined symbol: oid_hash

Looks like you built against a set of backend headers that is older than
the server you're trying to run in.

regards, tom lane

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general