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:content-transfer-encoding; q=dns; s=default; b=QdGYiHdNgD5MAti+6Fftc4AK5mwuC13G6a4fvb3z5tx tTk/IsSMdDBvAQKQh8KoniAwCzuhD1ZyzV4+pE+GULfOgP31v3fjYfNU3MD08mX7 mQHr+08mcqbMIg3vOF/YVkZPPN7bqm4fuw6wKC4ZfDoIQh3fyvWzHI2JTloZngo4 = 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:content-transfer-encoding; s=default; bh=VVuFPdROjcCO+Zirldta+USWFc0=; b=g4zsJ15m1nYgMflzb clU84/J/6601GDFJHCVprbbhi1Ex7Pj20YIFRPvFCdBI5VXReaWc57z+6wVzG7ZA E54cwDDERNSjhmZV7lZUXelG+KkBY0UVXo5JdhTu8eOADln3VyW3DBHyxJyTfo1G nERIN9wVIeiot+2oMz5hVKCPuQ= Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm List-Id: List-Subscribe: List-Archive: List-Post: List-Help: , Sender: cygwin-owner AT cygwin DOT com Mail-Followup-To: cygwin AT cygwin DOT com Delivered-To: mailing list cygwin AT cygwin DOT com X-Spam-SWARE-Status: No, score=-3.8 required=5.0 tests=AWL,BAYES_00,FREEMAIL_FROM,KHOP_THREADED,RCVD_IN_DNSWL_LOW,RCVD_IN_HOSTKARMA_YE,SPF_PASS autolearn=ham version=3.3.2 X-Received: by 10.14.176.8 with SMTP id a8mr8977014eem.12.1377076046396; Wed, 21 Aug 2013 02:07:26 -0700 (PDT) Message-ID: <5214834C.6090004@gmail.com> Date: Wed, 21 Aug 2013 11:07:24 +0200 From: marco atzeri User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20130801 Thunderbird/17.0.8 MIME-Version: 1.0 To: cygwin AT cygwin DOT com Subject: Re: How do I upgrade Postgres database in Cygwin? References: <5213A59B DOT 7040107 AT oliveyou DOT net> In-Reply-To: <5213A59B.7040107@oliveyou.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Il 8/20/2013 7:27 PM, Chloe ha scritto: > I updated some Cygwin packages and now I can't start Postgres: > > $ /usr/sbin/postmaster > FATAL: database files are incompatible with server > DETAIL: The data directory was initialized by PostgreSQL version > 8.2, which is not compatible with this version 9.2.4. > > I tried > [pg_upgrade](http://www.postgresql.org/docs/9.2/static/pgupgrade.html) > but you need to specify both the old and new binary. Plus, pg_upgrade > says it only works with 8.3. > > I thought I could use setup-x86.exe to pick the previous version, which > is 8.2.11-1, however when I install that, then I can't start Postgres: > > > $ /usr/sbin/postgres.exe > Bad system call (core dumped) > you need cygserver running as service -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple