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

[J. Roeleveld]

On Monday, November 10, 2014 08:06:50 AM covici@××××××××××.com wrote:
> Then they should not change the catalog version -- what is that, anyway?

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 loosing 
your data.
I am not surprised that the layout of the on-disk storage changes between 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 <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:
> >
> > ----------------------------------------------------