How safe is pg_basebackup + continuous archiving?
От
Kaixi Luo
Тема
How safe is pg_basebackup + continuous archiving?
Дата
Msg-id
CAHo5iyh+miHaMGoYrYiKHC5t02nnpr0czYF6O9o+95K9z=gieA@mail.gmail.com
Список
Дерево обсуждения
How safe is pg_basebackup + continuous archiving? Kaixi Luo <kaixiluo@gmail.com>
Re: How safe is pg_basebackup + continuous archiving? Stephen Frost <sfrost@snowman.net>
Re: How safe is pg_basebackup + continuous archiving? Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: How safe is pg_basebackup + continuous archiving? Michael Paquier <michael.paquier@gmail.com>
Re: How safe is pg_basebackup + continuous archiving? Kaixi Luo <kaixiluo@gmail.com>
Re: How safe is pg_basebackup + continuous archiving? Michael Paquier <michael.paquier@gmail.com>
Re: How safe is pg_basebackup + continuous archiving? Kaixi Luo <kaixiluo@gmail.com>
Re: How safe is pg_basebackup + continuous archiving? Alex Ignatov <a.ignatov@postgrespro.ru>
Hello,
We use PostgreSQL at work and we do daily backups with pg_dump. After that we pg_restore the dump and check the database that there isn't any data corruption. As the database grows, the whole pg_dump / pg_restore cycle time is quickly approaching 24h, so we need to change strategies.
We've thought about using pg_basebackup + continuous archiving as an alternative backup process, but I have doubts regarding the safety of such procedure. As far as I know, pg_basebackup is done via rsync (and we also archive wals using rsync), so if by any chance disk corruption occurs on the master server, the corruption would be carried over to our backup server.
How can we check for backup corruption in this case? Thanks you very much.
Kaixi Luo
В списке pgsql-general по дате отправления