Re: [SQL] How to duplicate postgres 9.4 database - Mailing list pgsql-sql

From Scott Marlowe
Subject Re: [SQL] How to duplicate postgres 9.4 database
Date
Msg-id CAOR=d=3PiaBk_ReBzoskBomvTUtW9MtW7pGV3uZiSjOyTNmc4A@mail.gmail.com
Whole thread Raw
In response to Re: [SQL] How to duplicate postgres 9.4 database  (srilinux <srilinux09@gmail.com>)
List 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 by date:

Previous
From: Craig Ringer
Date:
Subject: [SQL] Re: [SQL] Postgresql “alter column type” creates an event which contains “temp_table_xxx”
Next
From: Mohamed DIA
Date:
Subject: [SQL] Issues with lag command