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 82B0C138825 for ; Mon, 10 Nov 2014 13:07:00 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id D8179E0971; Mon, 10 Nov 2014 13:06:53 +0000 (UTC) Received: from mail0200.smtp25.com (mail0200.smtp25.com [174.37.170.200]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by pigeon.gentoo.org (Postfix) with ESMTPS id 7409BE08FF for ; Mon, 10 Nov 2014 13:06:52 +0000 (UTC) Received: from ccs.covici.com (s-out-001.smtp25.com [67.228.91.90]) by s-out-001.smtp25.com (8.14.2/8.14.2) with ESMTP id sAAD6oZS012151 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=FAIL) for ; Mon, 10 Nov 2014 08:06:51 -0500 Received: from ccs.covici.com (localhost [127.0.0.1]) by ccs.covici.com (8.14.9/8.14.8) with ESMTP id sAAD6oRY019425 for ; Mon, 10 Nov 2014 08:06:50 -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> <18342.1415624362@ccs.covici.com> Comments: In-reply-to Vladimir Romanov message dated "Mon, 10 Nov 2014 18:02:10 +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: <19423.1415624810.1@ccs.covici.com> Content-Transfer-Encoding: quoted-printable Date: Mon, 10 Nov 2014 08:06:50 -0500 Message-ID: <19424.1415624810@ccs.covici.com> X-SpamH-OriginatingIP: 70.109.53.110 X-SpamH-Filter: s-out-001.smtp25.com-sAAD6oZS012151 X-Archives-Salt: ab7df20d-f644-4f31-a591-6127b8e91afa X-Archives-Hash: 201d7554836f43f500d14c25fd7f497a Then they should not change the catalog version -- what is that, anyway? Vladimir Romanov wrote: > Well, i think i understand what happens (through i am not sure) - i was > upgrading 9.3 to 9.4 - they're installed in different slots, so i just > istalled two postgresql's in one time. You are upgrading 9.4 to 9.4 - so > they are in one slot and can not be installed in one time. > = > But then yes, one can't upgrade the base. > = > 2014-11-10 17:59 GMT+05:00 : > = > > Well, I found the old binaries in my backups and did the deed, the onl= y > > 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 mayb= e > > 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 it > > > is beta, slots are the same, therefore new deletes old and vice vers= a)? > > > > > > 2014-11-10 16:47 GMT+05:00 : > > > > > > > What it does then is delete the beta3 and give me only beta2. Thi= s is > > > > what I had done to fix my original problem, I can show you the bui= ld > > log > > > > for beta3 if that would help. I am using gentoo-unstable, but tha= t > > > > should be obvious. > > > > > > > > Vladimir Romanov wrote: > > > > > > > > > You updated your beta2 with beta3. Now you can add beta2 again b= y > > emerge > > > > > =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 > > directory > > > > > > /usr/lib64/postgresql-9.4/ with the beta3 binaries and that i= s > > all, is > > > > > > there a problem with the ebuilds or something? > > > > > > > > > > > > Vladimir Romanov wrote: > > > > > > > > > > > > > Well, emerge it again :). You can have two postgresql-server= s in > > > > > > different > > > > > > > slots. > > > > > > > > > > > > > > 2014-11-10 16:21 GMT+05:00 : > > > > > > > > > > > > > > > However, when I emerge beta3, beta2 is gone, so this is my > > problem. > > > > > > > > > > > > > > > > > > > > > > > > Vladimir Romanov wrote: > > > > > > > > > > > > > > > > > Yes. You emerge both beta2 and beta3, then run pg_upgrad= e for > > > > 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 my > > > > recent > > > > > > > > world > > > > > > > > > > update I went from 9.4_beta2 to beta3, but when I trie= d to > > > > start > > > > > > the > > > > > > > > > > server, it complained that the databases were written = with > > a > > > > > > different > > > > > > > > > > "catalog version" -- whatever that is, and the pg_upgr= ade > > tool > > > > > > requires > > > > > > > > > > both old and new binaries to actually upgrade the data= base. > > > > So as > > > > > > a > > > > > > > > > > temporary measure, I went back to beta2 and things wor= ked > > > > 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 > > 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