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