Re: Scheduling a backup job (was: pgAdmin III v1.4.3 released)

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: Scheduling a backup job (was: pgAdmin III v1.4.3 released)
Дата
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E40154C0D4@ratbert.vale-housing.co.uk
обсуждение исходный текст
Ответы Re: Scheduling a backup job (was: pgAdmin III v1.4.3 released)  (Antoine <melser.anton@gmail.com>)
Список pgadmin-support
Please post support request to the list, and don't hi-jack
innappropriate subjects!

> -----Original Message-----
> From: Christian Hozee [mailto:Christian.Hozee@rivm.nl]
> Sent: 20 July 2006 10:55
> To: Dave Page
> Subject: Re: [pgadmin-support] pgAdmin III v1.4.3 released
>
> Dear Dave,
>
> Thanks for your reply. I have downloaded and installed
> Pgadmin 1.4.3 but I
> can't figure out how to schedule a backup job once a week. I
> have searched
> Pgadmin.org but I can't figure it out. I hope you can help me out.

On Unix? Simply create a job with an appropriate schedule, and add a
batch/shell step to do the work. You can either just call an external
script, or write the script into the step itself, e.g.

#!/bin/sh

/usr/local/pgsql/bin/pg_dumpall -h 127.0.0.1 -U postgres -p 5432 >
/var/backups/mydbdump.sql

On Windows, just use batch syntax instead of shell, and in either case,
specify the complete set of options the pg_dumpall (or pg_dump) requires
to dump the required cluster.

Regards, Dave.


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

Предыдущее
От: "Dave Page"
Дата:
Сообщение: pgAdmin III v1.4.3 released
Следующее
От: Antoine
Дата:
Сообщение: Re: Scheduling a backup job (was: pgAdmin III v1.4.3 released)