Re: [gentoo-user] how to upgrade postgresql under gentoo

Then they should not change the catalog version -- what is that, anyway?

Vladimir Romanov <blueboar2@×××××.com> 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 <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.  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 <blueboar2@×××××.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@××××××××××.com>:
> > >
> > > > 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 <blueboar2@×××××.com> 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 <covici@××××××××××.com>:
> > > > >
> > > > > > 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 <blueboar2@×××××.com> wrote:
> > > > > >
> > > > > > > Well, emerge it again :). You can have two postgresql-servers in
> > > > > > different
> > > > > > > slots.
> > > > > > >
> > > > > > > 2014-11-10 16:21 GMT+05:00 <covici@××××××××××.com>:
> > > > > > >
> > > > > > > > However, when I emerge beta3, beta2 is gone, so this is my
> > problem.
> > > > > > > >
> > > > > > > >
> > > > > > > > Vladimir Romanov <blueboar2@×××××.com> 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 <covici@××××××××××.com>:
> > > > > > > > >
> > > > > > > > > > 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@××××××××××.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@××××××××××.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@××××××××××.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@××××××××××.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@××××××××××.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@××××××××××.com