backing up a PostGRES DB

Поиск
Список
Период
Сортировка
От Richard Sickler
Тема backing up a PostGRES DB
Дата
Msg-id f2b12cc10904010814l4caa1333xd4ba628c586f32d4@mail.gmail.com
обсуждение исходный текст
Ответы Re: backing up a PostGRES DB
Re: backing up a PostGRES DB
Список pgsql-admin
Hello,

I'm putting together a web app that uses PostGRES as a backend and I'm looking for comments on backup strategy.
The entire web app, (Tomcat and PostGRES), will be run in a virtual machine.  I was thinking about quiescing the DB, then copying the files that make up the virtual machine to some network attached backup store.  This will be done once a day.
I ask this august body, based on your experiences, does this sound like a reasonable plan, or would doing something like running pgdump be better, or ????
Thanks for the help one and all.

Rich S.

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: privilege inheritance to a login role through a group role
Следующее
От: "Scott Whitney"
Дата:
Сообщение: Re: backing up a PostGRES DB