[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    [BUGS] error reading c:\Program Files\PostgreSQL\8.3\data\postgresql.conf
From:       Kent Tong <kent () cpttm ! org ! mo>
Date:       2009-01-22 8:02:24
Message-ID: 49782810.9050309 () cpttm ! org ! mo
[Download RAW message or body]

Package: One click installer of PostgreSQL 8.3

Env: Windows XP SP2 (Traditional Chinese)

What's wrong:

It says error reading c:\Program
Files\PostgreSQL\8.3\data\postgresql.conf during installation. That
data directory is empty. Obviously, you can't start the server
later.

Fix:

This error is caused by the failure of initdb in creating a DB. It
fails probably due to the locale. To fix the problem:

runas /user:postgres cmd
c:
cd "\Program Files\PostgreSQL\8.3\bin"
initdb -D "c:\Program Files\PostgreSQL\8.3\data" -E UTF8
--locale=English

It is very important that you specify the encoding and the locale.
Otherwise it will fail and report that the locale is invalid.


-- 
Kent Tong
SME accounting software package for just MOP30.
See 
http://www.cpttm.org.mo/index_c.php?pg=cpttm/department/is/ispu/accsys/index.htm 
for more.



-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
[prev in list] [next in list] [prev in thread] [next in thread]