pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kamil ADEM <kamila@aqvilasoftware.com>
To: Troels Arvin <troels@arvin.dk>
Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: RE: Initiate backup from routine?
Date: Wed, 17 Jan 2024 18:17:45 +0000
Message-ID: <40af2f8d9cfd4fd5b93dd81a975c9765@aqvilasoftware.com> (raw)
In-Reply-To: <409843b2-54ec-434f-a173-57c207744dda@arvin.dk>
References: <409843b2-54ec-434f-a173-57c207744dda@arvin.dk>

Hello Troels,

You can use the following statements in a procedure/function:
CREATE TEMPORARY TABLE tt_cmdout(cmdoutput text);
COPY tt_cmdout(cmdoutput) FROM PROGRAM 'pg_dump.exe <parameters>';

But note that the user must have SUPERUSER or BYPASSRLS privileges or must be table owner.

Ragards,
Kamil Adem


From: Troels Arvin <troels@arvin.dk>
Sent: Wednesday, January 17, 2024 5:41 PM
To: pgsql-general@lists.postgresql.org
Subject: Initiate backup from routine?


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




view thread (7+ messages)  latest in thread

Message-ID: <40af2f8d9cfd4fd5b93dd81a975c9765@aqvilasoftware.com>
Permalink:  ../40af2f8d9cfd4fd5b93dd81a975c9765@aqvilasoftware.com/
Also on:    postgresql.org/message-id/40af2f8d9cfd4fd5b93dd81a975c9765@aqvilasoftware.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: kamila@aqvilasoftware.com, troels@arvin.dk
  Subject: Re: Initiate backup from routine?
  In-Reply-To: <40af2f8d9cfd4fd5b93dd81a975c9765@aqvilasoftware.com>
  References: <409843b2-54ec-434f-a173-57c207744dda@arvin.dk> <40af2f8d9cfd4fd5b93dd81a975c9765@aqvilasoftware.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox