Обсуждение: Error by starting postmaster

I installed PostgeSQL on Windows 2000 like KevinLo disscipted in his
installation procedure.
The installation finished with no error.
When I do 'postmaster -i&' I get this message:
C:\cygwin\usr\local\pgsql\bin\postgres.exe: ***
recreate_mmaps_after_fork_failed
Startup failed - abort
NOTICE: IpcMemoryDetach: shmdt<0x0x7190000>: Invalid argument
NOTICE: IpcMemoryDetach: shmdt<0x0x7060000>: Invalid argument
NOTICE: IpcMemoryDetach: shmdt<0x0x7050000>: Invalid argument

What can I do??

best regards,
Rolf Brockmann

BCS Brockmann-Computer-Systemtechnik GmbH
D-33332 Gütersloh, Hoher Kamp 22
Tel   +49 5241 402595
Fax  +49 5241 402596
E-Mail r.brockmann@bcs-brockmann.de

Rolf,

On Thu, Feb 15, 2001 at 09:57:33AM +0100, bcs-brockmann.de wrote:
> When I do 'postmaster -i&' I get this message:
> C:\cygwin\usr\local\pgsql\bin\postgres.exe: ***
> recreate_mmaps_after_fork_failed
> Startup failed - abort

See the following:

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

> NOTICE: IpcMemoryDetach: shmdt<0x0x7190000>: Invalid argument
> NOTICE: IpcMemoryDetach: shmdt<0x0x7060000>: Invalid argument
> NOTICE: IpcMemoryDetach: shmdt<0x0x7050000>: Invalid argument

See the following:

    http://www.postgresql.org/mhonarc/pgsql-ports/2001-01/msg00092.html

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

Rolf,

On Mon, Feb 19, 2001 at 10:14:08AM +0100, bcs-brockmann.de wrote:
> Hallo Jason,
> thanks fpr your message below.
> Charles Wilson has a new version of cygipc, now there is only the error
> message
> recreate_mmaps_after_fork_failed
> Startup failed - abort
>
> I want to go back to cygwin 1.1.7, but how can I do it?
> I only have the complete version of 1.1.8. When I go to
> ftp://ftp.sunsite.utk.edu/pub/cygwin/latest/cygwin/ and downloaded
> cygwin-1.1.7-1.tar.gz and make tar with the installed 1.1.8, is that enough
> for downgrading to 1.1.7?
> But now I have still the same error!
>
> What to do ?

This is an excellent question.  When I suggested downgrading to 1.1.7, I
just assumed that the previous version relative to 1.1.8-2 was 1.1.7-1.
I didn't remember that 1.1.8-1 was released.

The reason why your tar procedure failed was that the 1.1.8 DLL (i.e.,
cygwin1.dll) was locked in memory when you were trying to overwrite it
with the 1.1.7 version.  The only way that you will be successful is to
make sure that you have exited all Cygwin processes (including inetd,
if running) before you attempt to overwrite the DLL.  And, then use a
non-Cygwin (i.e., straight Win32) tool, to install the DLL.  The tool
to use is just Cygwin's setup.exe.

Use the following procedure:

    1. copy cygwin-1.1.7-1.tar.gz to an empty directory
    2. run Cygwin's setup.exe
    3. choose "Install from Local Directory"
    3. choose the directory used in step 1 for the "Local Package Directory"
    4. choose the defaults for the remainder of the dialogs

You have now downgraded to Cygwin 1.1.7.

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

Rolf,

On Thu, Feb 22, 2001 at 09:53:51AM +0100, bcs-brockmann.de wrote:
> I donwgrated to 1.1.7.
> Now I don't have errors with postmater but if I do createdb I get new error
> messages.
> Can you give me a combination which is working?
> I use now cygwin 1.1.7, cgipc 1.0.9 or 1.0.7, postgrsql 7.0.3.

I believe that the above combination should work.  Are you doing the
following:

    postmaster -i
    createdb -h localhost test

If using "-h localhost" does not solve your problem, then please post
your error messages.

Thanks,
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