Postgres Pro
Downloads
Home   >   mailing lists

Fastest way to duplicate a quite large database - Mailing list pgsql-general

From Edson Richter
Subject Fastest way to duplicate a quite large database
Date
Msg-id BLU436-SMTP1554E4B71F7BF74DFE0A8FFCF950@phx.gbl
Whole thread Raw
Responses Re: Fastest way to duplicate a quite large database
Re: Fastest way to duplicate a quite large database
List pgsql-general
Tree view 
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pgpool-II: cannot use serializable mode in a hot standby
Next
From: Alex Ignatov
Date:
Subject: Re: Freezing localtimestamp and other time function on some value