Re: [SQL] How to duplicate postgres 9.4 database

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: [SQL] How to duplicate postgres 9.4 database
Дата
Msg-id CAOR=d=3PiaBk_ReBzoskBomvTUtW9MtW7pGV3uZiSjOyTNmc4A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [SQL] How to duplicate postgres 9.4 database  (srilinux <srilinux09@gmail.com>)
Список pgsql-sql
Дерево обсуждения 
On Sat, Jul 22, 2017 at 4:43 PM, srilinux <srilinux09@gmail.com> wrote:
> Thank you very much
>
>
> I will try it , how much time will it take for 35gb database ? is this
> method suggest able for a 35gb database ?

Very much depends on your server. I've had some that could copy that
much over in a few minutes, some that might take most of an hour. But,
generally speaking creating a db from a template is about as fast as
it gets.

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: [SQL] Re: [SQL] Postgresql “alter column type” creates an event which contains “temp_table_xxx”
Следующее
От: Mohamed DIA
Дата:
Сообщение: [SQL] Issues with lag command