Pardon me this one additional Q since I'm used to SQLsrv/Oracle where this single db point in time restore would be quite easily done : Is the thought behind this, that databases in a cluster will always be "dependent" on each other and therefore likely to require a recovery of all cluster databases to the same point in time, if requested by one of the "application database owners" ?
So, one is forced to create "single database cluster" if we want to offer single database recovery, isolated from other running databases ?
/Brian
> CC: pgsql-novice@postgresql.org > Subject: Re: [NOVICE] PIT Recovery of only certain database in the "cluster" ? > Date: Fri, 11 Mar 2011 09:29:15 -0500 > From: tgl@sss.pgh.pa.us > > > > We would like to have, say a database for each application , in our cluster/instance. > > And use continuous archiving to be able to maximize our chance of not loosing any data... And do Point In Tiem recovery of any of the databases. > > Doesn't work that way: PITR operates across a whole cluster. > > regards, tom lane > > -- > Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-novice