D'Arcy J.M. Cain wrote:
> With the price of GigE adapters I wouldn't consider anything else.
> I have a huge database that takes about an hour to copy.  The netApp snapshot 
> feature is very nice because I can get a "moment in time" image of the 
> database.  Even though I can't run from the snapshot because it is read only 
> (*) and PG needs to write to files just to open the database, I can copy it 
> and get a runnable version of the DB.  If I copy directly from the original I 
> can get many changes while copying and wind up with a copy that will not run.
> (*): It would be nice if PG had a flag that allowed a database to be opened in 
> read only mode without touching anything in the directory.

PostgreSQL has to read the WAL to adjust the contents of the flat file
on startup in such a setup, so I don't see how we could do it read-only.

  Bruce Momjian                        |  http://candle.pha.pa.us
  [EMAIL PROTECTED]               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to