尝试创建扩展时出现PostgreSQL错误 [英] PostgreSQL error when trying to create an extension

问题描述

错误：无法打开扩展控制文件/usr/share/postgresql/9.1/extension/postgis.control：没有此类文件或目录

当我尝试 CREATE EXTENSION postgis; 时，我得到的是什么，任何人都可以告诉我为什么会这样，我可以做什么修复它？

Is what I get when I try to CREATE EXTENSION postgis; can anybody tell me why is it so and what can I do to fix it?

推荐答案

以下将使您在Ubuntu 12.04上工作postgis安装（注： p>

The following will get you a working postgis install on Ubuntu 12.04 (Note: also tested on 13.10)

echo "deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main" | sudo tee /etc/apt/sources.list.d/postgis.list
wget --quiet -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get install postgresql-9.3 postgresql-9.3-postgis-2.1 postgresql-client-9.3
sudo -u postgres psql -c 'create extension postgis;'

根据 https://wiki.postgresql.org/wiki/Apt

这篇关于尝试创建扩展时出现PostgreSQL错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！