From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 85052 invoked by alias); 4 Apr 2016 19:47:09 -0000 Mailing-List: contact cygwin-help@cygwin.com; run by ezmlm Precedence: bulk List-Id: List-Subscribe: List-Archive: List-Post: List-Help: , Sender: cygwin-owner@cygwin.com Mail-Followup-To: cygwin@cygwin.com Received: (qmail 85036 invoked by uid 89); 4 Apr 2016 19:47:08 -0000 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 Received: from smtpb.spamarrest.com (HELO smtpb.spamarrest.com) (74.86.119.220) by sourceware.org (qpsmtpd/0.93/v0.84-503-g423c35a) with (AES256-SHA encrypted) ESMTPS; Mon, 04 Apr 2016 19:46:58 +0000 Received: from [192.168.16.105] (localhost.localdomain [127.0.0.1]) (Authenticated sender: starrychloe) by smtpb.spamarrest.com (Postfix) with ESMTPA id A4E18FBC16B for ; Mon, 4 Apr 2016 14:46:56 -0500 (CDT) Message-ID: <5702C4B3.3030506@oliveyou.net> Date: Mon, 04 Apr 2016 19:47:00 -0000 From: Chloe 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@cygwin.com Subject: Re: postgresql - How do I upgrade Postgres database in Cygwin? - Server Fault References: <5702BCFD.6000103@oliveyou.net> In-Reply-To: <5702BCFD.6000103@oliveyou.net> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="79a1KgU3hm5ojmibrQXnfGPL4uUAE2p0j" X-SW-Source: 2016-04/txt/msg00070.txt.bz2 --79a1KgU3hm5ojmibrQXnfGPL4uUAE2p0j Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Content-length: 1675 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" Content-length: 473 -----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--