From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from lists.gentoo.org (pigeon.gentoo.org [208.92.234.80]) by finch.gentoo.org (Postfix) with ESMTP id 25B3B138825 for ; Mon, 10 Nov 2014 12:59:33 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 74807E0924; Mon, 10 Nov 2014 12:59:26 +0000 (UTC) Received: from mail0131.smtp25.com (mail0131.smtp25.com [75.126.84.131]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by pigeon.gentoo.org (Postfix) with ESMTPS id 51BD4E0914 for ; Mon, 10 Nov 2014 12:59:25 +0000 (UTC) Received: from ccs.covici.com (s-out-001.smtp25.com [67.228.91.90]) by d-out-001.smtp25.com (8.14.2/8.14.2) with ESMTP id sAACxNXm026326 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=FAIL) for ; Mon, 10 Nov 2014 07:59:24 -0500 Received: from ccs.covici.com (localhost [127.0.0.1]) by ccs.covici.com (8.14.9/8.14.8) with ESMTP id sAACxMZS018343 for ; Mon, 10 Nov 2014 07:59:22 -0500 From: covici@ccs.covici.com To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] how to upgrade postgresql under gentoo In-reply-to: References: <7984.1415617459@ccs.covici.com> <10997.1415618516@ccs.covici.com> <5306.1415619400@ccs.covici.com> <7502.1415620054@ccs.covici.com> Comments: In-reply-to Vladimir Romanov message dated "Mon, 10 Nov 2014 16:50:40 +0500." X-Mailer: MH-E 8.6; nmh 1.6; GNU Emacs 24.4.1 Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <18340.1415624362.1@ccs.covici.com> Content-Transfer-Encoding: quoted-printable Date: Mon, 10 Nov 2014 07:59:22 -0500 Message-ID: <18342.1415624362@ccs.covici.com> X-SpamH-OriginatingIP: 70.109.53.110 X-SpamH-Filter: d-out-001.smtp25.com-sAACxNXm026326 X-Archives-Salt: 29d8af0b-d027-46da-b6af-54c6e0cfe3ce X-Archives-Hash: ce96dbc5238819bb4eec7fc7698b8357 Well, I found the old binaries in my backups and did the deed, the only problems, was that the old data directory did not contain any .conf files, so I copied the new ones into the old data directory and it was then happy. I m not sure what happened to the .conf files in the old data directory, but they had not been there for quite a while, so maybe this was a problem with the arlier beta. Very strange but it looks good. Thanks for your help. Vladimir Romanov wrote: > Well... then we need someone, who is more professional, since AFAIK > multiple postgresql's can be on one system in several slots. Maybe (as i= t > is beta, slots are the same, therefore new deletes old and vice versa)? > = > 2014-11-10 16:47 GMT+05:00 : > = > > What it does then is delete the beta3 and give me only beta2. This is > > what I had done to fix my original problem, I can show you the build l= og > > for beta3 if that would help. I am using gentoo-unstable, but that > > should be obvious. > > > > Vladimir Romanov wrote: > > > > > You updated your beta2 with beta3. Now you can add beta2 again by em= erge > > > =3Ddev-db/posgresql-9.4-beta2 (or something like) > > > > > > 2014-11-10 16:36 GMT+05:00 : > > > > > > > Well, after the emerge, no sign of beta2 anywhere, I have the dire= ctory > > > > /usr/lib64/postgresql-9.4/ with the beta3 binaries and that is al= l, is > > > > there a problem with the ebuilds or something? > > > > > > > > Vladimir Romanov wrote: > > > > > > > > > Well, emerge it again :). You can have two postgresql-servers in > > > > different > > > > > slots. > > > > > > > > > > 2014-11-10 16:21 GMT+05:00 : > > > > > > > > > > > However, when I emerge beta3, beta2 is gone, so this is my pro= blem. > > > > > > > > > > > > > > > > > > Vladimir Romanov wrote: > > > > > > > > > > > > > Yes. You emerge both beta2 and beta3, then run pg_upgrade fo= r > > beta3, > > > > > > > provide BOTH binaries to it, it converts the base. Then you = can > > > > delete > > > > > > > beta2. > > > > > > > > > > > > > > 2014-11-10 16:04 GMT+05:00 : > > > > > > > > > > > > > > > Hi. I have a puzzle regarding upgrading postgresql. In m= y > > recent > > > > > > world > > > > > > > > update I went from 9.4_beta2 to beta3, but when I tried to > > start > > > > the > > > > > > > > server, it complained that the databases were written with= a > > > > different > > > > > > > > "catalog version" -- whatever that is, and the pg_upgrade = tool > > > > requires > > > > > > > > both old and new binaries to actually upgrade the database= . > > So as > > > > a > > > > > > > > temporary measure, I went back to beta2 and things worked > > again. > > > > So > > > > > > > > what the heck are you supposed to do here, I like pg, but = this > > is > > > > very > > > > > > > > strange to me. > > > > > > > > > > > > > > > > Thanks in advance for any suggestions. > > > > > > > > > > > > > > > > -- > > > > > > > > Your life is like a penny. You're going to lose it. The > > question > > > > is: > > > > > > > > How do > > > > > > > > you spend it? > > > > > > > > > > > > > > > > John Covici > > > > > > > > covici@ccs.covici.com > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ---------------------------------------------------- > > > > > > > Alternatives: > > > > > > > > > > > > > > ---------------------------------------------------- > > > > > > > > > > > > -- > > > > > > Your life is like a penny. You're going to lose it. The ques= tion > > is: > > > > > > How do > > > > > > you spend it? > > > > > > > > > > > > John Covici > > > > > > covici@ccs.covici.com > > > > > > > > > > > > > > > > > > > > > > ---------------------------------------------------- > > > > > Alternatives: > > > > > > > > > > ---------------------------------------------------- > > > > > > > > -- > > > > Your life is like a penny. You're going to lose it. The question= is: > > > > How do > > > > you spend it? > > > > > > > > John Covici > > > > covici@ccs.covici.com > > > > > > > > > > > > > > ---------------------------------------------------- > > > Alternatives: > > > > > > ---------------------------------------------------- > > > > -- > > Your life is like a penny. You're going to lose it. The question is: > > How do > > you spend it? > > > > John Covici > > covici@ccs.covici.com > > > > > = > ---------------------------------------------------- > Alternatives: > = > ---------------------------------------------------- -- = Your life is like a penny. You're going to lose it. The question is: How do you spend it? John Covici covici@ccs.covici.com