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 1FEF2138825 for ; Mon, 10 Nov 2014 13:02:20 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 1B89FE096B; Mon, 10 Nov 2014 13:02:14 +0000 (UTC) Received: from mail-yh0-f53.google.com (mail-yh0-f53.google.com [209.85.213.53]) (using TLSv1 with cipher ECDHE-RSA-RC4-SHA (128/128 bits)) (No client certificate requested) by pigeon.gentoo.org (Postfix) with ESMTPS id DF353E094A for ; Mon, 10 Nov 2014 13:02:11 +0000 (UTC) Received: by mail-yh0-f53.google.com with SMTP id a41so1985026yho.12 for ; Mon, 10 Nov 2014 05:02:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=44Z6811OYJJZFx1gJLAy50HwgzeTIRgzq2P7yHbO7uY=; b=L2VwKTYCe2ZNjuCkc4RNY9ZeIDImrpLrybv/qybx+HiZOwFooI9A/Ap5xjt0cUsYSM PqEoxnU/+XYUcGpWC9XW5OtZoGVDTG+z5/iK6p58T4jDB2Ep6h2LBAqDX6rh59oL/H8r DSMBj+waVFsGlbzfH5K+dkYxak+Jr310d0jTztFxNdPxRIU1XNQ9can9hSzx2O98L/Ia nlY88iyjJ9NfPxXHh1IqaUQg8J5JS8gsnWKqeKViDXWERvHsaBF+RawGAGaxHDupDmRH mgLaQQKMVd890BYznCeymO3FcD9kaLX81ntpHO/6DLhQvsSra7/msy+T+MEK6qtRICyE WCQg== 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 X-Received: by 10.170.90.86 with SMTP id h83mr32101647yka.121.1415624530858; Mon, 10 Nov 2014 05:02:10 -0800 (PST) Received: by 10.170.131.138 with HTTP; Mon, 10 Nov 2014 05:02:10 -0800 (PST) In-Reply-To: <18342.1415624362@ccs.covici.com> 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> Date: Mon, 10 Nov 2014 18:02:10 +0500 Message-ID: Subject: Re: [gentoo-user] how to upgrade postgresql under gentoo From: Vladimir Romanov To: gentoo-user@lists.gentoo.org Content-Type: multipart/alternative; boundary=001a113911344c1d12050780c5a9 X-Archives-Salt: 1fc9e8cf-20f7-4aad-a08f-8662fcafbe97 X-Archives-Hash: 5dc14300077ceda72387ea3bdf56d0bc --001a113911344c1d12050780c5a9 Content-Type: text/plain; charset=UTF-8 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 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 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 again by > emerge > > > > =dev-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 is > all, 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 > problem. > > > > > > > > > > > > > > > > > > > > > Vladimir Romanov wrote: > > > > > > > > > > > > > > > Yes. You emerge both beta2 and beta3, then run pg_upgrade 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 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 > 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 question is: > How do > you spend it? > > John Covici > covici@ccs.covici.com > > --001a113911344c1d12050780c5a9 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Well, i think i understand what happens (through i am= not sure) - i was upgrading 9.3 to 9.4 - they're installed in differen= t slots, so i just istalled two postgresql's in one time. You are upgra= ding 9.4 to 9.4 - so they are in one slot and can not be installed in one t= ime.

But then yes, one can't upgrade the base.

2014-11-10 17:59 GM= T+05:00 <covici@ccs.covici.com>:
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.=C2=A0 I m not sure what happened to the .conf files in the old<= br> data directory, but they had not been there for quite a while, so maybe
this was a problem with the arlier beta.=C2=A0 Very strange but it looks good.

Thanks for your help.

Vladimir Romanov <blueboar2@gmail= .com> 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 versa)= ?
>
> 2014-11-10 16:47 GMT+05:00 <covici@ccs.covici.com>:
>
> > What it does then is delete the beta3 and give me only beta2.=C2= =A0 This is
> > what I had done to fix my original problem, I can show you the bu= ild log
> > for beta3 if that would help.=C2=A0 I am using gentoo-unstable, b= ut that
> > should be obvious.
> >
> > Vladimir Romanov <blueb= oar2@gmail.com> 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 <covici@ccs.covici.com>:
> > >
> > > > Well, after the emerge, no sign of beta2 anywhere, I ha= ve the directory
> > > > /usr/lib64/postgresql-9.4/=C2=A0 with the beta3 binarie= s and that is all, is
> > > > there a problem with the ebuilds or something?
> > > >
> > > > Vladimir Romanov <blueboar2@gmail.com> wrote:
> > > >
> > > > > Well, emerge it again :). You can have two postgre= sql-servers in
> > > > different
> > > > > slots.
> > > > >
> > > > > 2014-11-10 16:21 GMT+05:00 <covici@ccs.covici.com>:
> > > > >
> > > > > > However, when I emerge beta3, beta2 is gone, = so this is my problem.
> > > > > >
> > > > > >
> > > > > > Vladimir Romanov <blueboar2@gmail.com> wrote:
> > > > > >
> > > > > > > Yes. You emerge both beta2 and beta3, th= en run pg_upgrade for
> > beta3,
> > > > > > > provide BOTH binaries to it, it converts= the base. Then you can
> > > > delete
> > > > > > > beta2.
> > > > > > >
> > > > > > > 2014-11-10 16:04 GMT+05:00 <covici@ccs.covici.com>:
> > > > > > >
> > > > > > > > Hi.=C2=A0 I have a puzzle regarding= upgrading postgresql.=C2=A0 In my
> > recent
> > > > > > world
> > > > > > > > update I went from 9.4_beta2 to bet= a3, but when I tried to
> > start
> > > > the
> > > > > > > > server, it complained that the data= bases were written with a
> > > > different
> > > > > > > > "catalog version" -- what= ever that is, and the pg_upgrade tool
> > > > requires
> > > > > > > > both old and new binaries to actual= ly upgrade the database.
> > So as
> > > > a
> > > > > > > > temporary measure, I went back to b= eta2 and things worked
> > again.
> > > > So
> > > > > > > > what the heck are you supposed to d= o here, I like pg, but this
> > is
> > > > very
> > > > > > > > strange to me.
> > > > > > > >
> > > > > > > > Thanks in advance for any suggestio= ns.
> > > > > > > >
> > > > > > > > --
> > > > > > > > Your life is like a penny.=C2=A0 Yo= u're going to lose it.=C2=A0 The
> > question
> > > > is:
> > > > > > > > How do
> > > > > > > > you spend it?
> > > > > > > >
> > > > > > > >=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 J= ohn Covici
> > > > > > > >=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <= a href=3D"mailto:covici@ccs.covici.com">covici@ccs.covici.com
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > > ----------------------------------------= ------------
> > > > > > > Alternatives:
> > > > > > >
> > > > > > > ----------------------------------------= ------------
> > > > > >
> > > > > > --
> > > > > > Your life is like a penny.=C2=A0 You're g= oing to lose it.=C2=A0 The question
> > is:
> > > > > > How do
> > > > > > you spend it?
> > > > > >
> > > > > >=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 John Covici=
> > > > > >=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 covici@ccs.covici.com
> > > > > >
> > > > > >
> > > > >
> > > > > --------------------------------------------------= --
> > > > > Alternatives:
> > > > >
> > > > > --------------------------------------------------= --
> > > >
> > > > --
> > > > Your life is like a penny.=C2=A0 You're going to lo= se it.=C2=A0 The question is:
> > > > How do
> > > > you spend it?
> > > >
> > > >=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 John Covici
> > > >=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 covici@ccs.covici.com
> > > >
> > > >
> > >
> > > ----------------------------------------------------
> > > Alternatives:
> > >
> > > ----------------------------------------------------
> >
> > --
> > Your life is like a penny.=C2=A0 You're going to lose it.=C2= =A0 The question is:
> > How do
> > you spend it?
> >
> >=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 John Covici
> >=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 covici@ccs.covici.com
> >
> >
>
> ----------------------------------------------------
> Alternatives:
>
> ----------------------------------------------------

--
Your life is like a penny.=C2=A0 You're going to lose it.=C2=A0 The que= stion is:
How do
you spend it?

=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0John Covici
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= covici@ccs.covici.com


--001a113911344c1d12050780c5a9--