search

omniti-labs / pg_amqp

AMQP Support for Postgres
https://labs.omniti.com/labs/pg_amqp
207 stars 63 forks source link

Ignored delivery_mode 0, value should be 1 or 2 #36

Closed Demuzx closed 2 years ago

Demuzx commented 2 years ago

PostgreSQL 13.4 (Ubuntu 13.4-4.pgdg20.04+1) amqp 0.4.2 RabbitMQ 3.8.17 Erlang 24.0.2

postgres=# SELECT amqp.publish(1, '', 'pg_amqp-test', 'Test message from PostgreSQL'); WARNING: Ignored delivery_mode 0, value should be 1 or 2 server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Failed.

Every request broke connection local psql connection to DB and rabbitmq server doesn't receive messages.

Demuzx commented 2 years ago

Solved. pg_config --libdir prints incorrect lib address - /usr/lib/x86_64-linux-gnu except /usr/lib/postgresql/13/lib. I write a correct libdir path in sources code, then call make install.