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:
VERSION = 11
PATCHLEVEL = 3
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
./autogen.sh
./configure BUILDING_UDR=1
checking for a sed that does not truncate output... /usr/bin/sed
checking for pg_config... /usr/bin/pg_config
configure: building against PostgreSQL 9.4
checking for gcc... gcc
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables...
checking whether we are cross compiling... no
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking for replication/replication_identifier.h... no
configure: postgres-bdr patches missing, forcing UDR build
configure: creating ./config.status
config.status: creating Makefile
config.status: creating Makefile.global
config.status: creating doc/Makefile
config.status: creating run_tests
config.status: creating bdr_config_generated.h
config.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
create extension btree_gist;
# create extension bdr;
ERROR: could not find function "bdr_internal_sequence_reset_cache" in file "/usr/lib/postgresql94/lib64/bdr.so"
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