+ -
当前位置:首页 → 问答吧 → postgresql安装遇到问题,请教

postgresql安装遇到问题,请教

时间:2010-12-03

来源:互联网

安装信息:

帐户已经存在。

请键入 NET HELPMSG 2224 以获得更多的帮助。

The files belonging to this database system will be owned by user "Administrator
".
This user must also own the server process.

The database cluster will be initialized with locale English_United States.1252.

The default text search configuration will be set to "english".

fixing permissions on existing directory E:/FRAMEW~1/POSTGR~1/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 32MB
creating configuration files ... ok
creating template1 database in E:/FRAMEW~1/POSTGR~1/data/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the -A option the
next time you run initdb.

Success. You can now start the database server using:

    "E:\FRAMEW~1\POSTGR~1\bin\postgres" -D "E:/FRAMEW~1/POSTGR~1/data"
or
    "E:\FRAMEW~1\POSTGR~1\bin\pg_ctl" -D "E:/FRAMEW~1/POSTGR~1/data" -l logfile


然后我运行:

E:\framework\postgresql>"E:\FRAMEW~1\POSTGR~1\bin\postgres" -D "E:/FRAMEW~1/POST
GR~1/data"
Execution of PostgreSQL by a user with administrative permissions is not
permitted.
The server must be started under an unprivileged user ID to prevent
possible system security compromises.  See the documentation for
more information on how to properly start the server.


打开/data/pg_hba.conf配置文件:

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
# IPv6 local connections:
#host    all         all         ::1/128               trust


应该没有问题呀,如何解决?或者指指账号如何写?

作者: l0pht   发布时间: 2010-12-03

在LINUX下安装嘛。

作者: tanfeng3   发布时间: 2010-12-03

回复 tanfeng3


    楼主明显是在WINDOWS下安装的哦。

作者: renxiao2003   发布时间: 2010-12-03

Execution of PostgreSQL by a user with administrative permissions is not
permitted.

在windows下安装的时候默认也会创建一个postgres用户,你切换到postgres用户下执行就可以了

作者: hxre   发布时间: 2010-12-03



QUOTE:
回复  tanfeng3


    楼主明显是在WINDOWS下安装的哦。
renxiao2003 发表于 2010-12-03 16:23




    我的意思是,建议到LINUX下安装postgresql, 这样对学习更有帮助。

作者: tanfeng3   发布时间: 2010-12-03

如此啊。呵呵。

作者: renxiao2003   发布时间: 2010-12-03