Fastest way to duplicate a quite large database

Поиск
Список
Период
Сортировка
Искать
От
Edson Richter
Тема
Fastest way to duplicate a quite large database
Дата
Msg-id
BLU436-SMTP1554E4B71F7BF74DFE0A8FFCF950@phx.gbl
Список
Дерево обсуждения
Fastest way to duplicate a quite large database Edson Richter <edsonrichter@hotmail.com>
Re: Fastest way to duplicate a quite large database John R Pierce <pierce@hogranch.com>
Re: Fastest way to duplicate a quite large database Edson Richter <edsonrichter@hotmail.com>
Re: Fastest way to duplicate a quite large database Adrian Klaver <adrian.klaver@aklaver.com>
Re: Fastest way to duplicate a quite large database Louis Battuello <louis.battuello@etasseo.com>
Re: Fastest way to duplicate a quite large database John McKown <john.archie.mckown@gmail.com>
Re: Fastest way to duplicate a quite large database John R Pierce <pierce@hogranch.com>
Re: Fastest way to duplicate a quite large database Louis Battuello <louis.battuello@etasseo.com>
Re: Fastest way to duplicate a quite large database John McKown <john.archie.mckown@gmail.com> 
Hi!

I have a database "Customer" with about 60Gb of data.
I know I can backup and restore, but this seems too slow.

Is there any other option to duplicate this database as "CustomerTest" 
as fast as possible (even fastar than backup/restore) - better if in one 
operation (something like "copy database A to B")?
I would like to run this everyday, overnight, with minimal impact to 
prepare a test environment based on production data.

Thanks,

-- 
Atenciosamente,

Edson Carlos Ericksson Richter
В списке pgsql-general по дате отправления
Предыдущее
От: Adrian Klaver
Дата:
Следующее
От: Alex Ignatov
Дата:
FAQ