Re: File system level backup with more than one cluster folders

Поиск
Список
Период
Сортировка
От Tino Schwarze
Тема Re: File system level backup with more than one cluster folders
Дата
Msg-id 20081210101304.GB21211@easy2.in-chemnitz.de
обсуждение исходный текст
Ответ на File system level backup with more than one cluster folders  (Michael Leshchenko <Michael.Leshchenko@its.fh-giessen.de>)
Ответы Re: File system level backup with more than one cluster folders  ("Vladimir Rusinov" <vladimir@greenmice.info>)
Список pgsql-admin
Hi Mike,

> I am newbie with PostgreSQL. I have separate table space for my
> databases, which is located in separate folder, which is different to
> default. I would like to carry out file system level backup.  Do I need
> to backup only folder with my table space or all pg folders.

Do you know that a file system level backup is only useful if

a) the postgres instance is stopped
or
b) your are using WAL archiving and have an appropiate setup to tell PG
   about backup starts and ends

You need to backup any file system structure belonging to your PG
database.

HTH,

Tino.

--
"What we nourish flourishes." - "Was wir nähren erblüht."

www.lichtkreis-chemnitz.de
www.craniosacralzentrum.de

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

Предыдущее
От: Michael Leshchenko
Дата:
Сообщение: File system level backup with more than one cluster folders
Следующее
От: Suresh Borse
Дата:
Сообщение: Re: Heavy postgres process