Re: [PERFORM] Postgres on Netapp

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
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073