error reading c:\Program Files\PostgreSQL\8.3\data\postgresql.conf during installation

From: Kent Tong <kent(at)cpttm(dot)org(dot)mo>
To: pgsql-bugs(at)postgresql(dot)org
Subject: error reading c:\Program Files\PostgreSQL\8.3\data\postgresql.conf during installation
Date: 2009-01-22 08:02:24
Message-ID: 49782810.9050309@cpttm.org.mo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Meskes 2009-01-22 11:08:54 Re: segmentation fault on Dynamic query using C
Previous Message Priyank Raj 2009-01-22 06:10:22 segmentation fault on Dynamic query using C