Обсуждение: PostgreSQL does not RUN On Windows

Onkar,

On Fri, Jan 10, 2003 at 02:32:06PM +0000, Onkar Chandel wrote:
> 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.

The latest Cygwin PostgreSQL 7.3-1 *requires* cygipc 1.13-2.  Please read
the README:

    http://www.tishler.net/jason/software/postgresql/postgresql-7.3.README

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6

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*

You can get the latest ipc daemon from this website,

http://www.neuro.gatech.edu/users/cwilson/cygutils/cygipc/index.html

-Martin




    
                    Jason Tishler
    
                    <jason@tishler.net>           To:     Onkar Chandel <onkar@hotmail.com>
    
                    Sent by:                      cc:     pgsql-cygwin@postgresql.org
    
                    pgsql-cygwin-owner@post       Subject:     Re: [CYGWIN] PostgreSQL does not RUN On Windows
    
                    gresql.org
    

    

    
                    01/10/2003 10:31 AM
    

    

    




Onkar,

On Fri, Jan 10, 2003 at 02:32:06PM +0000, Onkar Chandel wrote:
> 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.

The latest Cygwin PostgreSQL 7.3-1 *requires* cygipc 1.13-2.  Please read
the README:

    http://www.tishler.net/jason/software/postgresql/postgresql-7.3.README

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Onkar,

On Fri, Jan 10, 2003 at 04:20:53PM +0000, Onkar Chandel wrote:
>       PATH=$PATH:/usr/local/pgsql/bin:/usr/local/bin
>       PGDATA=/usr/local/pgsql/data
>       PGLIB=/usr/local/pgsql/lib
>       LD_LIBRARY_PATH=/usr/local/pgsql/lib:/usr/local/lib
>       export LD_LIBRARY_PATH PATH PGDATA PGLIB

Unless you built PostgreSQL yourself, all of the above except for the
following is unnecessary:

    PATH=$PATH:/usr/local/bin

> And thanks again for your kind help guys.

You are quite welcome.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6