Re: Doubts about replication..

Поиск
Список
Период
Сортировка
От Edmundo Robles
Тема Re: Doubts about replication..
Дата
Msg-id CAOXzpYDejJPcivatfQZhx2sSyRGzj-WBCFGJi3xSdUi=1yqBsg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Doubts about replication..  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Ответы Re: Doubts about replication..  (Stefan Fercot <stefan.fercot@dalibo.com>)
Re: Doubts about replication..  (Francisco Olarte <folarte@peoplecall.com>)
Re: Doubts about replication..  (Laurentius Purba <lpurba@sproutloud.com>)
Список pgsql-general
Yes, you are right, the replication is not  a backup ;)  , actually   i backup  database  daily at  3:00 am but if database crash,  the amount  of data is  big!  that is the reason i want to  replicate to reduce  the data loss. By the way  a few days ago a job partner did a delete with no where.

On Thu, Apr 19, 2018 at 1:33 PM, Andreas Kretschmer <andreas@a-kretschmer.de> wrote:


Am 19.04.2018 um 19:57 schrieb Edmundo Robles:
I will use replication as simple backup.

please keep in mind, replication is not a backup. All logical errors on the master (delete from table and forgot the where-condition) will replicated to the standby.


Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com





--

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Problem with trigger makes Detail record be invalid
Следующее
От: PegoraroF10
Дата:
Сообщение: Re: Problem with trigger makes Detail record be invalid