Thread: initdb 'no such file or directory' error

initdb 'no such file or directory' error

From
"Ian Oxley"
Date:

Hi

 

I am having trouble running initdb on Cygwin/Windows XP Pro: the error I am getting is as follows:

 

$ initdb –D /home/pgdata

 

The files belonging to this database system will be owned by user "postgres".

This user must also own the server process.

 

The database cluster will be initialized with locale C.

 

creating directory /home/pgdata... ok

creating directory /home/pgdata/base... ok

creating directory /home/pgdata/global... ok

creating directory /home/pgdata/pg_xlog... ok

creating directory /home/pgdata/pg_clog... ok

cp: cannot stat ‘/dev/null.exe’: no such file or directory

 

Having searched the lists I cannot seem to find anything relating to this last line: cp: cannot stat ‘/dev/null.exe’: no such file or directory

 

Any help that anyone can provide would be much appreciated.

 

Thanks

 

Ian

Re: initdb 'no such file or directory' error

From
Erik Brunar
Date:
I commented this line out in initdb:

# cp /dev/null "$PGDATA"/postgresql.conf               || exit_nicely

and in its stead used:

touch "$PGDATA"/postgresql.conf               || exit_nicely

and this worked. However, things went wrong afterwards when trying to start the postmaster with my new install of
Cygwin1.5.18-1, so I re-installed 1.5.17-1, and things have been fine again. 

Erik

Ian Oxley wrote:

> Hi
>
>
>
> I am having trouble running initdb on Cygwin/Windows XP Pro: the error I am
> getting is as follows:
>
>
>
> $ initdb -D /home/pgdata
>
>
>
> The files belonging to this database system will be owned by user
> "postgres".
>
> This user must also own the server process.
>
>
>
> The database cluster will be initialized with locale C.
>
>
>
> creating directory /home/pgdata... ok
>
> creating directory /home/pgdata/base... ok
>
> creating directory /home/pgdata/global... ok
>
> creating directory /home/pgdata/pg_xlog... ok
>
> creating directory /home/pgdata/pg_clog... ok
>
> cp: cannot stat '/dev/null.exe': no such file or directory
>
>
>
> Having searched the lists I cannot seem to find anything relating to this
> last line: cp: cannot stat '/dev/null.exe': no such file or directory
>
>
>
> Any help that anyone can provide would be much appreciated.
>
>
>
> Thanks
>
>
>
> Ian
>
>