Quick Links

Cloning database without dump/restore

From:	"Andrus" <kobruleht2(at)hot(dot)ee>
To:	<pgsql-general(at)postgresql(dot)org>
Subject:	Cloning database without dump/restore
Date:	2010-11-05 08:06:26
Message-ID:	BC72096D88474103BC50F3F90B4EE613@andrusnotebook
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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.

Responses

Re: Cloning database without dump/restore at 2010-11-05 08:10:00 from Grzegorz Jaśkiewicz
Re: Cloning database without dump/restore at 2010-11-05 09:03:32 from Andreas Schmitz
Re: Cloning database without dump/restore at 2010-11-05 15:53:08 from John R Pierce
Re: Cloning database without dump/restore at 2010-11-05 20:25:12 from Dimitri Fontaine

Browse pgsql-general by date

	From	Date	Subject
Next Message	Grzegorz Jaśkiewicz	2010-11-05 08:10:00	Re: Cloning database without dump/restore
Previous Message	Grzegorz Jaśkiewicz	2010-11-05 07:52:49	Re: Which is faster: md5() or hashtext()?