From gwilk@ellacoya.com Wed Aug 15 14:21:04 2007 Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 603199F9D8E for ; Wed, 15 Aug 2007 11:21:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 74219-02 for ; Wed, 15 Aug 2007 11:20:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail02.ellacoya.com (67-135-29-172.dia.static.qwest.net [67.135.29.172]) by postgresql.org (Postfix) with ESMTP id 413F29F9D50 for ; Wed, 15 Aug 2007 11:20:55 -0300 (ADT) Received: from YZANGXP ([192.168.124.31]) by mail02.ellacoya.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 15 Aug 2007 10:20:54 -0400 From: "George Wilk" To: Subject: Migration Between Releases Date: Wed, 15 Aug 2007 10:20:51 -0400 Message-ID: <044201c7df47$7baf3320$1f7ca8c0@ellacoya.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0443_01C7DF25.F49D9320" X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 Thread-Index: AcffR3uEVb09NBdbSPiRtPEwKsZ9bg== X-OriginalArrivalTime: 15 Aug 2007 14:20:54.0157 (UTC) FILETIME=[7D525BD0:01C7DF47] X-TM-AS-Product-Ver: SMEX-8.0.0.1181-5.000.1021-15364.000 X-TM-AS-Result: No--11.676400-4.000000-31 X-TM-AS-User-Approved-Sender: No X-TM-AS-User-Blocked-Sender: No X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/173 X-Sequence-Number: 26504 This is a multi-part message in MIME format. ------=_NextPart_000_0443_01C7DF25.F49D9320 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_0443_01C7DF25.F49D9320 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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

------=_NextPart_000_0443_01C7DF25.F49D9320-- From milen@radev.net Wed Aug 15 14:31:24 2007 Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 3D13B9FA103 for ; Wed, 15 Aug 2007 11:31:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 81650-08 for ; Wed, 15 Aug 2007 11:31:12 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by postgresql.org (Postfix) with ESMTP id 50C709F9FCD for ; Wed, 15 Aug 2007 11:30:48 -0300 (ADT) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1ILJtC-0001cb-7c for pgsql-admin@postgresql.org; Wed, 15 Aug 2007 16:30:26 +0200 Received: from pirus.securax.be ([213.16.46.130]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 15 Aug 2007 16:30:26 +0200 Received: from milen by pirus.securax.be with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 15 Aug 2007 16:30:26 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: "Milen A. Radev" Subject: Re: Migration Between Releases Date: Wed, 15 Aug 2007 17:30:09 +0300 Lines: 31 Message-ID: References: <044201c7df47$7baf3320$1f7ca8c0@ellacoya.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: pirus.securax.be User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) In-Reply-To: <044201c7df47$7baf3320$1f7ca8c0@ellacoya.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/174 X-Sequence-Number: 26505 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 From peter_e@gmx.net Wed Aug 15 14:44:24 2007 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 6D1B39FA584 for ; Wed, 15 Aug 2007 11:44:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 16085-01 for ; Wed, 15 Aug 2007 11:44:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from gauss.credativ.com (gauss.credativ.com [212.112.227.254]) by postgresql.org (Postfix) with ESMTP id D6AD89FA597 for ; Wed, 15 Aug 2007 11:44:23 -0300 (ADT) Received: from hawking.credativ.lan (exit.credativ.com [87.139.82.80]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id 86114776C0; Wed, 15 Aug 2007 16:39:07 +0200 (CEST) From: Peter Eisentraut To: pgsql-admin@postgresql.org Subject: Re: Migration Between Releases Date: Wed, 15 Aug 2007 16:44:18 +0200 User-Agent: KMail/1.9.5 Cc: "George Wilk" References: <044201c7df47$7baf3320$1f7ca8c0@ellacoya.com> In-Reply-To: <044201c7df47$7baf3320$1f7ca8c0@ellacoya.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200708151644.18764.peter_e@gmx.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/175 X-Sequence-Number: 26506 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/ From gwilk@ellacoya.com Wed Aug 15 14:52:59 2007 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id DCF559FA1AA for ; Wed, 15 Aug 2007 11:52:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 17781-05 for ; Wed, 15 Aug 2007 11:52:37 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail02.ellacoya.com (67-135-29-172.dia.static.qwest.net [67.135.29.172]) by postgresql.org (Postfix) with ESMTP id E20DA9F9AC2 for ; Wed, 15 Aug 2007 11:52:07 -0300 (ADT) Received: from YZANGXP ([192.168.124.31]) by mail02.ellacoya.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 15 Aug 2007 10:52:06 -0400 From: "George Wilk" To: "'Peter Eisentraut'" , Subject: Re: Migration Between Releases Date: Wed, 15 Aug 2007 10:52:03 -0400 Message-ID: <045801c7df4b$d7d1ca60$1f7ca8c0@ellacoya.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 In-Reply-To: <200708151644.18764.peter_e@gmx.net> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 Thread-Index: AcffSsR2KWP2wvc/QVWyBt3MqwA5fAAAQdfw X-OriginalArrivalTime: 15 Aug 2007 14:52:06.0782 (UTC) FILETIME=[D97E41E0:01C7DF4B] X-TM-AS-Product-Ver: SMEX-8.0.0.1181-5.000.1021-15364.000 X-TM-AS-Result: No--3.704800-4.000000-31 X-TM-AS-User-Approved-Sender: No X-TM-AS-User-Blocked-Sender: No X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/176 X-Sequence-Number: 26507 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/ From peter_e@gmx.net Wed Aug 15 15:13:47 2007 Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 4342C9FA3E5 for ; Wed, 15 Aug 2007 12:13:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 97109-01-6 for ; Wed, 15 Aug 2007 12:13:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from gauss.credativ.com (gauss.credativ.com [212.112.227.254]) by postgresql.org (Postfix) with ESMTP id C4D649FA4FC for ; Wed, 15 Aug 2007 12:13:46 -0300 (ADT) Received: from hawking.credativ.lan (exit.credativ.com [87.139.82.80]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id E0E7078543; Wed, 15 Aug 2007 17:08:30 +0200 (CEST) From: Peter Eisentraut To: "George Wilk" Subject: Re: Migration Between Releases Date: Wed, 15 Aug 2007 17:13:40 +0200 User-Agent: KMail/1.9.5 Cc: pgsql-admin@postgresql.org References: <045801c7df4b$d7d1ca60$1f7ca8c0@ellacoya.com> In-Reply-To: <045801c7df4b$d7d1ca60$1f7ca8c0@ellacoya.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200708151713.41765.peter_e@gmx.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/177 X-Sequence-Number: 26508 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/ From gwilk@ellacoya.com Wed Aug 15 15:31:03 2007 Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 3850F9FA62F for ; Wed, 15 Aug 2007 12:31:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 01800-02-8 for ; Wed, 15 Aug 2007 12:30:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail02.ellacoya.com (67-135-29-172.dia.static.qwest.net [67.135.29.172]) by postgresql.org (Postfix) with ESMTP id 761E29FA63B for ; Wed, 15 Aug 2007 12:30:55 -0300 (ADT) Received: from YZANGXP ([192.168.124.31]) by mail02.ellacoya.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 15 Aug 2007 11:30:54 -0400 From: "George Wilk" To: "'Peter Eisentraut'" Cc: Subject: Re: Migration Between Releases Date: Wed, 15 Aug 2007 11:30:51 -0400 Message-ID: <045c01c7df51$43602d30$1f7ca8c0@ellacoya.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 In-Reply-To: <200708151713.41765.peter_e@gmx.net> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 Thread-Index: AcffTt9KGO/8GVPMRcqOtBqkyTfWRwAAT8WA X-OriginalArrivalTime: 15 Aug 2007 15:30:54.0735 (UTC) FILETIME=[450FB1F0:01C7DF51] X-TM-AS-Product-Ver: SMEX-8.0.0.1181-5.000.1021-15364.000 X-TM-AS-Result: No--6.183400-4.000000-31 X-TM-AS-User-Approved-Sender: No X-TM-AS-User-Blocked-Sender: No X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/178 X-Sequence-Number: 26509 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/ From alvherre@commandprompt.com Wed Aug 15 15:44:23 2007 Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 79F449F9363 for ; Wed, 15 Aug 2007 12:44:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 97267-01-7 for ; Wed, 15 Aug 2007 12:44:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 5C0FE9FB1F3 for ; Wed, 15 Aug 2007 12:42:11 -0300 (ADT) Received: from perhan.alvh.no-ip.org (201-221-221-172.bk12-dsl.surnet.cl [201.221.221.172]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l7FFfcOl025518; Wed, 15 Aug 2007 08:41:38 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 90B4447C55; Wed, 15 Aug 2007 11:41:35 -0400 (CLT) Date: Wed, 15 Aug 2007 11:41:35 -0400 From: Alvaro Herrera To: George Wilk Cc: pgsql-admin@postgresql.org Subject: Re: Migration Between Releases Message-ID: <20070815154135.GB25596@alvh.no-ip.org> References: <044201c7df47$7baf3320$1f7ca8c0@ellacoya.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <044201c7df47$7baf3320$1f7ca8c0@ellacoya.com> User-Agent: Mutt/1.5.16 (2007-06-11) X-Virus-Scanned: ClamAV 0.91.1/3962/Wed Aug 15 00:21:42 2007 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Wed, 15 Aug 2007 08:41:39 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/179 X-Sequence-Number: 26510 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... From scott.marlowe@gmail.com Wed Aug 15 15:54:13 2007 Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id A9F879FB260 for ; Wed, 15 Aug 2007 12:54:13 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 08843-02-7 for ; Wed, 15 Aug 2007 12:54:07 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.187]) by postgresql.org (Postfix) with ESMTP id 7A4799FB1C9 for ; Wed, 15 Aug 2007 12:54:02 -0300 (ADT) Received: by rv-out-0910.google.com with SMTP id l15so172278rvb for ; Wed, 15 Aug 2007 08:54:00 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ad0o03d4RIwC5DMscNlDYDjvSZDankhHx7t1Ifc2TfXtewO+k8I+ntBnRvWjmV6wmowdy+9S3Eltc7cz1EWH4r2QnSbUDdhUe/+MMlVFqbMFCypWCf0aE/lrUxWR1LYIptI6/Xo9kZhgxB35MJ2b0gDQy9T1hzESYfxYAa0BLd4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=e/l3Hd3ApeFijKq/utwPFvxO0FIl6vftR7xVgBMQAaSdatPogAAPXdLrpV185w+PpaEhLPdg7ABrV+QIHF7B41eN4ajsh04yDBptUbcGiyWnUSvKRet3NwGnNwkjhn5Pqxn19GflEiMMaePH9Xpge44rDlu9WcF3PWWxvTbkv88= Received: by 10.141.202.12 with SMTP id e12mr252009rvq.1187193240655; Wed, 15 Aug 2007 08:54:00 -0700 (PDT) Received: by 10.141.98.12 with HTTP; Wed, 15 Aug 2007 08:54:00 -0700 (PDT) Message-ID: Date: Wed, 15 Aug 2007 10:54:00 -0500 From: "Scott Marlowe" To: "George Wilk" Subject: Re: Migration Between Releases Cc: "Peter Eisentraut" , pgsql-admin@postgresql.org In-Reply-To: <045801c7df4b$d7d1ca60$1f7ca8c0@ellacoya.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <200708151644.18764.peter_e@gmx.net> <045801c7df4b$d7d1ca60$1f7ca8c0@ellacoya.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/181 X-Sequence-Number: 26512 On 8/15/07, George Wilk 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. :) From bruce@momjian.us Wed Aug 15 16:11:17 2007 Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id D7AA79FA662 for ; Wed, 15 Aug 2007 13:11:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 39537-09 for ; Wed, 15 Aug 2007 13:11:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id 3E89F9F9594 for ; Wed, 15 Aug 2007 13:11:07 -0300 (ADT) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id l7FGAWQ01300; Wed, 15 Aug 2007 12:10:32 -0400 (EDT) From: Bruce Momjian Message-Id: <200708151610.l7FGAWQ01300@momjian.us> Subject: Re: Migration Between Releases In-Reply-To: To: Scott Marlowe Date: Wed, 15 Aug 2007 12:10:32 -0400 (EDT) CC: George Wilk , Peter Eisentraut , pgsql-admin@postgresql.org X-Mailer: ELM [version 2.4ME+ PL123] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/182 X-Sequence-Number: 26513 Scott Marlowe wrote: > On 8/15/07, George Wilk 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 http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +