postgis 环境通过 macport selfupdate 改变
上个月，我在 Mac 上使用 Leopard(10.5) 通过 macports 安装了 PostgresSql 8.4.1 和 Postgis 1.4，一切正常。然后我更新到 Snow Leopard(10.6)，仍然一切正常。昨天我尝试用 macports 安装 Gimp，但安装失败。所以我做了一个“端口自我更新”，这似乎破坏了我的 Postgis 安装的部分内容。
当尝试访问数据库中包含几何列的表时，我收到以下错误：
错误：无法加载库“/opt/local/lib/postgresql84/postgis-1.4.so”：dlopen(/opt/local/lib /postgresql84/postgis-1.4.so，10)：未加载库：/opt/local/lib/libgeos_c.1.dylib 引用自：/opt/local/lib/postgresql84/postgis-1.4.so 原因：没有找到合适的图片。是否发现： /opt/local/lib/libgeos_c.1.dylib：mach-o，但架构错误 SQL 状态：58P01
其他非 postgis 表仍然可以访问！
我已经检查了“已安装的端口”是否可能已卸载 postgis，并收到以下列表：
...
postgis @1.4.0_1+postgresql84（活动）
postgresql84 @8.4.0_0
postgresql84 @8.4.1_0（活动）
postgresql84-server @8.4.0_0（活动）
...
我假设丢失的表仍在磁盘上，但未正确引用。有没有办法在硬盘上搜索数据库，并可能更改引用？
Last month I've installed PostgresSql 8.4.1 and Postgis 1.4 via macports on my Mac with Leopard(10.5), and everything just worked fine. I then updated to Snow Leopard(10.6) and still everything was working fine. Yesterday I've tried to install Gimp with macports, the installation failed. So I did a "port selfupdate" which seemed to destroyed parts of my Postgis installation.
When a try to access a table with geometry columns within my database I receive the following error:
ERROR: could not load library "/opt/local/lib/postgresql84/postgis-1.4.so": dlopen(/opt/local/lib/postgresql84/postgis-1.4.so, 10): Library not loaded: /opt/local/lib/libgeos_c.1.dylib
Referenced from: /opt/local/lib/postgresql84/postgis-1.4.so
Reason: no suitable image found. Did find:
/opt/local/lib/libgeos_c.1.dylib: mach-o, but wrong architecture
SQL Status:58P01
The other non-postgis tables are still accessible!
I've checked with "port installed" if postgis was maybe uninstalled, and received the following list:
...
postgis @1.4.0_1+postgresql84 (active)
postgresql84 @8.4.0_0
postgresql84 @8.4.1_0 (active)
postgresql84-server @8.4.0_0 (active)
...
I assume that the missing tables are still on the disk, but are not referenced correctly. Is there a way to search on the hard-disk for the database, and maybe change the reference?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
当您从 10.5 升级到 10.6 时，您是否重新安装了 MacPorts 并重新安装了 ports？ MacPorts（及其管理的端口）与其安装的操作系统版本密切相关。如果升级操作系统，则应重新安装 MacPorts（和您的端口）。更多信息请参阅 MacPorts 迁移常见问题解答。
When you upgraded from 10.5 to 10.6, did you reinstall MacPorts and reinstall your ports? MacPorts (and the ports it manages) are heavily tied to the version of the OS under which it is installed. If you upgrade the OS, you should reinstall MacPorts (and your ports). More information is available in the MacPorts migration FAQ.