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