postgrespro / postgres_cluster

Various experiments with PostgreSQL clustering
Other
151 stars 28 forks source link

FATAL: could not load library "/usr/local/pgsql/lib/multimaster.so" #33

Open dexalex84 opened 7 years ago

dexalex84 commented 7 years ago

Hello

Tried to start postgres service on CentOS 7 and got an error:

FATAL:  could not load library "/usr/local/pgsql/lib/multimaster.so": /usr/local/pgsql/lib/multimaster.so: undefined symbol: IndexRelationGetNumberOfKeyAttributes
LOG:  database system is shut down

All build/installation from source was done with no errors.

Made changes in postgresql.conf and pg_hba.conf:

parts of postgresql.conf:

max_wal_senders = 10  # at least the number of nodes 
max_replication_slots = 10  # at least the number of nodes 
max_connections = 100                   
max_prepared_transactions = 300 
wal_level = logical  
shared_preload_libraries = multimaster
multimaster.max_nodes = 3
multimaster.node_id = 1
multimaster.conn_strings = 'dbname=mydb host=192.168.56.141,dbname=mydb host=192.168.56.142,dbname=mydb host=192.168.56.143'

1) mydb i did not create yet 2) other host are were not created yet

parts of pg_hba.conf

local replication postgres trust
host replication postgres 127.0.0.1/32 trust
host replication postgres ::1/128 trust

Installed on new empty dist of CentOS 7 on VirtualBox WM(Host Win10) CentOS Linux release 7.3.1611 (Core)