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

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.
Will this command create exact copy ?

Andrus.