Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore
Date
Msg-id 4D09E7C1.6050807@iol.ie
Whole thread Raw
In response to Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore  ("Andrus Moor" <eetasoft@online.ee>)
Responses Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore
List pgsql-general
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

pgsql-general by date:

Previous
From: "Andrus Moor"
Date:
Subject: Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore
Next
From: Jayadevan M
Date:
Subject: Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore