X-Recipient:	archive-cygwin AT delorie DOT com
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=
DKIM-Signature:	v=1; a=rsa-sha1; c=relaxed; 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; s=default; bh=yHPQnoFIJ5Jy
	2BUdtvorweKNR9s=; b=FYmqxS185mMfOFYyycqTRzan/duz8mrpPspIrWp9vVrN
	dBqdFCyU5OydE+RG7kITc6dULJVHlRktrMQO1m26Xa+mcmLu7p08srJzE6NqDGm6
	QshBUuUyGsKOy/zMyj4pvWq1KYRF70vZHOBCq0rjggE4r2ebyLbgLsjiYntG6n8=
Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id:	<cygwin.cygwin.com>
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sourceware.org/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com
Authentication-Results:	sourceware.org; auth=none
X-Virus-Found:	No
X-Spam-SWARE-Status:	No, score=0.7 required=5.0 tests=AWL,BAYES_00,RCVD_IN_DNSWL_LOW,SPF_PASS autolearn=ham version=3.3.2 spammy=951, 94, circa, 95
X-HELO:	smtpb.spamarrest.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>

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

- Raw text -