Re: Duplicating data folder without tablespace, for read access

2018-08-28 Thread Jack Cushman
s/ Thanks, Jack On Tue, Aug 14, 2018 at 11:57 AM Jack Cushman wrote: > Hi -- > > I'm wondering whether, in my specific situation, it would be safe to copy > a database cluster's data folder, and bring up the copy for read access, > without copying a tablespace linked fro

Re: Duplicating data folder without tablespace, for read access

2018-08-14 Thread Jack Cushman
Thanks for such quick and helpful answers! My plan sounds probably better to avoid, but if it turns out to be necessary, you all gave me some helpful avenues and things to look out for. Best, Jack On Tue, Aug 14, 2018 at 1:06 PM, Stephen Frost wrote: > Greetings, > > * Jack Cushm

Duplicating data folder without tablespace, for read access

2018-08-14 Thread Jack Cushman
Hi -- I'm wondering whether, in my specific situation, it would be safe to copy a database cluster's data folder, and bring up the copy for read access, without copying a tablespace linked from it. My situation (described below) involves a database with a 100GB table and a 600GB table where I want