Re: [GENERAL] Using cp to back up a database?
От
Ron Johnson
Тема
Re: [GENERAL] Using cp to back up a database?
Дата
Msg-id
890bb735-41a4-14df-8ee7-f02478510a7a@cox.net
Список
Дерево обсуждения
[GENERAL] Using cp to back up a database? Ron Johnson <ron.l.johnson@cox.net>
Re: [GENERAL] Using cp to back up a database? Larry Rosenman <ler@lerctr.org>
Re: [GENERAL] Using cp to back up a database? Achilleas Mantzios <achill@matrix.gatewaynet.com>
Re: [GENERAL] Using cp to back up a database? Michael Paquier <michael.paquier@gmail.com>
Re: [GENERAL] Using cp to back up a database? Achilleas Mantzios <achill@matrix.gatewaynet.com>
Re: [GENERAL] Using cp to back up a database? Melvin Davidson <melvin6925@gmail.com>
Re: [GENERAL] Using cp to back up a database? Darren Douglas <darren@synsesolutions.com>
Re: [GENERAL] Using cp to back up a database? Darren Douglas <darren@synsesolutions.com>
Re: [GENERAL] Using cp to back up a database? Jeff Janes <jeff.janes@gmail.com>
On 10/09/2017 01:02 PM, Scott Mead wrote:
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_command
This is good to know. Thanks.
-- World Peace Through Nuclear Pacification
В списке pgsql-general по дате отправления
