[gentoo-user] how to upgrade postgresql under gentoo

[gentoo-user] how to upgrade postgresql under gentoo

[covici]

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

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

[Vladimir Romanov]

[-- Attachment #1: Type: text/plain, Size: 936 bytes --]

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

[-- Attachment #2: Type: text/html, Size: 1426 bytes --]

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

[covici]

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

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

[Vladimir Romanov]

[-- Attachment #1: Type: text/plain, Size: 1607 bytes --]

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

[-- Attachment #2: Type: text/html, Size: 2507 bytes --]

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

[covici]

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

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

[Vladimir Romanov]

[-- Attachment #1: Type: text/plain, Size: 2561 bytes --]

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

[-- Attachment #2: Type: text/html, Size: 3961 bytes --]

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

[covici]

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

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

[Vladimir Romanov]

[-- Attachment #1: Type: text/plain, Size: 3788 bytes --]

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

[-- Attachment #2: Type: text/html, Size: 5980 bytes --]

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

[covici]

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

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

[Vladimir Romanov]

[-- Attachment #1: Type: text/plain, Size: 5498 bytes --]

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

[-- Attachment #2: Type: text/html, Size: 8727 bytes --]

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

[covici]

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

Vladimir Romanov <blueboar2@gmail.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@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
> >
> >
> 
> ----------------------------------------------------
> 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

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

[J. Roeleveld]

On Monday, November 10, 2014 08:06:50 AM covici@ccs.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@gmail.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@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
> > 
> > ----------------------------------------------------
> > Alternatives:
> > 
> > ----------------------------------------------------

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

[covici]

I thought gentoo would only give you versions of software that were
considered mainstream upstream, that the ~ was only for the ebuilds.

J. Roeleveld <joost@antarean.org> wrote:

> On Monday, November 10, 2014 08:06:50 AM covici@ccs.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@gmail.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@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
> > > 
> > > ----------------------------------------------------
> > > 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

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

[J. Roeleveld]

On Tuesday, November 11, 2014 06:26:02 AM covici@ccs.covici.com wrote:
> I thought gentoo would only give you versions of software that were
> considered mainstream upstream, that the ~ was only for the ebuilds.
> 
> J. Roeleveld <joost@antarean.org> wrote:
> > On Monday, November 10, 2014 08:06:50 AM covici@ccs.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
> > 

Please don't top-post.

The "~" is for the actual software. The ebuilds themselves, considering they 
are quite small, are generally bug-free.

--
Joost

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

[Michael Orlitzky]

On 11/10/2014 06:04 AM, covici@ccs.covici.com wrote:
> 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.
> 

pg_upgrade has always been a PITA for me. There's an easier way that
always works: run pg_dumpall, upgrade postgres, and then restore the
dump file.

If your databases are small enough, it's much less stressful, and it
works for major version bumps as well.

If you're worried about overwriting your data, you could always back up
the beta2 binary files, and then create empty databases under beta3
before restoring.

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

[covici]

Michael Orlitzky <mjo@gentoo.org> wrote:

> On 11/10/2014 06:04 AM, covici@ccs.covici.com wrote:
> > 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.
> > 
> 
> pg_upgrade has always been a PITA for me. There's an easier way that
> always works: run pg_dumpall, upgrade postgres, and then restore the
> dump file.
> 
> If your databases are small enough, it's much less stressful, and it
> works for major version bumps as well.
> 
> If you're worried about overwriting your data, you could always back up
> the beta2 binary files, and then create empty databases under beta3
> before restoring.

Thanks, maybe I will do that next time.

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

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

[Mick]

[-- Attachment #1: Type: Text/Plain, Size: 1518 bytes --]

On Monday 10 Nov 2014 13:16:25 covici@ccs.covici.com wrote:
> Michael Orlitzky <mjo@gentoo.org> wrote:
> > On 11/10/2014 06:04 AM, covici@ccs.covici.com wrote:
> > > 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.
> > 
> > pg_upgrade has always been a PITA for me. There's an easier way that
> > always works: run pg_dumpall, upgrade postgres, and then restore the
> > dump file.
> > 
> > If your databases are small enough, it's much less stressful, and it
> > works for major version bumps as well.
> > 
> > If you're worried about overwriting your data, you could always back up
> > the beta2 binary files, and then create empty databases under beta3
> > before restoring.
> 
> Thanks, maybe I will do that next time.

You may also want to file a bug?  There may be need for a elog pre-emerge 
message or some such for users to know how to deal with this in a gentoo 
system without tearing their hair out.

-- 
Regards,
Mick

[-- Attachment #2: This is a digitally signed message part. --]
[-- Type: application/pgp-signature, Size: 473 bytes --]