How to create nightly backups in Linux

Поиск
Список
Период
Сортировка
От Andrus
Тема How to create nightly backups in Linux
Дата
Msg-id efef8i$j4s$1@news.hub.org
обсуждение исходный текст
Ответы Re: How to create nightly backups in Linux  (Steve Wampler <swampler@noao.edu>)
Re: How to create nightly backups in Linux  ("Guy Rouillier" <guyr@masergy.com>)
Список pgsql-general
I'm using the  the following scheduler script to create nightly backups in
Windows:

set pgpassword=mypass
set FILENAME=%DATE:~8,4%%DATE:~5,2%%DATE:~2,2%mybackup.backup
"C:\Program Files\PostgreSQL\8.1\bin\pg_dump.exe" -i -Z9 -b -v -f
"%FILENAME%" -F c -h localhost -U postgres mydb

I'm bit new to Linux. I'm using white-box linux and Postgres 8.1.4
How to create backups of database with unique name in every night ?
Is there some script sample which can be called from /etc/crontab ?

Andrus.



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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Dead Lock problem with 8.1.3
Следующее
От: "Johan"
Дата:
Сообщение: Re: column names in select don't exists in insert to