I tried all available combinations as suggested on internet but it never run.
1. Pre-compiled version with latest Cygwin package: ipc-daemon (cygipc 1.09) was running and then I tried to run 'initdb' it said IPCSemaphorCreate is not implemented.
2. I downloaded PostgreSQL version 7.1.2, cygipc 1.09, compiled in cygwin. First of all it gave hell lot of errors. Somehow I could compile it. I successfully started postmaster. But when I ran psql. It gave error
DEBUG: database system was shut down at 2003-01-09 13:18:16 EST
DEBUG: CheckPoint record at (0, 1563248)
DEBUG: Redo record at (0, 1563248); Undo record at (0, 0); Shutdown TRUE
DEBUG: NextTransactionId: 615; NextOid: 18720
DEBUG: database system is in production state
ZeroProcSemaphore: semctl(id=0,SETVAL) failed: Invalid argument
Server process (pid 2464) exited with status 65280 at Thu Jan 9 13:18:49 2003
Terminating any active server processes...
Server processes were terminated at Thu Jan 9 13:18:49 2003
Reinitializing shared memory and semaphores
DEBUG: database system was interrupted at 2003-01-09 13:18:32 EST
DEBUG: CheckPoint record at (0, 1563248)
DEBUG: Redo record at (0, 1563248); Undo record at (0, 0); Shutdown TRUE
DEBUG: NextTransactionId: 615; NextOid: 18720
DEBUG: database system was not properly shut down; automatic recovery in progress...
DEBUG: ReadRecord: record with zero len at (0, 1563312)
DEBUG: redo is not required
DEBUG: database system is in production state
and at psql screen it said
psql: pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
3. I downloaded latest PostgreSQL version 7.3.1. Compiled it, installed it but initdb did not let me go ahead. It was giving IPCMemory failure.
DOS/Cygwin has maximum memory of 655360 bytes. And I don't know to increase this size.
Your valuable help is highly appreciated. I have wasted so much time and I have got nothing but frustration.
Thanks
Onkar Chandel