Re: How to duplicate postgres 9.4 database

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: srilinux <srilinux09(at)gmail(dot)com>
Cc: sql pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: How to duplicate postgres 9.4 database
Date: 2017-07-25 21:07:37
Message-ID: CAOR=d=3PiaBk_ReBzoskBomvTUtW9MtW7pGV3uZiSjOyTNmc4A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Sat, Jul 22, 2017 at 4:43 PM, srilinux <srilinux09(at)gmail(dot)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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Mohamed DIA 2017-07-28 17:48:53 Issues with lag command
Previous Message Craig Ringer 2017-07-25 15:04:01 Re: [SQL] Postgresql “alter column type” creates an event which contains “temp_table_xxx”