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

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ö