[GENERAL] Cloning database without dump/restore

2010-11-05 Thread Andrus
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

Re: [GENERAL] Cloning database without dump/restore

2010-11-05 Thread Grzegorz Jaƛkiewicz
read documentation on backups. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Cloning database without dump/restore

2010-11-05 Thread Andreas Schmitz
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

Re: [GENERAL] Cloning database without dump/restore

2010-11-05 Thread John R Pierce
On 11/05/10 1: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. you can't log onto the server, no ssh? thats a harsh constraint. moving the data to

Re: [GENERAL] Cloning database without dump/restore

2010-11-05 Thread Dimitri Fontaine
Andrus kobrule...@hot.ee writes: 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 ? See pg_basebackup here: https://github.com/dimitri/pg_basebackup I'm