Greetings,
* Ron Johnson (ronljohnso...@gmail.com) wrote:
> On Wed, Jan 17, 2024 at 9:41 AM Troels Arvin wrote:
> > 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
From: Troels Arvin
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
On Wed, Jan 17, 2024 at 9:41 AM Troels Arvin wrote:
> 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
On Wednesday, January 17, 2024, Troels Arvin wrote:
Is it possible to call pg_dump (or equivalent action) through a
procedure/function?
You could create a new schema and table that holds a flag column or a
simple queue.
Then setup a script/app on a 5 minute cron that checks the status of the
Hello,
David wrote:
/ Are you able to install an untrusted language handler into the
database?/
Yes, if need be.
--
Regards,
Troels Arvin
On Wednesday, January 17, 2024, Troels Arvin wrote:
>
> Is it possible to call pg_dump (or equivalent action) through a
> procedure/function?
>
Are you able to install an untrusted language handler into the database?
They are untrusted because they can basically get shell on the server.
David
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