Re: Cloning database without dump/restore

From: Andreas Schmitz <mailinglist(at)longimanus(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Cloning database without dump/restore
Date: 2010-11-05 09:03:32
Message-ID: 4CD3C864.4000806@longimanus.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


snapshot might be the keyword you're looking for.

regards

andreas

On 11/05/2010 09:06 AM, Andrus wrote:
> Only port 5432 is opened in server. Database can cloned using pg_dup /
> pg_restore
> If server is located in internet this requires huge amount of time and
> bandwidth.
>
> How to clone database fast ?
> How to create server side pl/pgsql script which use code like in
> pg_dump/pg_restore and or in pg_migrator and clones existing database
> or other idea ?
>
> Andrus.
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Maier 2010-11-05 09:07:05 Problem with frequent crashes related to semctl
Previous Message Craig Ringer 2010-11-05 08:50:16 Re: Installing PostgreSQL on Windows 7 64-bit system