Thread: Cygwin PostgreSQL postmaster problem

Cygwin PostgreSQL postmaster problem

From
svetsch@tradewinds-solutions.com
Date:
Hi,

I'm trying to execute PostgreSQL on Windows 2000, but I have some problems
with it.

My config :

cygwin (today dev snapshot 2001-03-12)
cygipc-1.09-2
postgresql-7.1-beta5

I have successfully installed cygipc (ipc-daemon as a service) compiled
PostgreSQL and executed initdb.
But each time I try to execute postmaster, I get :


$ postmaster -i -d1
FindExec: searching PATH ...
FindExec: found "/usr/local/pgsql/bin/postmaster" using PATH
C:\cygwin\usr\local\pgsql\bin\postgres.exe: ***
recreate_mmaps_after_fork_failed
postmaster: reaping dead processes...
postmaster: Startup proc 1196 exited with status 256 - abort


Any Ideas ?

Thanks in advance !
--
Samuel Vetsch
Trade Winds Solutions
36, rue du XXXI Décembre
CH - 1207 Genève
http://www.tradewinds-solutions.com


RE: Cygwin PostgreSQL postmaster problem

From
Michael Davis
Date:
Here are some suggestions:

* Make sure that PATH contains the right directory for PostgreSQL (/usr/local/pgsql/bin)

* Either provide "-D /usr/local/pgsql/data" when starting the postmaster or set PGDATA

* Export LD_LIBRARY_PATH=/usr/local/pgsql/lib

Thanks, Michael

-----Original Message-----
From:    svetsch@tradewinds-solutions.com [SMTP:svetsch@tradewinds-solutions.com]
Sent:    Friday, March 16, 2001 8:45 AM
To:    pgsql-ports@postgresql.org
Subject:    [PORTS] Cygwin PostgreSQL postmaster problem

Hi,

I'm trying to execute PostgreSQL on Windows 2000, but I have some problems
with it.

My config :

cygwin (today dev snapshot 2001-03-12)
cygipc-1.09-2
postgresql-7.1-beta5

I have successfully installed cygipc (ipc-daemon as a service) compiled
PostgreSQL and executed initdb.
But each time I try to execute postmaster, I get :


$ postmaster -i -d1
FindExec: searching PATH ...
FindExec: found "/usr/local/pgsql/bin/postmaster" using PATH
C:\cygwin\usr\local\pgsql\bin\postgres.exe: ***
recreate_mmaps_after_fork_failed
postmaster: reaping dead processes...
postmaster: Startup proc 1196 exited with status 256 - abort


Any Ideas ?

Thanks in advance !
--
Samuel Vetsch
Trade Winds Solutions
36, rue du XXXI Decembre
CH - 1207 Geneve
http://www.tradewinds-solutions.com


---------------------------(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: Cygwin PostgreSQL postmaster problem

From
Jason Tishler
Date:
Samuel,

On Fri, Mar 16, 2001 at 04:44:32PM, svetsch@tradewinds-solutions.com wrote:
> cygwin (today dev snapshot 2001-03-12)
> cygipc-1.09-2
> postgresql-7.1-beta5

I just tried the above and it passes the regression test without any
errors.

> I have successfully installed cygipc (ipc-daemon as a service) compiled
> PostgreSQL and executed initdb.
> But each time I try to execute postmaster, I get :
>
> $ postmaster -i -d1
> FindExec: searching PATH ...
> FindExec: found "/usr/local/pgsql/bin/postmaster" using PATH
> C:\cygwin\usr\local\pgsql\bin\postgres.exe: ***
> recreate_mmaps_after_fork_failed
> postmaster: reaping dead processes...
> postmaster: Startup proc 1196 exited with status 256 - abort
>
> Any Ideas ?

The above is a known problem that has already been fixed.  See the
following for details:

    http://www.postgresql.org/mhonarc/pgsql-ports/2001-02/msg00012.html
    http://www.postgresql.org/mhonarc/pgsql-ports/2001-02/msg00014.html

Try executing "uname -r".  Do you get "1.3.0s..." or "1.1.8..."?

Did you stop the ipc-daemon service (and *all* other Cygwin processes)
before installing the snapshot?  If not, then the Cygwin 1.1.8-2 DLL is
probably locked in memory preventing the snapshot DLL from taking affect.

Jason

--
Jason Tishler
Director, Software Engineering       Phone: +1 (732) 264-8770 x235
Dot Hill Systems Corp.               Fax:   +1 (732) 264-8798
82 Bethany Road, Suite 7             Email: Jason.Tishler@dothill.com
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com

Re: Cygwin PostgreSQL postmaster problem

From
svetsch@tradewinds-solutions.com
Date:
You were right, my installation of the dev release of cygwin had failed.
Now everything is working fine with the following config :

cygwin (dev snapshot 2001-03-12)
cygipc-1.09-2
postgresql-7.1-beta6

Thanks for your quick answer !

--
Samuel Vetsch
Trade Winds Solutions
36, rue du XXXI Décembre
CH - 1207 Genève
http://www.tradewinds-solutions.com


|--------+--------------------------->
|        |          Jason Tishler    |
|        |          <Jason.Tishler@do|
|        |          thill.com>       |
|        |                           |
|        |          16.03.2001 22:39 |
|        |                           |
|--------+--------------------------->

>---------------------------------------------------------------------------------------------------------------------------|
  |
     | 
  |       To:     svetsch@tradewinds-solutions.com
     | 
  |       cc:     pgsql-ports@postgresql.org
     | 
  |       Subject:     Re: [PORTS] Cygwin PostgreSQL postmaster problem
     | 

>---------------------------------------------------------------------------------------------------------------------------|




Samuel,

On Fri, Mar 16, 2001 at 04:44:32PM, svetsch@tradewinds-solutions.com wrote:
> cygwin (today dev snapshot 2001-03-12)
> cygipc-1.09-2
> postgresql-7.1-beta5

I just tried the above and it passes the regression test without any
errors.

> I have successfully installed cygipc (ipc-daemon as a service) compiled
> PostgreSQL and executed initdb.
> But each time I try to execute postmaster, I get :
>
> $ postmaster -i -d1
> FindExec: searching PATH ...
> FindExec: found "/usr/local/pgsql/bin/postmaster" using PATH
> C:\cygwin\usr\local\pgsql\bin\postgres.exe: ***
> recreate_mmaps_after_fork_failed
> postmaster: reaping dead processes...
> postmaster: Startup proc 1196 exited with status 256 - abort
>
> Any Ideas ?

The above is a known problem that has already been fixed.  See the
following for details:

    http://www.postgresql.org/mhonarc/pgsql-ports/2001-02/msg00012.html
    http://www.postgresql.org/mhonarc/pgsql-ports/2001-02/msg00014.html

Try executing "uname -r".  Do you get "1.3.0s..." or "1.1.8..."?

Did you stop the ipc-daemon service (and *all* other Cygwin processes)
before installing the snapshot?  If not, then the Cygwin 1.1.8-2 DLL is
probably locked in memory preventing the snapshot DLL from taking affect.

Jason

--
Jason Tishler
Director, Software Engineering       Phone: +1 (732) 264-8770 x235
Dot Hill Systems Corp.               Fax:   +1 (732) 264-8798
82 Bethany Road, Suite 7             Email: Jason.Tishler@dothill.com
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com