| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | Andrus Moor <eetasoft(at)online(dot)ee> |
| Cc: | Robert Gravsjö <robert(at)blogg(dot)se>, adrian(dot)klaver(at)gmail(dot)com, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore |
| Date: | 2010-12-16 10:19:45 |
| Message-ID: | 4D09E7C1.6050807@iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)iol(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jayadevan M | 2010-12-16 10:21:50 | Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore |
| Previous Message | Andrus Moor | 2010-12-16 10:12:18 | Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore |