Postgresql 8.4.3 upgrade troubles

I recently upgraded several of postgres DB server to the latest version 8.4.3.  The process was pretty simple for the 8.3.x clusters. Make a copy of the postgres configuration files. cp /var/lib/pgsql/data/*.conf /tmp/. pg_dump each DB instance in plaintext format: pg_dump -d dbname -Fp -o ./dbname.dmp.sql Stop postgres: pg_ctl stop Configure the new pgdg yum [...]

Tagged