在带有 MacPorts 的 Snow Leopard 上使用 postgresql84 和 postgis 时没有 liblwgeom
我正在尝试在升级到 Snow Leopard 后恢复并运行我的开发环境。特别是，我需要 postgresql 和 postgis 工作，但我遇到了以下问题。
安装完这两个文件后：
sudo port install postgresql84 postgresql84-server postgis
当我尝试加载 sql 数据库时，我收到如下错误，该数据库引用了 liblwgeom.so
ERROR: function public.box3d_in(cstring) does not exist
ERROR: incompatible library "/usr/local/pgsql/lib/liblwgeom.so": version mismatch
DETAIL: Server is version 8.4, library is version 8.3.
该文件确实存在于我的计算机上，但必须来自旧安装的 postgresql 8.3。问题是我无法弄清楚 liblwgeom.so 应该来自哪里。它没有包含在 postgis 1.4 中，谷歌搜索让我摸不着头脑。有什么想法吗？
I'm trying to get my dev environment back up and running after upgrading to Snow Leopard. In particular, I need postgresql and postgis working, but I'm running into the following problem.
After installing both with the following:
sudo port install postgresql84 postgresql84-server postgis
I get errors like the following when I try to load my sql database, which has references to liblwgeom.so
ERROR: function public.box3d_in(cstring) does not exist
ERROR: incompatible library "/usr/local/pgsql/lib/liblwgeom.so": version mismatch
DETAIL: Server is version 8.4, library is version 8.3.
That file does exist on my computer, but must be sitting around from an old install of postgresql 8.3. The problem is I can't figure out where liblwgeom.so is supposed to come from. It's not included in postgis 1.4, and a Google search is leaving me scratching my head. Any ideas?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
liblwgeom.so 附带 PostGIS 版本 1.3。它在 1.4 中已重命名。看起来您的转储是 PostGIS 1.3 的数据库，而您正尝试在 PostGIS 1.4 中重新加载。不支持此操作。
有关具体操作的详细信息，请参阅有关升级的 PostGIS 手册。
liblwgeom.so comes with PostGIS vesion 1.3. It has been renamed in 1.4. It looks like your dump is of a database with PostGIS 1.3 and you're trying to reload in PostGIS 1.4. This is not supported.
See the PostGIS manual on upgrading for details on what to do.
更新您的端口：
然后安装 postgis 1.4，它将适用于 postgresql 8.4
Update your ports:
Then install postgis 1.4, which will work for postgresql 8.4