Re: [GENERAL] Using cp to back up a database?

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: [GENERAL] Using cp to back up a database?
Дата
Msg-id CAMkU=1zvrR_HHNYbnBQQTVQP=YHoxh08M-V04aXiJwjCwZNfmw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Using cp to back up a database?  (Ron Johnson <ron.l.johnson@cox.net>)
Список pgsql-general
On Mon, Oct 9, 2017 at 7:15 AM, Ron Johnson <ron.l.johnson@cox.net> wrote:

Sure I want a consistent database.  Why doesn't?

But log shipping requires you to rsync/var/lib/pgsql/data  to the remote server, and that's consistent, so why wouldn't rsync to a local directory also be consistent?

But it isn't consistent by itself.  That is why the log shipping is required (or an equivalent method of keeping the necessary logs around), to fix up the consistency.
 
Cheers,

Jeff

В списке pgsql-general по дате отправления:

Предыдущее
От: Darren Douglas
Дата:
Сообщение: Re: [GENERAL] Using cp to back up a database?
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: [GENERAL] Using cp to back up a database?