Error when installing the bdr extension
Hi,
I am trying to install the UDR from 2ndquadrant and I am getting the
following error when I try to create the bdr extension:
# create extension bdr;
ERROR: could not find function "bdr_internal_sequence_reset_cache" in file
"/usr/lib/postgresql94/lib64/bdr.so"
I could not find a mailing list for BDR/UDR so I thought to post my issue
here with my hope that somebody can help me.
Versions installed:
SUSE Linux Enterprise Server 11 (x86_64)
VERSION = 11
PATCHLEVEL = 3
I use Postgres 9.4.4 from suse repo:
postgresql-init-9.4-0.2.1
postgresql94-9.4.4-0.6.2
postgresql94-contrib-9.4.4-0.6.2
postgresql94-devel-9.4.4-0.6.2
postgresql94-server-9.4.4-0.6.2
And I downloaded and compiled the latest stable version of bdr from
https://github.com/2ndQuadrant/bdr/tree/bdr-plugin/REL0_9_STABLE
./autogen.sh
./configure BUILDING_UDR=1
*checking for a sed that does not truncate output... /usr/bin/sedchecking
for pg_config... /usr/bin/pg_configconfigure: building against PostgreSQL
9.4checking for gcc... gccchecking whether the C compiler works...
yeschecking for C compiler default output file name... a.outchecking for
suffix of executables...checking whether we are cross compiling...
nochecking for suffix of object files... ochecking whether we are using the
GNU C compiler... yeschecking whether gcc accepts -g... yeschecking for gcc
option to accept ISO C89... none neededchecking for
replication/replication_identifier.h... noconfigure: postgres-bdr patches
missing, forcing UDR buildconfigure: creating ./config.statusconfig.status:
creating Makefileconfig.status: creating Makefile.globalconfig.status:
creating doc/Makefileconfig.status: creating run_testsconfig.status:
creating bdr_config_generated.hconfig.status: bdr_config_generated.h is
unchanged*make -j4 -s all
make -s install
Updated and restarted postgres config with following parameters:
shared_preload_libraries = 'bdr'
wal_level = 'logical'
max_wal_senders = 4
max_replication_slots = 4
max_worker_processes = 10
I connected to an existing database that I want to replicate and created
the btree_gist extension:
create extension btree_gist;
Then when I attempted to create the bdr extension I got the above mentioned
error:
# create extension bdr;
ERROR: could not find function "bdr_internal_sequence_reset_cache" in file
"/usr/lib/postgresql94/lib64/bdr.so"
Am I missing something, doing the wrong steps? Any help is greatly
appreciated.
Thanks in advance,
Ioana Danes
El 10/09/15 a las 13:17, Ioana Danes escribió:
I could not find a mailing list for BDR/UDR so I thought to post my
issue here with my hope that somebody can help me.
It seems people are now looking for a specific mailing list for bdr/udr
extensions and as I recall from earlier mails, there was some consensus
(maybe I'm mistaken on that, but the topic came up) on having a specific
list for bdr/udr issues.
Where should this be handled? Should it be sent to the pgsql-www list?
Regards
--
Martín Marqués http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
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/10/2015 10:11 AM, Martín Marqués wrote:
El 10/09/15 a las 13:17, Ioana Danes escribió:
I could not find a mailing list for BDR/UDR so I thought to post my
issue here with my hope that somebody can help me.It seems people are now looking for a specific mailing list for bdr/udr
extensions and as I recall from earlier mails, there was some consensus
(maybe I'm mistaken on that, but the topic came up) on having a specific
list for bdr/udr issues.Where should this be handled? Should it be sent to the pgsql-www list?
Yes.
jD
--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi there,
I know I'm just going over an old (maybe not that old) discussion about
having a separate list for BDR and UDR questions, but the traffic in the
pgsql-general list has grown, and others questioned on why those mails
didn't have a specific list which would on-board those topics.
So, if we were to ask for a new list (maybe we can call it
logical-replication@postgresql.org) which are the steps to get approval?
Regards,
El 10/09/15 a las 15:51, Joshua D. Drake escribió:
On 09/10/2015 10:11 AM, Martín Marqués wrote:
El 10/09/15 a las 13:17, Ioana Danes escribió:
I could not find a mailing list for BDR/UDR so I thought to post my
issue here with my hope that somebody can help me.It seems people are now looking for a specific mailing list for bdr/udr
extensions and as I recall from earlier mails, there was some consensus
(maybe I'm mistaken on that, but the topic came up) on having a specific
list for bdr/udr issues.Where should this be handled? Should it be sent to the pgsql-www list?
Yes.
--
Martín Marqués http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-www mailing list (pgsql-www@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-www
Hi!
Apologies for not responding to this one quicker.
We are currently investigating options for setting this up, alongside
dealing with the death of a lot of lists on pgfoundry. We have increased
the priority of it, but itäll be a bit longer until we've figured out a way
to do this that's going to be sustainable fro a maintenance perspective
.
//Magnus
On Thu, Sep 10, 2015 at 9:21 PM, Martín Marqués <martin@2ndquadrant.com>
wrote:
Show quoted text
Hi there,
I know I'm just going over an old (maybe not that old) discussion about
having a separate list for BDR and UDR questions, but the traffic in the
pgsql-general list has grown, and others questioned on why those mails
didn't have a specific list which would on-board those topics.So, if we were to ask for a new list (maybe we can call it
logical-replication@postgresql.org) which are the steps to get approval?Regards,
El 10/09/15 a las 15:51, Joshua D. Drake escribió:
On 09/10/2015 10:11 AM, Martín Marqués wrote:
El 10/09/15 a las 13:17, Ioana Danes escribió:
I could not find a mailing list for BDR/UDR so I thought to post my
issue here with my hope that somebody can help me.It seems people are now looking for a specific mailing list for bdr/udr
extensions and as I recall from earlier mails, there was some consensus
(maybe I'm mistaken on that, but the topic came up) on having a specific
list for bdr/udr issues.Where should this be handled? Should it be sent to the pgsql-www list?
Yes.
--
Martín Marqués http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services--
Sent via pgsql-www mailing list (pgsql-www@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-www