Tom Lane wrote: > "Scott Whitney" <swhit...@journyx.com> writes:
> > It ended up locking up about 250 customer databases until I restarted the > > postmaster. This is version 8.1.4. Upgrading right now (even to a minor rev) > > is not really an option. > > Not related to the immediate problem, but: you really need to schedule > 5 minutes' downtime so you can update to 8.1.latest. Reasons can be > found here: > http://www.postgresql.org/docs/8.1/static/release.html Particularly so if you run autovacuum, because otherwise you'll be hit by a bug fixed in 8.1.6 about template0 being unfrozen (thawed?) -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
