Re: pg_dump locking info

On Sun, Aug 15, 2010 at 5:38 AM, Thom Brown <thom(at)linux(dot)com> wrote:
> Another thing I noticed, going back to
> http://www.postgresql.org/docs/current/static/backup-file.html , is
> that it makes no mention of the fact that file system level backups
> are useless if being used to restore in a different major version.
> Maybe "There are two restrictions, however, which make this method
> impractical, or at least inferior to the pg_dump method" should be
> changed to "There are three..." and add the point that
> pg_dump/pg_dumpall is mostly immune to such limitations.

Probably we need to say something a bit more nuanced than that, as
there can certainly be wrinkles in that area.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company