alihaghani
commented
5 years ago This might've been happening after I switched PostgreSQL versions. Running the following command and then redoing the installation instructions fixed this for me.
$ make clean USE_PGXS=1
I get the following error after installation with PostgreSQL 9.6.10.
== 20170224094759 SetupMysqlFdw: migrating ==================================== -- execute("CREATE EXTENSION IF NOT EXISTS mysql_fdw;") rails aborted! StandardError: An error has occurred, this and all later migrations canceled:
PG::InternalError: ERROR: could not load library "/usr/local/Cellar/postgresql@9.6/9.6.10/lib/mysql_fdw.so": dlopen(/usr/local/Cellar/postgresql@9.6/9.6.10/lib/mysql_fdw.so, 10): Symbol not found: _ExecInitExprList Referenced from: /usr/local/Cellar/postgresql@9.6/9.6.10/lib/mysql_fdw.so Expected in: /usr/local/opt/postgresql@9.6/bin/postgres in /usr/local/Cellar/postgresql@9.6/9.6.10/lib/mysql_fdw.so : CREATE EXTENSION IF NOT EXISTS mysql_fdw; /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:73:in'
async_exec' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:73:inblock (2 levels) in execute' /Library/Ruby/Gems/2.3.0/gems/activesupport-5.1.4/lib/active_support/dependencies/interlock.rb:46:inblock in permit_concurrent_loads' /Library/Ruby/Gems/2.3.0/gems/activesupport-5.1.4/lib/active_support/concurrency/share_lock.rb:185:inyield_shares' /Library/Ruby/Gems/2.3.0/gems/activesupport-5.1.4/lib/active_support/dependencies/interlock.rb:45:inpermit_concurrent_loads' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:72:inblock in execute' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract_adapter.rb:612:inblock (2 levels) in log' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract_adapter.rb:611:inblock in log' /Library/Ruby/Gems/2.3.0/gems/activesupport-5.1.4/lib/active_support/notifications/instrumenter.rb:21:ininstrument' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract_adapter.rb:603:inlog' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:71:inexecute' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:849:inblock in method_missing' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:818:inblock in say_with_time' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:818:insay_with_time' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:838:inmethod_missing' /Users/ali/GitHub/1001tl/db/migrate/20170224094759_setup_mysql_fdw.rb:3:inup' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:795:inexec_migration' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:776:inblock (2 levels) in migrate' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:775:inblock in migrate' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:408:inwith_connection' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:774:inmigrate' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:953:inmigrate' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:1230:inblock in execute_migration_in_transaction' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:1298:inblock in ddl_transaction' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/database_statements.rb:235:inblock in transaction' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/transaction.rb:194:inblock in within_new_transaction' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/transaction.rb:191:inwithin_new_transaction' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/database_statements.rb:235:intransaction' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/transactions.rb:210:intransaction' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:1298:inddl_transaction' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:1229:inexecute_migration_in_transaction' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:1188:inrun_without_lock' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:1140:inblock in run' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:1317:inwith_advisory_lock' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:1140:inrun' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:1018:inrun' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/railties/databases.rake:99:inblock (3 levels) in <top (required)>' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.1.4/lib/active_record/railties/databases.rake:84:inblock (3 levels) in <top (required)>' /Library/Ruby/Gems/2.3.0/gems/railties-5.1.4/lib/rails/commands/rake/rake_command.rb:21:inblock in perform' /Library/Ruby/Gems/2.3.0/gems/railties-5.1.4/lib/rails/commands/rake/rake_command.rb:18:inperform' /Library/Ruby/Gems/2.3.0/gems/railties-5.1.4/lib/rails/command.rb:46:ininvoke' /Library/Ruby/Gems/2.3.0/gems/railties-5.1.4/lib/rails/commands.rb:16:in<top (required)>' bin/rails:4:inrequire' bin/rails:4:inWould appreciate help, I followed the instructions as provided in the README. Installed mysql-connector-c via brew.