| From: | Edson Richter <edsonrichter(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Fastest way to duplicate a quite large database |
| Date: | 2016-04-12 14:51:00 |
| Message-ID: | BLU436-SMTP18AB86B6BE22AA963B16B0CF950@phx.gbl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Same machine, same cluster - just different database name.
Atenciosamente,
Edson Carlos Ericksson Richter
Em 12/04/2016 11:46, John R Pierce escreveu:
> On 4/12/2016 7:25 AM, Edson Richter wrote:
>>
>> 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.
>
>
> copy to the same machine, or copy to a different test server?
> different answers.
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John McKown | 2016-04-12 14:55:10 | Re: Fastest way to duplicate a quite large database |
| Previous Message | John R Pierce | 2016-04-12 14:46:20 | Re: Fastest way to duplicate a quite large database |