Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 02D029FB4D9 for ; Sat, 20 Jan 2007 18:48:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 42012-08 for ; Sat, 20 Jan 2007 18:48:13 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from howe.textdrive.com (howe.textdrive.com [207.7.108.240]) by postgresql.org (Postfix) with ESMTP id 9C9DB9FB398 for ; Sat, 20 Jan 2007 18:48:13 -0400 (AST) Received: from [68.53.88.73] (c-68-53-88-73.hsd1.tn.comcast.net [68.53.88.73]) by howe.textdrive.com (Postfix) with ESMTP id 5D78012031B for ; Sat, 20 Jan 2007 22:48:12 +0000 (GMT) Mime-Version: 1.0 (Apple Message framework v752.2) To: pgsql-docs@postgresql.org Message-Id: Content-Type: multipart/alternative; boundary=Apple-Mail-2--99952471 From: "Thomas F. O'Connell" Subject: 14.4 If You Are Upgrading - Suggested Improvements Date: Sat, 20 Jan 2007 16:48:12 -0600 X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/10 X-Sequence-Number: 4106 --Apple-Mail-2--99952471 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed I've done a number of upgrades of postgres from one minor release to another, and unless I'm missing something, there's nothing anywhere in section 14 that provides documentation on how to do this. Generally, it's as simple as: configure make make install pg_ctl stop [or equivalent, if stop scripts exist] pg_ctl start -D [or equivalent, if start scripts exist] But it seems like it would be helpful for administrators to break down 14.4 into two sections: 14.4.1 - If You Are Upgrading a Minor Release 14.4.2 - If You Are Upgrading a Major Release (or a Release Requiring an initdb) Just a suggestion. If this strikes others as a good idea, I'd be happy to draft something. -- Thomas F. O'Connell optimizing modern web applications : for search engines, for usability, and for performance : http://o.ptimized.com/ 615-260-0005 --Apple-Mail-2--99952471 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=US-ASCII
I've done a number of = upgrades of postgres from one minor release to another, and unless I'm = missing something, there's nothing anywhere in section 14 that provides = documentation on how to do this.

Generally, it's as simple = as:

configure
make
make install
pg_ctl stop [or equivalent, if stop scripts = exist]
pg_ctl start -D <data directory> [or equivalent, = if start scripts exist]

But it seems like it would = be helpful for administrators to break down 14.4 into two = sections:

14.4.1 - If You Are = Upgrading a Minor Release
14.4.2 - If You Are Upgrading a = Major Release (or a Release Requiring an initdb)

Just a suggestion. If this = strikes others as a good idea, I'd be happy to draft = something.

optimizing modern web = applications
: for search engines, for usability, and for = performance :

615-260-000= 5
=

= --Apple-Mail-2--99952471--