Re: how do you automate database backups?

Поиск
Список
Период
Сортировка
От Brad Nicholson
Тема Re: how do you automate database backups?
Дата
Msg-id 4368EAC9.7040508@ca.afilias.info
обсуждение исходный текст
Ответ на how do you automate database backups?  (Ferindo Middleton Jr <fmiddleton@verizon.net>)
Список pgsql-admin
Ferindo Middleton Jr wrote:

> Are there tools available to automate backing up databases? I would
> like to setup my PostgreSQL install to automatically backup databases
> and save the file to specific location at specific times of the day
> with little to no user intervention... I'd like to know how to do this
> in both Windows and Linux. I imagine I could write some kind of script
> or something on my Linux server but I have absolutely no idea how to
> implement this on a computer running Windows.


On Linux, you'd do as you mentioned write a script to do the dump.
You'd schedule the script to run at the approriate time using cron.

--
Brad Nicholson  416-673-4106    bnichols@ca.afilias.info
Database Administrator, Afilias Canada Corp.



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

Предыдущее
От: Ferindo Middleton Jr
Дата:
Сообщение: how do you automate database backups?
Следующее
От: Robert Treat
Дата:
Сообщение: Re: how do you automate database backups?