pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Migration Between Releases
9+ messages / 6 participants
[nested] [flat]

* Migration Between Releases
@ 2007-08-15 14:20 George Wilk <gwilk@ellacoya.com>
  2007-08-15 14:30 ` Re: Migration Between Releases Milen A. Radev <milen@radev.net>
  2007-08-15 14:44 ` Re: Migration Between Releases Peter Eisentraut <peter_e@gmx.net>
  2007-08-15 15:41 ` Re: Migration Between Releases Alvaro Herrera <alvherre@commandprompt.com>
  0 siblings, 3 replies; 9+ messages in thread

From: George Wilk @ 2007-08-15 14:20 UTC (permalink / raw)
  To: pgsql-admin

Could someone clarify the database dump/restore requirement for postgres
upgrades between major releases?

The online help chapter "23.5. Migration Between Releases" states that:

 

As a general rule, the internal data storage format is subject to change
between major releases of PostgreSQL (where the number after the first dot
changes). This does not apply to different minor releases under the same
major release (where the number after the second dot changes); these always
have compatible storage formats. For example, releases 7.2.1, 7.3.2, and 7.4
are not compatible, whereas 7.2.1 and 7.2.2 are.

 

I thought that the major release was the first number in the versioning
schema, the second represented minor release, and the third would be the
maintenance release or revision number (i.e. 8.2.4).  I need to understand
this better for the sake of writing install scripts for my own Solaris
packages.  Originally, my scripts were checking for the difference in the
major release between the output of "postgres -version" and PG_VERSION file,
looking at the first module of the versioning schema (i.e. 8 in "8.2.4").
Is this still true, or should I be checking the minor release as well?

 

Thanks in advance,

~george

^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Migration Between Releases
  2007-08-15 14:20 Migration Between Releases George Wilk <gwilk@ellacoya.com>
@ 2007-08-15 14:30 ` Milen A. Radev <milen@radev.net>
  2 siblings, 0 replies; 9+ messages in thread

From: Milen A. Radev @ 2007-08-15 14:30 UTC (permalink / raw)
  To: pgsql-admin

George Wilk написа:
> Could someone clarify the database dump/restore requirement for postgres
> upgrades between major releases?
> 
> The online help chapter "23.5. Migration Between Releases" states that:
> 
>  
> 
> As a general rule, the internal data storage format is subject to change
> between major releases of PostgreSQL (where the number after the first dot
> changes). This does not apply to different minor releases under the same
> major release (where the number after the second dot changes); these always
> have compatible storage formats. For example, releases 7.2.1, 7.3.2, and 7.4
> are not compatible, whereas 7.2.1 and 7.2.2 are.
> 
>  
> 
> I thought that the major release was the first number in the versioning
> schema, the second represented minor release, and the third would be the
> maintenance release or revision number (i.e. 8.2.4).  I need to understand
> this better for the sake of writing install scripts for my own Solaris
> packages.  Originally, my scripts were checking for the difference in the
> major release between the output of "postgres -version" and PG_VERSION file,
> looking at the first module of the versioning schema (i.e. 8 in "8.2.4").
> Is this still true, or should I be checking the minor release as well?

http://www.postgresql.org/support/versioning


-- 
Milen A. Radev




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Migration Between Releases
  2007-08-15 14:20 Migration Between Releases George Wilk <gwilk@ellacoya.com>
@ 2007-08-15 14:44 ` Peter Eisentraut <peter_e@gmx.net>
  2007-08-15 14:52   ` Re: Migration Between Releases George Wilk <gwilk@ellacoya.com>
  2 siblings, 1 reply; 9+ messages in thread

From: Peter Eisentraut @ 2007-08-15 14:44 UTC (permalink / raw)
  To: pgsql-admin; +Cc: George Wilk <gwilk@ellacoya.com>

Am Mittwoch, 15. August 2007 16:20 schrieb George Wilk:
> I thought that the major release was the first number in the versioning
> schema, the second represented minor release, and the third would be the
> maintenance release or revision number (i.e. 8.2.4).

You thought wrong then.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Migration Between Releases
  2007-08-15 14:20 Migration Between Releases George Wilk <gwilk@ellacoya.com>
  2007-08-15 14:44 ` Re: Migration Between Releases Peter Eisentraut <peter_e@gmx.net>
@ 2007-08-15 14:52   ` George Wilk <gwilk@ellacoya.com>
  2007-08-15 15:13     ` Re: Migration Between Releases Peter Eisentraut <peter_e@gmx.net>
  2007-08-15 15:54     ` Re: Migration Between Releases Scott Marlowe <scott.marlowe@gmail.com>
  0 siblings, 2 replies; 9+ messages in thread

From: George Wilk @ 2007-08-15 14:52 UTC (permalink / raw)
  To: 'Peter Eisentraut' <peter_e@gmx.net>; pgsql-admin

Hi Peter, thanks for your helpful and kind reply.  It certainly clears a lot
of smoke...  In the future you might consider including links to relevant
information.

-----Original Message-----
From: Peter Eisentraut [mailto:peter_e@gmx.net] 
Sent: Wednesday, August 15, 2007 10:44 AM
To: pgsql-admin@postgresql.org
Cc: George Wilk
Subject: Re: [ADMIN] Migration Between Releases

Am Mittwoch, 15. August 2007 16:20 schrieb George Wilk:
> I thought that the major release was the first number in the versioning
> schema, the second represented minor release, and the third would be the
> maintenance release or revision number (i.e. 8.2.4).

You thought wrong then.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/





^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Migration Between Releases
  2007-08-15 14:20 Migration Between Releases George Wilk <gwilk@ellacoya.com>
  2007-08-15 14:44 ` Re: Migration Between Releases Peter Eisentraut <peter_e@gmx.net>
  2007-08-15 14:52   ` Re: Migration Between Releases George Wilk <gwilk@ellacoya.com>
@ 2007-08-15 15:13     ` Peter Eisentraut <peter_e@gmx.net>
  2007-08-15 15:30       ` Re: Migration Between Releases George Wilk <gwilk@ellacoya.com>
  1 sibling, 1 reply; 9+ messages in thread

From: Peter Eisentraut @ 2007-08-15 15:13 UTC (permalink / raw)
  To: George Wilk <gwilk@ellacoya.com>; +Cc: pgsql-admin

Am Mittwoch, 15. August 2007 16:52 schrieb George Wilk:
> Hi Peter, thanks for your helpful and kind reply.  It certainly clears a
> lot of smoke...  In the future you might consider including links to
> relevant information.

You posted the relevant information yourself.  You just need to believe it.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Migration Between Releases
  2007-08-15 14:20 Migration Between Releases George Wilk <gwilk@ellacoya.com>
  2007-08-15 14:44 ` Re: Migration Between Releases Peter Eisentraut <peter_e@gmx.net>
  2007-08-15 14:52   ` Re: Migration Between Releases George Wilk <gwilk@ellacoya.com>
  2007-08-15 15:13     ` Re: Migration Between Releases Peter Eisentraut <peter_e@gmx.net>
@ 2007-08-15 15:30       ` George Wilk <gwilk@ellacoya.com>
  0 siblings, 0 replies; 9+ messages in thread

From: George Wilk @ 2007-08-15 15:30 UTC (permalink / raw)
  To: 'Peter Eisentraut' <peter_e@gmx.net>; +Cc: pgsql-admin

This must be a matter of personal pride for you Peter, as your personal
website states: "I spend much of my spare time programming, writing
documentation for, and answering mailing list questions about PostgreSQL."
Whereas "answering mailing list questions" might be an understatement :)

I'll let you have the parting shot in this flame thread...
Pleasure was all mine.


Am Mittwoch, 15. August 2007 16:52 schrieb George Wilk:
> Hi Peter, thanks for your helpful and kind reply.  It certainly clears a
> lot of smoke...  In the future you might consider including links to
> relevant information.

You posted the relevant information yourself.  You just need to believe it.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/





^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Migration Between Releases
  2007-08-15 14:20 Migration Between Releases George Wilk <gwilk@ellacoya.com>
  2007-08-15 14:44 ` Re: Migration Between Releases Peter Eisentraut <peter_e@gmx.net>
  2007-08-15 14:52   ` Re: Migration Between Releases George Wilk <gwilk@ellacoya.com>
@ 2007-08-15 15:54     ` Scott Marlowe <scott.marlowe@gmail.com>
  2007-08-15 16:10       ` Re: Migration Between Releases Bruce Momjian <bruce@momjian.us>
  1 sibling, 1 reply; 9+ messages in thread

From: Scott Marlowe @ 2007-08-15 15:54 UTC (permalink / raw)
  To: George Wilk <gwilk@ellacoya.com>; +Cc: Peter Eisentraut <peter_e@gmx.net>; pgsql-admin

On 8/15/07, George Wilk <gwilk@ellacoya.com> wrote:
> From: Peter Eisentraut [mailto:peter_e@gmx.net]
> Sent: Wednesday, August 15, 2007 10:44 AM
> To: pgsql-admin@postgresql.org
> Cc: George Wilk
> Subject: Re: [ADMIN] Migration Between Releases
>
> Am Mittwoch, 15. August 2007 16:20 schrieb George Wilk:
> > I thought that the major release was the first number in the versioning
> > schema, the second represented minor release, and the third would be the
> > maintenance release or revision number (i.e. 8.2.4).
>
> You thought wrong then.
> Hi Peter, thanks for your helpful and kind reply.  It certainly clears a lot
> of smoke...  In the future you might consider including links to relevant
> information.

1: Please don't top post.
2: Peter, if you don't provide links like George is asking for, we're
gonna have to cut what we pay you to post here in half.  :)



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Migration Between Releases
  2007-08-15 14:20 Migration Between Releases George Wilk <gwilk@ellacoya.com>
  2007-08-15 14:44 ` Re: Migration Between Releases Peter Eisentraut <peter_e@gmx.net>
  2007-08-15 14:52   ` Re: Migration Between Releases George Wilk <gwilk@ellacoya.com>
  2007-08-15 15:54     ` Re: Migration Between Releases Scott Marlowe <scott.marlowe@gmail.com>
@ 2007-08-15 16:10       ` Bruce Momjian <bruce@momjian.us>
  0 siblings, 0 replies; 9+ messages in thread

From: Bruce Momjian @ 2007-08-15 16:10 UTC (permalink / raw)
  To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: George Wilk <gwilk@ellacoya.com>; Peter Eisentraut <peter_e@gmx.net>; pgsql-admin

Scott Marlowe wrote:
> On 8/15/07, George Wilk <gwilk@ellacoya.com> wrote:
> > From: Peter Eisentraut [mailto:peter_e@gmx.net]
> > Sent: Wednesday, August 15, 2007 10:44 AM
> > To: pgsql-admin@postgresql.org
> > Cc: George Wilk
> > Subject: Re: [ADMIN] Migration Between Releases
> >
> > Am Mittwoch, 15. August 2007 16:20 schrieb George Wilk:
> > > I thought that the major release was the first number in the versioning
> > > schema, the second represented minor release, and the third would be the
> > > maintenance release or revision number (i.e. 8.2.4).
> >
> > You thought wrong then.
> > Hi Peter, thanks for your helpful and kind reply.  It certainly clears a lot
> > of smoke...  In the future you might consider including links to relevant
> > information.
> 
> 1: Please don't top post.
> 2: Peter, if you don't provide links like George is asking for, we're
> gonna have to cut what we pay you to post here in half.  :)

This information used to be in the FAQ, but now it is on our web site
and linked to from the FAQ:

	http://www.postgresql.org/support/versioning

-- 
  Bruce Momjian  <bruce@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Migration Between Releases
  2007-08-15 14:20 Migration Between Releases George Wilk <gwilk@ellacoya.com>
@ 2007-08-15 15:41 ` Alvaro Herrera <alvherre@commandprompt.com>
  2 siblings, 0 replies; 9+ messages in thread

From: Alvaro Herrera @ 2007-08-15 15:41 UTC (permalink / raw)
  To: George Wilk <gwilk@ellacoya.com>; +Cc: pgsql-admin

George Wilk wrote:

> As a general rule, the internal data storage format is subject to change
> between major releases of PostgreSQL (where the number after the first dot
> changes). This does not apply to different minor releases under the same
> major release (where the number after the second dot changes); these always
> have compatible storage formats. For example, releases 7.2.1, 7.3.2, and 7.4
> are not compatible, whereas 7.2.1 and 7.2.2 are.
> 
> I thought that the major release was the first number in the versioning
> schema, the second represented minor release, and the third would be the
> maintenance release or revision number (i.e. 8.2.4).

It needs no clarification -- what it says is right and what you thought
is wrong.  We don't have a concept of "maintenance release" -- we only
have major (new features) and minor (bug fixes).  (This is
Postgres-specific).  Peter wasn't flaming at all.

-- 
Alvaro Herrera                        http://www.advogato.org/person/alvherre
Jason Tesser: You might not have understood me or I am not understanding you.
Paul Thomas: It feels like we're 2 people divided by a common language...



^ permalink  raw  reply  [nested|flat] 9+ messages in thread


end of thread, other threads:[~2007-08-15 16:10 UTC | newest]

Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-08-15 14:20 Migration Between Releases George Wilk <gwilk@ellacoya.com>
2007-08-15 14:30 ` Milen A. Radev <milen@radev.net>
2007-08-15 14:44 ` Peter Eisentraut <peter_e@gmx.net>
2007-08-15 14:52   ` George Wilk <gwilk@ellacoya.com>
2007-08-15 15:13     ` Peter Eisentraut <peter_e@gmx.net>
2007-08-15 15:30       ` George Wilk <gwilk@ellacoya.com>
2007-08-15 15:54     ` Scott Marlowe <scott.marlowe@gmail.com>
2007-08-15 16:10       ` Bruce Momjian <bruce@momjian.us>
2007-08-15 15:41 ` Alvaro Herrera <alvherre@commandprompt.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox