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

[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.  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@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.  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@gmail.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@ccs.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@gmail.com> wrote:
> > > >
> > > > > Well, emerge it again :). You can have two postgresql-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, 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@ccs.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@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