DomainKey-Signature: a=rsa-sha1; c=nofws; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:message-id:date:from:mime-version:to:subject
	:references:in-reply-to:content-type; q=dns; s=default; b=WDjzmv
	aAxNf+vPvjs0RCpnFnA1NfUmZoHrIPisF/82Ekz8KZZYQE3dBAhZlQ0BLc1Qw+OH
	RpGmS5ri63A2ccqRtgjW58QmBV+rsE5E63A97TqVGHiKghVOiP9g0+YBWR5QyuQE
	sOyoIIcfi+nBH7GRTaZAbhULbsz40EHjuPmZc=
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Message-ID: <5702C4B3.3030506@oliveyou.net>
Date: Mon, 04 Apr 2016 15:46:59 -0400
From: Chloe <starrychloe AT oliveyou DOT net>
User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:31.0) Gecko/20100101 Thunderbird/31.7.0
MIME-Version: 1.0
To: cygwin AT cygwin DOT com
Subject: Re: postgresql - How do I upgrade Postgres database in Cygwin? - Server Fault
References: <5702BCFD DOT 6000103 AT oliveyou DOT net>
In-Reply-To: <5702BCFD.6000103@oliveyou.net>
Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="79a1KgU3hm5ojmibrQXnfGPL4uUAE2p0j"

--79a1KgU3hm5ojmibrQXnfGPL4uUAE2p0j
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

OK now I really need help. I tried to install version 9.4.4-2 of
Postgres with
ftp://www.fruitbat.org/pub/cygwin/circa/2015/09/25/151012/index.html,
but now it won't start. I also tried to install 9.4.4-1 but that won't
work either. I also tried to exit all Cygwin processes and run 'dash'
and 'rebaseall', but it didn't help. How do I install an old version of
Postgres 9.4 to upgrade to 9.5?

$ /usr/sbin/postgres --version
postgres (PostgreSQL) 9.4.4

$ /usr/sbin/postgres
FATAL:  could not create shared memory segment: Function not implemented
DETAIL:  Failed system call was shmget(key=3D5432001, size=3D40, 03600).

$ /setup-x86 -X -q -P postgresql-9.4.4-1
note: Hand installation over to elevated child process.

$ /usr/sbin/postgres --version
postgres (PostgreSQL) 9.4.4

$ /usr/sbin/postgres
FATAL:  could not create shared memory segment: Function not implemented
DETAIL:  Failed system call was shmget(key=3D5432001, size=3D40, 03600).

http://stackoverflow.com/questions/36411485/how-do-i-install-postgres-9-4-o=
n-cygwin


On 4/4/2016 3:19 PM, Chloe wrote:
> Can you please change the Postgres packages to use postgres94,
> postgres95, postgres96, etc. names? Each version is incompatible with
> the previous. This will allow installing Postgres in separate binary
> directories to enable upgrades. Alternatively, please increase the
> 'previous version' history to allow installing old versions. Setup
> only has 1 previous version, and if the current version is 9.5.2 and
> the previous version is 9.5.1, then there is no way (or very
> difficult) to install 9.4!
>
> http://serverfault.com/questions/532379/how-do-i-upgrade-postgres-databas=
e-in-cygwin
>


--79a1KgU3hm5ojmibrQXnfGPL4uUAE2p0j
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iQEcBAEBAgAGBQJXAsS5AAoJELnoxrp+RV2iiHYH/0Q/wSnjFiKZQMLLNKVM8j2H
nn5ABbDj//q1TsR9sVDC9QfD63V4Q2Wo2PTUoYJTNdEmDU0we5JweM0l63fEGgdD
TCE27aVL8cbMMD2EudfQSSUNdA4bjD1Jkt++k0ibbBa+YyD9lTOMA563XRW88yq8
TaGtO3/mBnAhl4mFSB6IVFjmFJjV3q0hfUsvqbRFOf7h7tuGQwQzQM01c4tAmo00
kHgLW1uKd4ZFOCFUfBNqvOi+rHkZZWINlmKhv600sw0nKufLudk6FItd+B4zCsw6
EoRVHjYIdZJBCCPAPPi0kjir09iBKIY2K5RCHwdcVa8sz409EpX+weTSwSuZ2XE=
=dTq9
-----END PGP SIGNATURE-----

--79a1KgU3hm5ojmibrQXnfGPL4uUAE2p0j--