Vjylku

Where to refill my bottle in India?

What tool would a Roman-age civilization have for the breaking of silver and other metals into dust?

How technical should a Scrum Master be to effectively remove impediments?

How are circuits which use complex ICs normally simulated?

Did Section 31 appear in Star Trek: The Next Generation?

Aging parents with no investments

Pokemon Turn Based battle (Python)

Worn-tile Scrabble

What are the motivations for publishing new editions of an existing textbook, beyond new discoveries in a field?

Why didn't the Event Horizon Telescope team mention Sagittarius A*?

What is the meaning of Triage in Cybersec world?

Why do we hear so much about the Trump administration deciding to impose and then remove tariffs?

How to support a colleague who finds meetings extremely tiring?

A poker game description that does not feel gimmicky

Can we generate random numbers using irrational numbers like π and e?

Am I thawing this London Broil safely?

Is "plugging out" electronic devices an American expression?

For what reasons would an animal species NOT cross a *horizontal* land bridge?

Why not take a picture of a closer black hole?

What is the motivation for a law requiring 2 parties to consent for recording a conversation

Why is the maximum length of OpenWrt’s root password 8 characters?

Have you ever entered Singapore using a different passport or name?

Is a "Democratic" Oligarchy-Style System Possible?

Did Scotland spend $250,000 for the slogan "Welcome to Scotland"?

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

bumped to the homepage by Community♦ 10 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

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

bumped to the homepage by Community♦ 10 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

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,38163374

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,38163374

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,38163374

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,38163374

answered Jun 26 '17 at 17:14

user3365973user3365973

1

share|improve this answer

edited Jun 27 '18 at 20:07

tinlyx

5,38163374

answered Jun 26 '17 at 17:14

user3365973user3365973

1

edited Jun 27 '18 at 20:07

tinlyx

5,38163374

edited Jun 27 '18 at 20:07

tinlyx

5,38163374

answered Jun 26 '17 at 17:14

user3365973user3365973

1

answered Jun 26 '17 at 17:14

user3365973user3365973

1