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

On 16/12/2010 10:12, Andrus Moor wrote:
> Robert,
>
>> 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.
>
> Than you.
> You are genious
> I haven't never tought about this.
>
> Will this work if database bar is accessed by other users ? Probably it
> fails, so it cannot used.

I don't know for sure, but I don't see why it should fail - it's only
reading it, not writing data to it or making any changes.

> Will this command create exact copy ?

Why wouldn't it? :-)

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie