blocks|key|825826|text|如果加载Postgis扩展，那么您的SQL可能找不到geometry，因为缺少公共模式的搜索路径。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|825827|试一试|825828|设置search_path+=+...，public；|825829|在你的脚本的第一行。(替换...使用其他所需的搜索路径)|825830|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

If the Postgis-Extension is loaded, then your SQL perhaps does not find the geometry-type because of missing search-path to the public schema.

Try 

SET search_path = ..., public;

in the first line of your scsript. (replace ... with the other required search-paths)

blocks|key|825751|text|您可以从终端执行此操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|825752|psql+mydatabasename+-c+"CREATE+EXTENSION+postgis";|code-block|syntax|javascript|825753|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can do it from terminal:

<pre><code>psql mydatabasename -c "CREATE EXTENSION postgis";
</code></pre>

blocks|key|825640|text|要让psql在出现第一个错误时停止，可以使用-v+ON_ERROR_STOP=1+(这就是off+by+default，这就是您看到许多错误的原因)。例如：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|825641|psql+-U+postgres+-d+postgis+-v+ON_ERROR_STOP=1+-f+postgis.sql|code-block|syntax|javascript|825642|实际的错误类似于“无法加载库X"，具体情况视情况而定。作为猜测，请在安装sql脚本之前尝试此命令：|825643|ldconfig|825644|(根据您的系统，您可能需要使用sudo作为前缀)。此命令会更新所有系统库的路径，例如GEOS。|825645|entityMap|0|LINK|mutability|MUTABLE|url|http://www.postgresql.org/docs/current/static/app-psql.html^0|M|I|19|E|0|0|0|0|0|F|4|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]]|D|@$9|11|A|12|1|13]]|E|$]]|$1|F|3|G|5|H|7|14|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|15|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|16|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|17|8|@$9|18|A|19|B|C]]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|1A|8|@]|D|@]|E|$]]]|R|$S|$5|T|U|V|E|$W|X]]]]

To get psql to stop on the first error, use <code>-v ON_ERROR_STOP=1</code> (which is <a href="http://www.postgresql.org/docs/current/static/app-psql.html" rel="noreferrer">off by default</a>, which is why you see many errors). For example:

<pre><code>psql -U postgres -d postgis -v ON_ERROR_STOP=1 -f postgis.sql
</code></pre>

The actual error is something like "could not load library X", which can vary on your situation. As a guess, try this command before installing the sql script:

<pre><code>ldconfig
</code></pre>

(you might need to prefix with <code>sudo</code> depending on your system). This command updates the paths to all system libraries, such as GEOS.

blocks|key|825779|text|您必须在数据库上启用该扩展。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|825780|psql+my_database+-c+"CREATE+EXTENSION+postgis;"|offset|length|style|CODE|825781|entityMap^0|0|0|1B|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

You must enable the extension on your database.

<code>psql my_database -c "CREATE EXTENSION postgis;"
</code>

blocks|key|611070|text|您还需要确保您尝试使用postgis扩展的用户能够访问设置postgis的模式(在我阅读的教程中称为“postgis”)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|611071|我刚刚遇到了这个错误，它得到了解决，因为我只给了一个新用户访问数据库的权限。在我创建的数据库中，我运行：|611072|grant+all+on+schema+postgis+to+USERNAME;+|code-block|syntax|javascript|611073|这样就解决了这个错误|611074|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

You also need to ensure that the user you are trying to use the postgis extension as, has access to the schema where postgis is setup (which in the tutorials I read is called 'postgis').

I just had this error, and it was solved because I had only given a new user access to the database. In the database I'd created, I ran:

<pre><code>grant all on schema postgis to USERNAME; 
</code></pre>

And this solved this error

blocks|key|825890|text|此处的答案可能会解决您的问题，但是，如果您已经在DB上启用了postgis，则问题可能是您正在尝试将postgis表(具有几何列)恢复到启用postgis扩展的其他模式中。在pgAdmin中，您可以单击postgis扩展并查看指定了哪个模式。如果您尝试将包含几何列的表恢复到不同的模式中，则可能会出现此错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|825891|我通过修改我的postgis扩展解决了这个问题--但是我不确定这是否是最好的方法。我所知道的就是它允许我恢复表。|825892|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

The answers here may solve your problem, however if you already have postgis enabled on your DB, the issue may be that you are trying to restore a postgis table (with a geometry column) into a schema other than where your postgis extension is enabled. In pgAdmin you can click on the postgis extension and see which schema is specified. If you are trying to restore a table with geometry column into a different schema, you might get this error.

I resolved this by altering my postgis extension - however I'm not sure if that was necessarily the best way to do it. All I know is that it allowed me to restore the table.

blocks|key|825704|text|或者..。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|825705|cursor.execute('create+extension+postgis')|code-block|syntax|javascript|825706|在python程序中，使用来自psycopg2的当前游标。|825707|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Or...

<pre><code>cursor.execute('create extension postgis')
</code></pre>

in your python program, using a current cursor from psycopg2.

blocks|key|611031|text|首先，确保您安装了postgis+(与pg版本:+psql+-V匹配)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|611032|sudo+apt+install+postgis+postgresql-9.6-postgis-2.3|code-block|syntax|javascript|611033|在创建表之前添加：|611034|db.engine.execute('create+extension+postgis')+
db.create_all()|611035|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

First make sure you have (matching to pg version: psql -V) postgis installed:

<pre><code>sudo apt install postgis postgresql-9.6-postgis-2.3
</code></pre>

Just before tables creation add:

<pre><code>db.engine.execute('create extension postgis') 
db.create_all()
</code></pre>

blocks|key|611144|text|我的经验是我试图将ism文件加载到一个不同于"public“的文件中。我在另一个模式上初始化了postgis扩展，而不是public。所以这并不管用。所以最后我不得不删除了这个扩展，然后公开创建了postgis扩展。之后，我可以将osm加载到我的新模式中|type|unstyled|depth|inlineStyleRanges|entityRanges|data|611145|Osm总是公开查找扩展文件，而不管您打算将osm文件安装在另一个架构中的什么位置|611146|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

My experience was I was trying to load the ism file to a different file than &quot;public&quot;. I initialised the postgis extension on another schema other than public. So that didn't work. So finally I had to remove the extension, and than created the postgis extension in public. After that I could load the osm into my new schema
Osm always looks for the extension file in public, irregardless of where u intend to install the osm files in another schema

I am trying to create table with Postgis. I do it by this <a href="http://postgis.refractions.net/documentation/manual-1.5/ch02.html#id2619431" rel="noreferrer" title="official documentation">page</a>. But when I import postgis.sql file, I get a lot of errors:

<pre><code>ERROR: type "geometry" does not exist
</code></pre>

Does anybody know how can I fix it?

Postgis installation: type "geometry" does not exist

数据库

我正在尝试用Postgis创建表格。我是通过这个来做的。但是当我导入postgis.sql文件时，我得到了很多错误：ERROR:  type "geometry" does not exist有没有人知道我怎么才能修复它？

问Postgis安装:类型"geometry“不存在
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Postgis安装:类型"geometry“不存在EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Postgis安装:类型"geometry“不存在
EN