Hfrhyu

Did Deadpool rescue all of the X-Force?

Why should I vote and accept answers?

What is this clumpy 20-30cm high yellow-flowered plant?

Significance of Cersei's obsession with elephants?

How does light 'choose' between wave and particle behaviour?

Has negative voting ever been officially implemented in elections, or seriously proposed, or even studied?

Denied boarding although I have proper visa and documentation. To whom should I make a complaint?

What's the meaning of "fortified infraction restraint"?

Why do early math courses focus on the cross sections of a cone and not on other 3D objects?

How can I reduce the gap between left and right of cdot with a macro?

Should I use a zero-interest credit card for a large one-time purchase?

What is the appropriate index architecture when forced to implement IsDeleted (soft deletes)?

Can the Great Weapon Master feat's damage bonus and accuracy penalty apply to attacks from the Spiritual Weapon spell?

Is it possible for SQL statements to execute concurrently within a single session in SQL Server?

Time to Settle Down!

What initially awakened the Balrog?

Disembodied hand growing fangs

Amount of permutations on an NxNxN Rubik's Cube

Why is it faster to reheat something than it is to cook it?

Why is Nikon 1.4g better when Nikon 1.8g is sharper?

Effects on objects due to a brief relocation of massive amounts of mass

Is it fair for a professor to grade us on the possession of past papers?

Is it ethical to give a final exam after the professor has quit before teaching the remaining chapters of the course?

Is there hard evidence that the grant peer review system performs significantly better than random?

Odbc_fdw.control is missing

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

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?

postgis postgresql carto

share|improve this question

edited Jul 26 '16 at 12:35

iriberri

4,68221026

asked Jul 26 '16 at 9:10

VNenadVNenad

294

add a comment | 

0

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?

postgis postgresql carto

share|improve this question

edited Jul 26 '16 at 12:35

iriberri

4,68221026

asked Jul 26 '16 at 9:10

VNenadVNenad

294

add a comment | 

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?

postgis postgresql carto

share|improve this question

edited Jul 26 '16 at 12:35

iriberri

4,68221026

asked Jul 26 '16 at 9:10

VNenadVNenad

294

'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

share|improve this question

edited Jul 26 '16 at 12:35

iriberri

4,68221026

asked Jul 26 '16 at 9:10

VNenadVNenad

294

share|improve this question

edited Jul 26 '16 at 12:35

iriberri

4,68221026

asked Jul 26 '16 at 9:10

VNenadVNenad

294

edited Jul 26 '16 at 12:35

iriberri

4,68221026

edited Jul 26 '16 at 12:35

iriberri

4,68221026

asked Jul 26 '16 at 9:10

VNenadVNenad

294

asked Jul 26 '16 at 9:10

VNenadVNenad

294

2 Answers
2

active

oldest

votes

0

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?

share|improve this answer

answered Jul 26 '16 at 12:56

jgoizuetajgoizueta

361

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Just checked db_service.rb there is rescue Sequel::DatabaseError
  
  – VNenad
  Jul 26 '16 at 13:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I deleted everything related to install_odbc_fdw and it works now. Hope it was clever. But in the following, I get this error: PG::Error: ERROR: role "cdb_org_member_cd4c6486da97f514ce4aaec5338e2296" does not exist. Is this something related to the previous issue?
  
  – VNenad
  Jul 26 '16 at 15:18
  

  
  
  
  

add a comment | 

0

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.

share|improve this answer

edited Jun 27 '18 at 20:07

tinlyx

5,41563374

answered Jun 26 '17 at 17:14

user3365973user3365973

1

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f203546%2fodbc-fdw-control-is-missing%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

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?

share|improve this answer

answered Jul 26 '16 at 12:56

jgoizuetajgoizueta

361

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Just checked db_service.rb there is rescue Sequel::DatabaseError
  
  – VNenad
  Jul 26 '16 at 13:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I deleted everything related to install_odbc_fdw and it works now. Hope it was clever. But in the following, I get this error: PG::Error: ERROR: role "cdb_org_member_cd4c6486da97f514ce4aaec5338e2296" does not exist. Is this something related to the previous issue?
  
  – VNenad
  Jul 26 '16 at 15:18
  

  
  
  
  

add a comment | 

0

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?

share|improve this answer

answered Jul 26 '16 at 12:56

jgoizuetajgoizueta

361

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Just checked db_service.rb there is rescue Sequel::DatabaseError
  
  – VNenad
  Jul 26 '16 at 13:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I deleted everything related to install_odbc_fdw and it works now. Hope it was clever. But in the following, I get this error: PG::Error: ERROR: role "cdb_org_member_cd4c6486da97f514ce4aaec5338e2296" does not exist. Is this something related to the previous issue?
  
  – VNenad
  Jul 26 '16 at 15:18
  

  
  
  
  

add a comment | 

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?

share|improve this answer

answered Jul 26 '16 at 12:56

jgoizuetajgoizueta

361

share|improve this answer

answered Jul 26 '16 at 12:56

jgoizuetajgoizueta

361

answered Jul 26 '16 at 12:56

jgoizuetajgoizueta

361

answered Jul 26 '16 at 12:56

jgoizuetajgoizueta

361

0

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.

share|improve this answer

edited Jun 27 '18 at 20:07

tinlyx

5,41563374

answered Jun 26 '17 at 17:14

user3365973user3365973

1

add a comment | 

0

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.

share|improve this answer

edited Jun 27 '18 at 20:07

tinlyx

5,41563374

answered Jun 26 '17 at 17:14

user3365973user3365973

1

add a comment | 

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.

share|improve this answer

edited Jun 27 '18 at 20:07

tinlyx

5,41563374

answered Jun 26 '17 at 17:14

user3365973user3365973

1

share|improve this answer

edited Jun 27 '18 at 20:07

tinlyx

5,41563374

answered Jun 26 '17 at 17:14

user3365973user3365973

1

edited Jun 27 '18 at 20:07

tinlyx

5,41563374

edited Jun 27 '18 at 20:07

tinlyx

5,41563374

answered Jun 26 '17 at 17:14

user3365973user3365973

1

answered Jun 26 '17 at 17:14

user3365973user3365973

1