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

[Vladimir Romanov]

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
>
>