Re: PostgreSQL does not RUN On Windows

Have you tried downloading the "setup.exe" program from the
"http://www.cygwin.com/" website, and running it to download the postgresql
package from their site, and having the cygwin setup program install and
compile it on your machine?
This way the cygwin setup.exe looks after all the details, you don't have
do it.

During the setup.exe session I selected the ftp mirror -->
ftp://ftp.nas.nasa.gov. This ftp site contains postgres version, 7.3-1

Just a thot,
-Martin

"Onkar Chandel"
<onkar(at)hotmail(dot)com> To: pgsql-cygwin(at)postgresql(dot)org
Sent by: cc:
pgsql-cygwin-owner(at)post Subject: [CYGWIN] PostgreSQL does not RUN On Windows
gresql.org


01/10/2003 09:32 AM

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*