Re: Cron job doing VACUUM and BACUP from root

Поиск
Список
Период
Сортировка
От Oliver Elphick
Тема Re: Cron job doing VACUUM and BACUP from root
Дата
Msg-id 200011050006.eA506lm04352@linda.lfix.co.uk
обсуждение исходный текст
Ответ на Cron job doing VACUUM and BACUP from root  ("Aage J. Skjolingstad" <aages@aajs.com>)
Список pgsql-interfaces
"Aage J. Skjolingstad" wrote:
  >Have been searching around the last two days to find some scripts or
  >cron jobs to automate backup and vacuum.
  >
  >I'm running a small db on PSQL 7.02 / RH 7 and keeping my login as
  >root.
  >
  >I know how to set up cron from root and I believe it should be
  >possible to call the job from root, or am I totally wrong.
  >
  >For what I have been doing I only get FATAL 1 errors, believe that's
  >from not being in su postgres ?
  >
  >Any help and assistance (step by step) to a novice would be helpful.



Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Train up a child in the way he should go; and when he
      is old, he will not depart from it."   Proverbs 22:6

Вложения

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

Предыдущее
От: Dave Page
Дата:
Сообщение: RE: Cron job doing VACUUM and BACUP from root
Следующее
От: Carolyn Lu Wong
Дата:
Сообщение: Need help with ODBC error