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
应该没有问题呀,如何解决?或者指指账号如何写?
帐户已经存在。
请键入 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下安装的哦。
楼主明显是在WINDOWS下安装的哦。
作者: renxiao2003 发布时间: 2010-12-03
Execution of PostgreSQL by a user with administrative permissions is not
permitted.
在windows下安装的时候默认也会创建一个postgres用户,你切换到postgres用户下执行就可以了
permitted.
在windows下安装的时候默认也会创建一个postgres用户,你切换到postgres用户下执行就可以了
作者: hxre 发布时间: 2010-12-03
QUOTE:
回复 tanfeng3
楼主明显是在WINDOWS下安装的哦。
renxiao2003 发表于 2010-12-03 16:23
楼主明显是在WINDOWS下安装的哦。
renxiao2003 发表于 2010-12-03 16:23
我的意思是,建议到LINUX下安装postgresql, 这样对学习更有帮助。
作者: tanfeng3 发布时间: 2010-12-03
如此啊。呵呵。
作者: renxiao2003 发布时间: 2010-12-03
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28