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
