Re: error while autovacuuming

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