EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

Problem during installing PostgreSQL 8.4.2-1 on WindowsXP  XML

Forum Index » PostgreSQL Installers for Windows, Linux and OS X
Author Message
Jenny_Yang

New member

Joined: 26 Jan 2010 13:52:47
Messages: 1
Offline

Hello, I have a problem during installing PostgreSQL 8.4.2-1 on WindowsXP. However, the setup process is done. but I don't know whether it dose matter?
The Problem is that "problem running post-install step. Installation may not complete correctly
Error readding file D:/PostgreSQL/8.4/data/postgresql.conf"
Thank you


 Filename 未命名.JPG [Disk] Download
 Description PrintScreen
 Filesize 31 Kbytes
 Downloaded:  285 time(s)

raghu_r

Member

Joined: 28 Jan 2009 23:23:25
Messages: 51
Offline

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

runas /user:postgres cmd
c:
cd "\Program Files\PostgreSQL\8.4\bin"
initdb -D "c:\Program Files\PostgreSQL\8.4\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.

If the problem still exists, could you please share the log file.
[Email]
Ganesh_K_2

New member

Joined: 24 Feb 2010 20:10:31
Messages: 4
Offline

Running the following command doesn't help as it results in the same error:

initdb -D "c:\Program Files\PostgreSQL\8.4\data" -E UTF8 --locale=English


Log:

The files belonging to this database system will be owned by user "USER".
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 C:/Program Files/PostgreSQL/8.4/data ... ok
creating subdirectories ... ok
selecting default max_connections ... The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
10
selecting default shared_buffers ... The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
400kB
creating configuration files ... ok
creating template1 database in C:/Program Files/PostgreSQL/8.4/data/base/1 ... ok
initializing pg_authid ... The system cannot find the file specified.
child process exited with exit code 1
initdb: removing contents of data directory "C:/Program Files/PostgreSQL/8.4/data"



I tried different versions of installers and all results in the same error (highlighted in red color).

Please help to resolve this error.

Thanks..

This message was edited 1 time. Last update was at 24 Feb 2010 21:05:10

Sachin_S

Senior member

Joined: 1 Aug 2008 02:37:24
Messages: 445
Offline

Hello,

Please try this installer : http://uploads.enterprisedb.com/download.php?file=74f8a585020690e1abe133259020104b

This message was edited 1 time. Last update was at 26 Feb 2010 04:04:13


--
Regards,
Sachin Srivastava
EnterpriseDB , the Enterprise Postgres company.
Ganesh_K_2

New member

Joined: 24 Feb 2010 20:10:31
Messages: 4
Offline

I'm still getting the same error. I've almost tried all of the installers from version 8.3.5 to 8.4.2 and I'm getting exactly the same error.
scottiebo

Senior member
[Avatar]

Joined: 23 Oct 2005 21:05:02
Messages: 197
Offline

It looks like a permissions issue. Try setting the data directory to something other than the default. For example, try using

c:\pgdata

And see what happens.

--Scottie
 
Forum Index » PostgreSQL Installers for Windows, Linux and OS X
Go to:   
Powered by JForum 2.1.8 © JForum Team