- 论坛徽章:
- 59
|
我在XP下安装PostgresQL8.4.1-1时，第一次安装不成功！卸载了！
今天再次安装，依旧不成功！用PGADMIN3连接不上，用NETSTAT -a居然发现没有监听5432端口；
不经意的发现data目录居然是空的，改到到bin目录，执行initdb时，发现有编码的错误（initdb: "China.936" is not a valid server encoding name），我就上网查找这个错误！
总算找到了。参照：http://old.nabble.com/postgresql ... PRC-td24300693.html
然后用命令initdb -U postgres --encoding=English --locale=utf8，成功了！
原来是PG对中文支持还不够啊。没办法！先凑合用吧。
下面是链接的原文：
postgresql 8.4 install failed on windows xp chinese PRC
View: Threaded Chronologically All Messages New views 3 Messages — Rating Filter: 0 1 2 3 4 5 Alert me
postgresql 8.4 install failed on windows xp chinese PRC
by 刘鑫 :: Rate this Message:
Reply | Reply to Author | Print | View Threaded | Show Only this Message
system : windows xp Chinese simple
postgres : postgresql-8.4.0-1-windows.exe
installl processing and errors:
install failed by one click installer, then I run initdb.
F:\PostgreSQL\8.4\bin>initdb -U postgres --encoding=utf8 --locale=utf8 --lc-coll
ate='missing' F:\PostgresSQL\8.4\data
initdb: invalid locale name "utf8"
initdb: invalid locale name "'missing'"
initdb: invalid locale name "utf8"
initdb: invalid locale name "utf8"
initdb: invalid locale name "utf8"
initdb: invalid locale name "utf8"
The files belonging to this database system will be owned by user "刘鑫".
This user must also own the server process.
The database cluster will be initialized with locale Chinese_People's Republic o
f China.936.
initdb: could not find suitable text search configuration for locale Chinese_Peo
ple's Republic of China.936
The default text search configuration will be set to "simple".
creating directory F:/PostgresSQL/8.4/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 32MB
creating configuration files ... ok
creating template1 database in F:/PostgresSQL/8.4/data/base/1 ... ok
initializing pg_authid ... FATAL: database locale is incompatible with operatin
g system
DETAIL: The database was initialized with LC_COLLATE "Chinese_Peoples Republic
of China.936", which is not recognized by setlocale().
HINT: Recreate the database with another locale or install the missing locale.
child process exited with exit code 1
initdb: removing data directory "F:/PostgresSQL/8.4/data"
I reinstall and set LC_COLLATE to English, Unite State. It success.
March.Liu
Re: postgresql 8.4 install failed on windows xp chinese PRC
by ITAGAKI Takahiro-2 :: Rate this Message:
Reply | Reply to Author | Print | View Threaded | Show Only this Message
?? <march.liu@...> wrote:
> system : windows xp Chinese simple
> postgres : postgresql-8.4.0-1-windows.exe
> F:\PostgreSQL\8.4\bin>initdb -U postgres --encoding=utf8 --locale=utf8
It's not a bug, just "utf8" is not a valid locale name.
Use the following instead:
$ initdb --encoding=UTF8 --locale="Chinese (Simplified)"
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-bugs mailing list (pgsql-bugs@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Re: postgresql 8.4 install failed on windows xp chinese PRC
by Sachin Srivastava-2 :: Rate this Message:
Reply | Reply to Author | Print | View Threaded | Show Only this Message
On 07/02/2009 09:17 AM, 刘鑫 wrote:
> system : windows xp Chinese simple
> postgres : postgresql-8.4.0-1-windows.exe
>
> installl processing and errors:
>
> install failed by one click installer, then I run initdb.
Can you please post the error part in the install logs present in your
system's temp directory (%TEMP%\install-postgresql.log) ?
--
Regards,
Sachin Srivastava
www.enterprisedb.com
--
Sent via pgsql-bugs mailing list (pgsql-bugs@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs |
|
免费注册
发表于 2009-12-04 13:24