if you upgrade to different major version, yes. If between minor releases (say 8.1.4->8.1.5) than no, with few exceptions. Make sure you read release notes between versions to find out.
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general