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@hotmail.com>           To:     pgsql-cygwin@postgresql.org
    
                    Sent by:                      cc:
    
                    pgsql-cygwin-owner@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*