Postgres Pro
Downloads
Home   >   mailing lists

Re: Methods to quickly spin up copies of an existing databases - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: Methods to quickly spin up copies of an existing databases
Date
Msg-id 20190302131653.GB889@hermes.hilbert.loc
Whole thread Raw
In response to Re: Methods to quickly spin up copies of an existing databases  (Arjun Ranade <ranade@nodalexchange.com>)
List pgsql-general
Tree view 
On Fri, Mar 01, 2019 at 04:51:32PM -0500, Arjun Ranade wrote:

> Pre-copying is not really an option since we could potentially need 1-X
> instances so it needs to be scalable.

Would it work to have a PG instance with a ready-to-use
cluster/DB inside a VM, and make a copy of that as needed ? 
The copies then get thrown away.

Same here, pre-copying a bunch of VMs would help. Disk space
is (apparently) cheaper than time (for your use case).

Karsten
-- 
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B

pgsql-general by date:

Previous
From: Kevin Wilkinson
Date:
Subject: how best to specify table constraints with "create table as "
Next
From: github kran
Date:
Subject: Re: cannot execute VACUUM during recovery