单击SQL查询按钮时pgadmin崩溃 [英] pgadmin crash when click SQL query button
问题描述
我在Windows 64位系统上安装了pgAdmin 3,当我连接到某个服务器时,单击SQL按钮执行一些脚本,它崩溃了,我检查了错误日志,它说
I installed pgAdmin 3 on my windows 64bit system, when I connect to some server, click on the SQL button to execute some script, it crashed, i checked the error log, it says
2012-08-05 08:10:00错误:错误:拒绝创建扩展名"adminpack"的权限 提示:必须是超级用户才能创建此扩展.
2012-08-05 08:10:00 ERROR : ERROR: permission denied to create extension "adminpack" HINT: Must be superuser to create this extension.
您能帮我解决这个问题吗?谢谢!
Can you help me to solve this problem? thanks!
推荐答案
adminpack
is an optional extension. pgAdmin should definitely not crash if you don't have it installed.
您可以尝试手动安装.在PostgreSQL 9.1中,请在您的一个数据库中运行一次:
You can try to install it manually. In PostgreSQL 9.1 run once in one of your databases:
CREATE EXTENSION adminpack;
您必须是超级用户.通常,数据库用户postgres
是超级用户.
You must be superuser for that. Normally the database user postgres
is superuser.
这篇关于单击SQL查询按钮时pgadmin崩溃的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!