Hi All,

On some windows 2003 machines the initDB process failed with the following error:


Running in debug mode.The files belonging to this database system will be owned by user "V_MYUSER".This user must also own the server process.

The database cluster will be initialized with locale English_United States.1252.

fixing permissions on existing directory E:/Postgres\Data ... okcreating directory E:/Postgres\Data/global ... okcreating directory E:/Postgres\Data/pg_xlog ... okcreating directory E:/Postgres\Data/pg_xlog/archive_status ...okcreating directory E:/Postgres\Data/pg_clog ... okcreating directory E:/Postgres\Data/pg_subtrans ... okcreating directory E:/Postgres\Data/pg_twophase ... okcreating directory E:/Postgres\Data/pg_multixact/members ... okcreating directory E:/Postgres\Data/pg_multixact/offsets ... okcreating directory E:/Postgres\Data/base ... okcreating directory E:/Postgres\Data/base/1 ... okcreating directory E:/Postgres\Data/pg_tblspc ... okselecting default max_connections ... Access is denied.Access is denied.Access is denied.Access is denied.Access is denied.Access is denied.10selecting default shared_buffers ... Access is denied.Access is denied.Access is denied.Access is denied.Access is denied.Access is denied.Access is denied.Access is denied.Access is denied.Access is denied.Access is denied.50creating configurationfiles ... okcreating template1 database in E:/Postgres\Data/base/1 ... VERSION=8.1.4PGDATA=E:/Postgres\Datashare_path=E:/Program Files/postgres/Database/sharePGPATH=E:/Program Files/postgres/Database/binPOSTGRES_SUPERUSERNAME=V_MYUSERPOSTGRES_BKI=E:/Program Files/postgres/Database/share/postgres.bkiPOSTGRES_DESCR=E:/Program Files/postgres/Database/share/postgres.description

The EnterpriseDB database which is based on postgress works fine.
After short investigation, I found that this is not the first case this behavior was seen.
It seems that the bug is some how connected to access permission for the 'nul' device.
The initDB.c trying to run something like:
postgres.exe -boot -x0 -F -c shared_buffers=200 -c max_connections=40 template1 <"/nul"
After looking at EnterpiseDB and some other help I think the PostgreSQL source need to be modified and re-direct the output from postgres.exe to a file and grants access (to the file) to the postgres service user.

I am willing to contribute and do this fix and appreciate comments from others who already familiar with this issue.

Regards
Dror
__________________________________________________ _______________
Try Live.com: where your online world comes together - with news, sports, weather, and much more.
http://www.live.com/getstarted

On Wed, Aug 02, 2006 at 09:55:53AM +0000, dror bar wrote:
> Hi All,
>
> On some windows 2003 machines the initDB process failed with the following error:

This came up before. It seems microsoft decided to restrict access to
the NUL device in a recent security update.

http://archives.postgresql.org/pgsql...3/msg01262.php

Unfortunatly that thread didn't come to a resolution. Does anyone have
more info on this?

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFE0Hm1IB7bNG8LQkwRAgdEAJ0V+5niCclUWpTIg973zb 0TZrOnigCfaA+s
5aCs5J2/SmApeRNUEA8gVDI=
=rlTU
-----END PGP SIGNATURE-----