执行 initdb 命令失败

snow888

新安装的系统，执行 initdb 命令时出现如下失败信息，何解？


scosysv:~$ export LC_ALL=C
scosysv:~$ initdb -D $HOME/data
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale C.

fixing permissions on existing directory /usr/local/pgsql/data ... ok
creating directory /usr/local/pgsql/data/global ... ok
creating directory /usr/local/pgsql/data/pg_xlog ... ok
creating directory /usr/local/pgsql/data/pg_xlog/archive_status ... ok
creating directory /usr/local/pgsql/data/pg_clog ... ok
creating directory /usr/local/pgsql/data/pg_subtrans ... ok
creating directory /usr/local/pgsql/data/pg_twophase ... ok
creating directory /usr/local/pgsql/data/pg_multixact/members ... ok
creating directory /usr/local/pgsql/data/pg_multixact/offsets ... ok
creating directory /usr/local/pgsql/data/base ... ok
creating directory /usr/local/pgsql/data/base/1 ... ok
creating directory /usr/local/pgsql/data/pg_tblspc ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 1000
creating configuration files ... ok
creating template1 database in /usr/local/pgsql/data/base/1 ... =: is not an ide                                                                             ntifier
child process exited with exit code 1
initdb: removing contents of data directory "/usr/local/pgsql/data"



什么原因？？？

聪明笨小孩

/usr/local/pgsql/data 用户宿主

su -  postgres

[ 本帖最后由 聪明笨小孩 于 2009-8-25 15:42 编辑 ]

smallfish_xy

原帖由 聪明笨小孩 于 2009-8-25 15:28 发表
/usr/local/pgsql/data 用户宿主

su -  postgres

yes注意权限啊。。

snow888

回复 2# 聪明笨小孩


    是这个用户执行的。

那个 data 目录是这个用户主目录下的一个目录。

snow888

[postgres@scosysv ~]$ initdb
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale C.

fixing permissions on existing directory /usr/postgres/data ... ok
creating directory /usr/postgres/data/global ... ok
creating directory /usr/postgres/data/pg_xlog ... ok
creating directory /usr/postgres/data/pg_xlog/archive_status ... ok
creating directory /usr/postgres/data/pg_clog ... ok
creating directory /usr/postgres/data/pg_subtrans ... ok
creating directory /usr/postgres/data/pg_twophase ... ok
creating directory /usr/postgres/data/pg_multixact/members ... ok
creating directory /usr/postgres/data/pg_multixact/offsets ... ok
creating directory /usr/postgres/data/base ... ok
creating directory /usr/postgres/data/base/1 ... ok
creating directory /usr/postgres/data/pg_tblspc ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 50
creating configuration files ... ok
creating template1 database in /usr/postgres/data/base/1 ... =: is not an identifier
child process exited with exit code 1
initdb: removing contents of data directory "/usr/postgres/data"

snow888

什么原因？

congli

PG版本应该是9.x吧, 印象中我遇到这个问题

snow888

回复 7# congli


    从 8.03 到 8.40 我全部试了，都是这个问题。