Postgres Pro
Downloads
Home   >   mailing lists

Thread: Cygwin-Postgres-IpcMemoryCreate - Function not implemented

Cygwin-Postgres-IpcMemoryCreate - Function not implemented

From
Martin_Hurst@dom.com
Date:
I'm getting this error message when attempting to start postgresql:

$ postmaster -D /usr/share/postgresql/data/ &
[1] 2624

hurstm2@HURST-MARTI36 /
$ IpcMemoryCreate: shmget(key=5432001, size=1441792, 03600) failed:
Function not
 implemented

I'm running under a Cygwin window, on a Windows XP operating systems, 256
MB ram, 1Ghz Intel processor, with over 4Gb free disk space on my local
drive.
I was able to run postgresql successfully for several weeks up to now, in
this environment.

I have been experimenting with large tables, and had added 4 million rows
to a particular table.
Postgresql was still working fine up to this point.
Then I added another 4 millions rows to that same table, and also ran the
"vacuum analyze" utility afterwards successfully.
This now made the table contain 8 million rows.
I shutdown the postgresql database, and exited the cygwin window.

The next day, I got the above error message.
Is this something to do with having large tables, I'm not sure.

Anybody with ideas to correct this error condition.

Thanks,
-Martin

Re: Cygwin-Postgres-IpcMemoryCreate - Function not implemented

From
Jason Tishler
Date:
Martin,

On Mon, Dec 16, 2002 at 10:14:15AM -0500, Martin_Hurst@dom.com wrote:
> Anybody with ideas to correct this error condition.

Upgrade PostgreSQL recently?  If so, then 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: Cygwin-Postgres-IpcMemoryCreate - Function not implemented

From
Fred Yankowski
Date:
On Mon, Dec 16, 2002 at 10:34:57AM -0500, Jason Tishler wrote:
> Upgrade PostgreSQL recently?  If so, then please read the README:
>     http://www.tishler.net/jason/software/postgresql/postgresql-7.3.README

And note that the included statement "the first step is to install the
latest cygipc" is not just a suggestion -- the latest versions of
PostgreSQL for Cygwin _must_ have the latest cygipc installed or they
will fail exactly as Martin reported.


--
Fred Yankowski      fred@ontosys.com           tel: +1.630.879.1312
OntoSys, Inc        PGP keyID: 7B449345        fax: +1.630.879.1370
www.ontosys.com     38W242 Deerpath Rd, Batavia, IL 60510-9461, USA