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 9B7BA138825 for ; Tue, 11 Nov 2014 11:26:14 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 1D40FE0B8F; Tue, 11 Nov 2014 11:26:08 +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 B4437E0B82 for ; Tue, 11 Nov 2014 11:26:06 +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 sABBQ4l3024971 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=FAIL) for ; Tue, 11 Nov 2014 06:26:05 -0500 Received: from ccs.covici.com (localhost [127.0.0.1]) by ccs.covici.com (8.14.9/8.14.8) with ESMTP id sABBQ21p015394 for ; Tue, 11 Nov 2014 06:26:02 -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: <2624137.b62MZlq2mj@andromeda> References: <7984.1415617459@ccs.covici.com> <19424.1415624810@ccs.covici.com> <2624137.b62MZlq2mj@andromeda> Comments: In-reply-to "J. Roeleveld" message dated "Tue, 11 Nov 2014 08:24:38 +0100." 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: <15392.1415705162.1@ccs.covici.com> Content-Transfer-Encoding: quoted-printable Date: Tue, 11 Nov 2014 06:26:02 -0500 Message-ID: <15393.1415705162@ccs.covici.com> X-SpamH-OriginatingIP: 70.109.53.110 X-SpamH-Filter: d-out-001.smtp25.com-sABBQ4l3024971 X-Archives-Salt: da627dcd-b2a9-4906-9b0d-945c1628c7b7 X-Archives-Hash: f2871fa2758b660209c1c043169681f9 I thought gentoo would only give you versions of software that were considered mainstream upstream, that the ~ was only for the ebuilds. J. Roeleveld wrote: > On Monday, November 10, 2014 08:06:50 AM covici@ccs.covici.com wrote: > > Then they should not change the catalog version -- what is that, anywa= y? > = > You are using a Beta-version. Those are under development and NOT suited= for = > production. > If you use a beta-version of any software package, you run the risk of l= oosing = > your data. > I am not surprised that the layout of the on-disk storage changes betwee= n beta = > versions while the devs try to implement new functionality. > You might even have been running with an incompatible combination in the= = > previous beta. > = > -- > Joost > = > = > > 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 ju= st > > > 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= only > > > > problems, was that the old data directory did not contain any .con= f > > > > 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 look= s > > > > good. > > > > = > > > > Thanks for your help. > > > > = > > > > Vladimir Romanov wrote: > > > > > Well... then we need someone, who is more professional, since AF= AIK > > > > > multiple postgresql's can be on one system in several slots. May= be (as > > > > > it > > > > > 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 > > > > = > > > > log > > > > = > > > > > > 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 aga= in by > > > > = > > > > 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 th= at is > > > > = > > > > all, is > > > > = > > > > > > > > there a problem with the ebuilds or something? > > > > > > > > = > > > > > > > > Vladimir Romanov wrote: > > > > > > > > > Well, emerge it again :). You can have two postgresql-se= rvers > > > > > > > > > in > > > > > > > > = > > > > > > > > different > > > > > > > > = > > > > > > > > > slots. > > > > > > > > > = > > > > > > > > > 2014-11-10 16:21 GMT+05:00 : > > > > > > > > > > However, when I emerge beta3, beta2 is gone, so this i= s my > > > > = > > > > problem. > > > > = > > > > > > > > > > Vladimir Romanov wrote: > > > > > > > > > > > Yes. You emerge both beta2 and beta3, then run pg_up= grade > > > > > > > > > > > for > > > > > > = > > > > > > beta3, > > > > > > = > > > > > > > > > > > provide BOTH binaries to it, it converts the base. T= hen > > > > > > > > > > > you > > > > = > > > > can > > > > = > > > > > > > > delete > > > > > > > > = > > > > > > > > > > > beta2. > > > > > > > > > > > = > > > > > > > > > > > 2014-11-10 16:04 GMT+05:00 : > > > > > > > > > > > > Hi. I have a puzzle regarding upgrading postgresq= l. In > > > > > > > > > > > > my > > > > > > = > > > > > > 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 writ= ten > > > > > > > > > > > > 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 i= t. = > > > > > > > > > > > > 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 > > > > > > > = > > > > > > > ---------------------------------------------------- > > > > > > > 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