Re: [PERFORM] Postgres on Netapp

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [PERFORM] Postgres on Netapp
Дата
Msg-id 200401231501.i0NF19B08501@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [PERFORM] Postgres on Netapp  ("D'Arcy J.M. Cain" <darcy@druid.net>)
Список pgsql-admin
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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Stef
Дата:
Сообщение: Re: [SQL] Fw: postgres logging [SOLVED]
Следующее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: [SQL] Database diagram