Odbc_fdw.control is missing

Question

I am using cartoDB and Postgres 9.3 including PostGIS. When I try to create development user in cartoDB I get this error:

'CREATE EXTENSION IF NOT EXISTS odbc_fdw SCHEMA public;'
ERROR:  could not open extension control file "/usr/share/postgresql/9.3/extension/odbc_fdw.control": No such file or directory

Also, when I try to run odbc_fdw extension inside Postgres I get the same error.

Any idea how to fix it?

jgoizueta · Answer

The odbc_fdw extension is an optional component for CARTO, which should work fine without it. It requires PostgreSQL 9.5 so you would not be able to use it with 9.3 anyway.

But the error your experiencing should be prevented by this: https://github.com/CartoDB/cartodb/commit/8c3a6e41

Can you check your code in db_service.rb for the presence of rescue Sequel::DatabaseError?

user3365973 · Answer

This is an old question but I came across it and wanted to shed the light on this cdb_org_member_xxxxx" does not exist issue. This issue is caused by your having the "cartodb" extension in the template_postgis database. Remove that extension from the template_postgis and you will resolve the issue.

Answered by user3365973 on July 11, 2021

Odbc_fdw.control is missing

2 Answers

Add your own answers!

Ask a Question