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

From: "Andrus Moor" <eetasoft(at)online(dot)ee>
To: Robert Gravsjö <robert(at)blogg(dot)se>
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:12:18
Message-ID: 381E2FBB053749AF807B01D11A0EDE0F@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.
Will this command create exact copy ?

Andrus.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2010-12-16 10:19:45 Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore
Previous Message Robert Gravsjö 2010-12-16 10:07:58 Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore