Re: pg_dump, shemas, backup strategy

Greg Smith <greg@2ndquadrant.com> writes:
> Michael A. Peters wrote:
>> I run CentOS 5.x and I do not like to upgrade vendor supplied packages. My
>> version of pg_dump is from postgresql-8.1.21-1.el5_5.1 - I'm assuming the
>> 8.1.21 is the important part.

> That's a bad policy with PostgreSQL.  I guarantee you that the problems
> you will run into because you're on PostgreSQL 8.1 are far worse than
> any you might encounter because you've updated from RedHat's PostgreSQL
> to the RPM packages provided by the PostgreSQL packagers.

Please note also that Red Hat has been shipping PG 8.4 for RHEL5 for
awhile --- it's the postgresql84-* package set.  I would hope CentOS
has copied that by now.

            regards, tom lane