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 4D0A00CD.1000906@blogg.se
Whole thread Raw
In response to Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore  (Jayadevan M <Jayadevan.Maymala@ibsplc.com>)
List pgsql-general

On 2010-12-16 11.21, Jayadevan M wrote:
> Hello,
>> 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.
> Probably it will fail...
> http://www.postgresql.org/docs/9.0/static/sql-createdatabase.html
> Although it is possible to copy a database other than template1 by
> specifying its name as the template, this is not (yet) intended as a
> general-purpose "COPY DATABASE" facility. The principal limitation is that
> no other sessions can be connected to the template database while it is
> being copied. CREATE DATABASE will fail if any other connection exists
> when it starts;

Are there any other side effects to this besides failing CREATE DATABASE
command?

--
Regards,
Robert "roppert" Gravsjö

pgsql-general by date:

Previous
From: Robert Gravsjö
Date:
Subject: Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore
Next
From: Jack Christensen
Date:
Subject: Re: What is the name pseudo column