Re: Table update: restore or replace?

On Tue, 14 May 2019, Tom Lane wrote:

> Yeah. You can't just selectively copy files, because the data files are
> dependent on the contents of the pg_xact transaction log; it's all or
> nothing.

Tom,

That's why I thought of copying the entire data/ directory.

> Also, I don't know what method you've been using to make file-level
> backups, but they're really pretty worthless unless you (a) stop the
> server or (b) use a filesystem snapshot. Otherwise you're very likely to
> have inconsistent data.

I run dirvish <http://www.dirvish.org/> which runs each night starting at
00:30 am when there's no activity (by me, at least) on the database.

Regards,

Rich