From: | "Gnanakumar" <gnanam(at)zoniac(dot)com> |
---|---|
To: | "'Kevin Grittner'" <Kevin(dot)Grittner(at)wicourts(dot)gov>, <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Fatal Error during PITR Recovery |
Date: | 2010-06-10 13:11:41 |
Message-ID: | 004901cb089e$7a366030$6ea32090$@com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Kevin,
Thank you very much for that valuable suggestion.
When the migration section says "A dump/restore is not required ...", what
is the correct method of upgrading/installing to 8.2.17?
Let me make the question/idea, which I'm thinking in my minding of
upgrading, clear here:
1. Rename '/usr/local/pgsql/data' to '/usr/local/pgsql/data.old'
2. Install v8.2.17 to its default from the source (Because installing from
source is comfortable for me)
3. After installation, just remove '/usr/local/pgsql/data' and rename
'/usr/local/pgsql/data.old' to '/usr/local/pgsql/data'
4. Start server. It should have become v8.2.17
Please share your idea/comment on this.
Regards,
Gnanam
-----Original Message-----
From: Kevin Grittner [mailto:Kevin(dot)Grittner(at)wicourts(dot)gov]
Sent: Thursday, June 10, 2010 5:52 PM
To: tgl(at)sss(dot)pgh(dot)pa(dot)us; gnanam(at)zoniac(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Fatal Error during PITR Recovery
"Gnanakumar" wrote:
> If I would like to upgrade to the latest minor version in 8.2.x
> series, that is v8.2.17, how do I upgrade this [from 8.2.3 on
> CentOS] without doing dump/restore? Links/documentation on this
> are appreciated.
>From the PostgreSQL home page there is a link to:
http://www.postgresql.org/docs/8.2/static/release-8-2-17.html
Which contains a migration section, saying this:
| A dump/restore is not required for those running 8.2.X. However, if
| you are upgrading from a version earlier than 8.2.14, see the
| release notes for 8.2.14.
The migration section of:
http://www.postgresql.org/docs/8.2/static/release-8-2-14.html
says:
| A dump/restore is not required for those running 8.2.X. However, if
| you have any hash indexes on interval columns, you must REINDEX
| them after updating to 8.2.14. Also, if you are upgrading from a
| version earlier than 8.2.11, see the release notes for 8.2.11.
http://www.postgresql.org/docs/8.2/static/release-8-2-11.html
says:
| A dump/restore is not required for those running 8.2.X. However, if
| you are upgrading from a version earlier than 8.2.7, see the
| release notes for 8.2.7. Also, if you were running a previous 8.2.X
| release, it is recommended to REINDEX all GiST indexes after the
| upgrade.
http://www.postgresql.org/docs/8.2/static/release-8-2-7.html
says:
| A dump/restore is not required for those running 8.2.X. However,
| you might need to REINDEX indexes on textual columns after
| updating, if you are affected by the Windows locale issue described
| below.
Since you're not running Windows, that last one does not affect you;
so, after stopping the server under 8.2.3 and starting it with
8.2.17, you need to rebuild any GiST indexes and rebuild any hash
indexes on interval columns.
-Kevin
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Richardson | 2010-06-10 13:33:22 | BackupExec stops PostgreSQL service |
Previous Message | Kevin Grittner | 2010-06-10 12:22:23 | Re: Fatal Error during PITR Recovery |