Re: Backup Database Question

Поиск
Список
Период
Сортировка
От Raymond O'Donnell
Тема Re: Backup Database Question
Дата
Msg-id 4E8E0672.9090208@iol.ie
обсуждение исходный текст
Ответ на Re: Backup Database Question  (Carlos Mennens <carlos.mennens@gmail.com>)
Ответы Re: Backup Database Question  (Samba <saasira@gmail.com>)
Список pgsql-general
On 06/10/2011 20:18, Carlos Mennens wrote:
> On Thu, Oct 6, 2011 at 3:12 PM, John R Pierce <pierce@hogranch.com> wrote:
>>   /path/to/pg_dumpall | gzip > /path/to/pgbackup-$(date -I).sql.gz
>
> Thanks John. I've never written a script so do I just use 'Vim' to
> open a new file and just paste the following line?
>
> #!/bin/bash
> /usr/bin/pg_dumpall | gzip > /var/db_backup/pg_backup-$(date -I).sql.gz
>
> Is that all I need to do or is there more steps / data involved?

I think you also need to make it executable:

  chmod u+x my_backup_script

...or something like that.

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Backup Database Question
Следующее
От: Brandon Phelps
Дата:
Сообщение: Connection Pooling