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

From: Robert Gravsjö <robert(at)blogg(dot)se>
To: Andrus Moor <eetasoft(at)online(dot)ee>
Cc: 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 12:00:22
Message-ID: 4D09FF56.6050808@blogg.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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ö

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Robert Gravsjö 2010-12-16 12:06:37 Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore
Previous Message Filip Rembiałkowski 2010-12-16 11:38:07 Re: Postgres Installation