Re: error while autovacuuming - Mailing list pgsql-general

From John R Pierce
Subject Re: error while autovacuuming
Date
Msg-id 4C87F374.5070304@hogranch.com
Whole thread Raw
In response to Re: error while autovacuuming  ("tamanna madaan" <tamanna.madan@globallogic.com>)
List pgsql-general
On 09/08/10 12:11 PM, tamanna madaan wrote:
>
> Hi All
>
> Can a postgres patch for the fix ( provided in postgres-8.1.6 for
> autovacuum error ) be included with the postgres version I am using i.e
> postgres 8.1.2 so that I don't have to upgrade to 8.1.21 ??
>
> Please reply
>
>

here's a few good reasons to not even THINK of doing what you're
describing...

http://www.postgresql.org/docs/current/static/release-8-1-3.html
http://www.postgresql.org/docs/current/static/release-8-1-4.html

<http://www.postgresql.org/docs/current/static/release-8-1-4.html>http://www.postgresql.org/docs/current/static/release-8-1-5.html
http://www.postgresql.org/docs/current/static/release-8-1-6.html
http://www.postgresql.org/docs/current/static/release-8-1-7.html
http://www.postgresql.org/docs/current/static/release-8-1-8.html
http://www.postgresql.org/docs/current/static/release-8-1-9.html
http://www.postgresql.org/docs/current/static/release-8-1-10.html
http://www.postgresql.org/docs/current/static/release-8-1-11.html
http://www.postgresql.org/docs/current/static/release-8-1-12.html
http://www.postgresql.org/docs/current/static/release-8-1-13.html
http://www.postgresql.org/docs/current/static/release-8-1-14.html
http://www.postgresql.org/docs/current/static/release-8-1-15.html
http://www.postgresql.org/docs/current/static/release-8-1-16.html
http://www.postgresql.org/docs/current/static/release-8-1-17.html
http://www.postgresql.org/docs/current/static/release-8-1-18.html
http://www.postgresql.org/docs/current/static/release-8-1-19.html
http://www.postgresql.org/docs/current/static/release-8-1-20.html
http://www.postgresql.org/docs/current/static/release-8-1-21.html

Now, sure, many of those fixes are for obscure things which may never
effect you.     Do you really want to take the chance that none of those
fixes could avoid catastrophic problems?

an upgrade from 8.1.2 is as simple as shutting down your server,
installing the latest 8.1.21, restarting your server, and, to be safe
per the release notes for 8.1.15 and 8.1.18, doing a reindexdb -a






pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Memory Errors
Next
From: Thom Brown
Date:
Subject: Text search parser's treatment of URLs and emails