Initiate backup from routine?

Поиск
Список
Период
Сортировка
Искать
От
Troels Arvin
Тема
Initiate backup from routine?
Дата
Msg-id
409843b2-54ec-434f-a173-57c207744dda@arvin.dk
Список
Дерево обсуждения
Re: Initiate backup from routine? Pyrote <pyromania@guungle.com>

Hello,

I would like to allow a co-worker to perform a backup of a database, such that the backup is saved to the database server itself. One use case is that (s)he would like an extra backup of a database, just before an application update is deployed. The co-worker doesn't have shell access on the DB server (so no sudo option), and we would like to allow this to happen without having to involve a DBA.

Is it possible to call pg_dump (or equivalent action) through a procedure/function?

--
Regards,
Troels Arvin


В списке pgsql-general по дате отправления
От: Dominique Devienne
Дата:
От: David G. Johnston
Дата:
FAQ