Re: Postgressql backup/restore question - Mailing list pgsql-admin

From Simon Riggs
Subject Re: Postgressql backup/restore question
Date
Msg-id 1236204830.31880.122.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Re: Postgressql backup/restore question  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Postgressql backup/restore question
List pgsql-admin
On Wed, 2009-03-04 at 16:27 -0500, Tom Lane wrote:
> Simon Riggs <simon@2ndQuadrant.com> writes:
> > On Wed, 2009-03-04 at 15:37 -0500, Tom Lane wrote:
> >> It's not as easy as all that.  What will you do with updates to shared
> >> catalogs?
>
> > Apply them.
>
> ... which leaves your other databases in inconsistent states.

Which is not a problem if you didn't want to restore them in the first
place. You might complain that we would need safeguards to protect
people from trying to access non-restored databases and then failing to
understand why they aren't there.

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


pgsql-admin by date:

Previous
From: Yauheni Labko
Date:
Subject: Re: standby waiting for what?
Next
From: Tom Lane
Date:
Subject: Re: Postgressql backup/restore question