Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore

[Robert Gravsjà <robert@xxxxxxxx>]

On 2010-12-16 09.16, Andrus Moor wrote:

> Another requirement is to clone existing database in server with data. I
> posted question about it and it seems that PostgreSql does not have any
> capability to do this in server side in plpgsql fast.

I'm probably misunderstanding but "CREATE DATABASE foo TEMPLATE bar" 
will clone bar as foo including data. Of course this only works within 
the same cluster.

> So we need to use slow and unsafe dump/restore over internet for this also.
>
> Andrus.

--
Regards,
Robert "roppert" GravsjÃ

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general