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



MSN 8 with e-mail virus protection service: 2 months FREE*