Thread: PostgreSQL does not RUN On Windows

PostgreSQL does not RUN On Windows

From
"Onkar Chandel"
Date:
<div style="background-color:"><font size="2"><p>I tried all available combinations as suggested on internet but it
neverrun. <p>1. Pre-compiled version with latest Cygwin package: ipc-daemon (cygipc 1.09) was running and then I tried
torun 'initdb' it said IPCSemaphorCreate is not implemented.<p>2. I downloaded PostgreSQL version 7.1.2, cygipc 1.09,
compiledin 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<p>DEBUG: database system was shut down at 2003-01-09 13:18:16
EST<p>DEBUG:CheckPoint record at (0, 1563248)<p>DEBUG: Redo record at (0, 1563248); Undo record at (0, 0); Shutdown
TRUE<p>DEBUG:NextTransactionId: 615; NextOid: 18720<p>DEBUG: database system is in production
state<p>ZeroProcSemaphore:semctl(id=0,SETVAL) failed: Invalid argument<p>Server process (pid 2464) exited with status
65280at Thu Jan 9 13:18:49 2003<p>Terminating any active server processes...<p>Server processes were terminated at Thu
Jan9 13:18:49 2003<p>Reinitializing shared memory and semaphores<p>DEBUG: database system was interrupted at 2003-01-09
13:18:32EST<p>DEBUG: CheckPoint record at (0, 1563248)<p>DEBUG: Redo record at (0, 1563248); Undo record at (0, 0);
ShutdownTRUE<p>DEBUG: NextTransactionId: 615; NextOid: 18720<p>DEBUG: database system was not properly shut down;
automaticrecovery in progress...<p>DEBUG: ReadRecord: record with zero len at (0, 1563312)<p>DEBUG: redo is not
required<p>DEBUG:database system is in production state<p>and at psql screen it said <p>psql: pqReadData() -- backend
closedthe channel unexpectedly.<p>This probably means the backend terminated abnormally<p>before or while processing
therequest.<p>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.<p><br />DOS/Cygwin has maximum memory of 655360 bytes. And I don't know to
increasethis size.<p>Your valuable help is highly appreciated. I have wasted so much time and I have got nothing but
frustration.<p>Thanks<p>OnkarChandel</font></div><br clear="all" /><hr />MSN 8 with e-mail virus protection service: <a
href="http://g.msn.com/8HMMEN/2020">2months FREE*</a> 

Re: PostgreSQL does not RUN On Windows

From
Jason Tishler
Date:
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

Re: PostgreSQL does not RUN On Windows

From
Martin_Hurst@dom.com
Date:
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*








Re: PostgreSQL does not RUN On Windows

From
Martin_Hurst@dom.com
Date:
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)





Re: PostgreSQL does not RUN On Windows

From
"Onkar Chandel"
Date:
<div style="background-color:"><div><p><br /><div></div>Thanks a lot to Jason, Patrick, and Pascal for your kind
help.<p>Solutionof my problem was.<p>- I downloaded latest Cygwin with Postgresql 7.3.1 and installed from
cygwin.com<p>-Downloaded Cygipc 1.13-2 (Also sent by Patrick) and unzipped using<p>   $ tar -C / -xjf
cygipc-1.13-2.tar.bz2<p>-Created .bashrc in '/' directory <p>      PATH=$PATH:/usr/local/pgsql/bin:/usr/local/bin<br
/>     PGDATA=/usr/local/pgsql/data<br />      PGLIB=/usr/local/pgsql/lib<br />     
LD_LIBRARY_PATH=/usr/local/pgsql/lib:/usr/local/lib<br/>      export LD_LIBRARY_PATH PATH PGDATA PGLIB<p>- Ran '$
source/.bashrc<p>- I ran '$ ipc-daemon&' and then I ran '$ initdb'<p>- Then finally ran '$ postmaster -i'<p>And to
mysurprise adduser, createdb etc. all started working. Cool!!!<p>And thanks again for your kind help guys.<p>Onkar
Chandel</div><div></div>>Onkar,<div></div>> <div></div>>On Fri, Jan 10, 2003 at 02:32:06PM +0000, Onkar
Chandelwrote: <div></div>> > I tried all available combinations as suggested on internet but it <div></div>>
>never run. <div></div>> > <div></div>> > 1. Pre-compiled version with latest Cygwin package: ipc-daemon
(cygipc<div></div>> > 1.09) was running and then I tried to run 'initdb' it said <div></div>> >
IPCSemaphorCreateis not implemented. <div></div>> <div></div>>The latest Cygwin PostgreSQL 7.3-1 *requires*
cygipc1.13-2. Please read <div></div>>the README: <div></div>> <div></div>>
http://www.tishler.net/jason/software/postgresql/postgresql-7.3.README<div></div>> <div></div>>Jason
<div></div></div><brclear="all" /><hr />Protect your PC - <a href="http://g.msn.com/8HMLEN/2024">Click here</a> for
McAfee.comVirusScan Online  

Re: PostgreSQL does not RUN On Windows

From
Jason Tishler
Date:
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