Florian Pflug wrote: >> I used this to upgrade to 9.0.13, which indeed is fully compatible with >> Debian. It started up like a charm. I can upgrade it to 9.1.9 now >> (while I'm at it).
>Since you've been running with full_page_writes=off, I suggest you update >to 9.1 by dumping and reloading your data (i.e. pg_dumpall) instead of >via binary upgrades (i.e. pg_upgrade). I need to do that anyway, since the pg_upgradecluster script of Debian (or is it a native PostgreSQL script?) does not support tablespaces. >That way, you can be sure that your data is consistent (from postgres' >POV anyway) after the upgrade. pg_upgrade OTOH will only notice >inconsistencies in the system tables, since the data files of user tables >and indices are simply copied unchanged. Good point. Thanks. -- Stephen. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
