On Mon, Oct 9, 2017 at 1:19 PM, Ron Johnson <ron.l.johnson@cox.net> wrote:Maybe my original question wasn't clear, so I'll try again: is it safe to do a physical using cp (as opposed to rsync)?Yes -- however you must configure WAL archiving first. If not, no backup tool, cp, rsync, etc... will provide a good backup.Oh, and BTW -- The obligatory: You are on an ancient, EOL version of PG. Upgrade.Make sure that these are set:- archive_mode- archive_commandThen, on when you restore the backup, you need to create a recovery.conf and configure- restore_commandhttps://www.postgresql.org/docs/8.4/static/continuous-archiving.html
Maybe my original question wasn't clear, so I'll try again: is it safe to do a physical using cp (as opposed to rsync)?
-- World Peace Through Nuclear Pacification
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных