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

From Robert Gravsjö
Subject Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore
Date
Msg-id 4D09FF56.6050808@blogg.se
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>)
List pgsql-general

On 2010-12-16 11.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.

Correct.

> Will this command create exact copy ?

Yes.

>
> Andrus.
>

--
Regards,
Robert "roppert" Gravsjö

pgsql-general by date:

Previous
From: Filip Rembiałkowski
Date:
Subject: Re: Postgres Installation
Next
From: Robert Gravsjö
Date:
Subject: Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore