Thread: Updated Cygwin Package: postgresql-7.3.1-1

Updated Cygwin Package: postgresql-7.3.1-1

From
Jason Tishler
Date:
New News:
=== ====
I have updated the version of PostgreSQL to 7.3.1-1.  The tarballs should
be available on a Cygwin mirror near you shortly.

Old News:
=== ====
PostgreSQL is an open-source, Object-Relational DBMS.  If interested,
see the PostgreSQL web site for more details:

    http://www.postgresql.org/

Please read the README file:

    /usr/doc/Cygwin/postgresql-7.3.1.README

since it covers requirements, installation, known issues, etc.

To update your installation, click on the "Install Cygwin now" link on
the http://cygwin.com/ web page.  This downloads setup.exe to your
system.  Then, run setup and answer all of the questions.

Note that we have recently stopped downloads from sources.redhat.com
(aka cygwin.com) due to bandwidth limitations.  This means that you will
need to find a mirror which has this update.

In the US,
ftp://mirrors.rcn.net/mirrors/sources.redhat.com/cygwin/
is a reliable high bandwidth connection.

In Germany,
ftp://ftp.uni-erlangen.de/pub/pc/gnuwin32/cygwin/mirrors/cygnus/
is usually pretty good.

In the UK,
http://programming.ccp14.ac.uk/ftp-mirror/programming/cygwin/pub/cygwin/
is usually up-to-date within 48 hours.

If one of the above doesn't have the latest version of this package
then you can either wait for the site to be updated or find another
mirror.

The setup.exe program will figure out what needs to be updated on your
system and will install newer packages automatically.

If you have questions or comments, please send them to the Cygwin
mailing list at: cygwin@cygwin.com .  I would appreciate if you would
use this mailing list rather than emailing me directly.  This includes
ideas and comments about the setup utility or Cygwin in general.

If you want to make a point or ask a question, the Cygwin mailing list
is the appropriate place.

              *** CYGWIN-ANNOUNCE UNSUBSCRIBE INFO ***

If you want to unsubscribe from the cygwin-announce mailing list, look
at the "List-Unsubscribe: " tag in the email header of this message.
Send email to the address specified there.  It will be in the format:

cygwin-announce-unsubscribe-you=yourdomain.com@cygwin.com

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

How to solve error IpcSemaphoreCreate in Cygwin

From
"Cornelia Boenigk"
Date:
Hello All

When trying to start postmaster (7.3.1) the following error occurs:

IpcSemaphoreCreate: semget(key=5432083, num=17, 03600) failed: No space
left on device

This error does *not* mean that you have run out of disk space.

It occurs when either the system limit for the maximum number of semaphore
sets (SEMMNI), or the system wide maximum number of semaphores (SEMMNS),
would be exeeded. You need to raise the respective kernel parameter.
...

How can I change the kernel parameters in Cygwin? Or is there any other
solution to this problem?

Tanks in advance
Conni


Re: How to solve error IpcSemaphoreCreate in Cygwin

From
Justin Clift
Date:
Cornelia Boenigk wrote:
> Hello All
>
> When trying to start postmaster (7.3.1) the following error occurs:
>
> IpcSemaphoreCreate: semget(key=5432083, num=17, 03600) failed: No space
> left on device
>
> This error does *not* mean that you have run out of disk space.
>
> It occurs when either the system limit for the maximum number of semaphore
> sets (SEMMNI), or the system wide maximum number of semaphores (SEMMNS),
> would be exeeded. You need to raise the respective kernel parameter.
> ...
>
> How can I change the kernel parameters in Cygwin? Or is there any other
> solution to this problem?

Hi Connie,

You need to take a look at the file called postgresql-7.3.1.README in:

\usr\doc\Cygwin\

It explains what causes this problem, and how to download cygipc to get
around it.  With the present version of PostgreSQL 7.3.1 in the cygwin
distribution, using cygipc 1.13-2 does work, but version 1.11-x doesn't.

Hope that helps.

:-)

Regards and best wishes,

Justin Clift


> Tanks in advance
> Conni
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly


--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi


Re: How to solve error IpcSemaphoreCreate in Cygwin

From
"Cornelia Boenigk"
Date:
Hi alltogehter

A new installation of PostgreSQL (with the latest Cygipc;-) didn't solve
the problem. initdb was running successfully but the database cannot be
started. This occurs with win2k, with NT everything is working fine. See
the attachement for the error messages.

Does anybody have an idea?

Greetings
Conni
--
Datenbanklösungen + PostgreSQL + Webdesign
http://www.cornelia-boenigk.de | http://www.pgsql.info
http://www.dpunkt.de/buch/3-89864-175-9.html

Attachment