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 10:07:58
Message-ID: 4D09E4FE.4090608@blogg.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2010-12-16 09.16, Andrus Moor wrote:

>
> Another requirement is to clone existing database in server with data. I
> posted question about it and it seems that PostgreSql does not have any
> capability to do this in server side in plpgsql fast.

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.

> So we need to use slow and unsafe dump/restore over internet for this also.
>
> Andrus.
>

--
Regards,
Robert "roppert" Gravsjö

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next 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
Previous Message Florian Pflug 2010-12-16 10:03:36 Re: [HACKERS] getting composite types info from libpq