public inbox for [email protected]
help / color / mirror / Atom feedFrom: [email protected]
To: [email protected]
Subject: Re: About backups
Date: Mon, 26 Jan 2026 17:44:33 +0000 (UTC)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
Any method that allows me to know who accessed the database and when.
This is necessary for auditing the database. It's a requirement for financial applications.
I can't use a table within the database because it gets overwritten upon restoration.
I don't have admin access to the database server; in SQL Server, I resolved this using signed stored procedures.
On Monday, January 26, 2026 at 11:10:50 AM GMT-5, Adrian Klaver <[email protected]> wrote:
On 1/26/26 08:01, [email protected] wrote:
> Is there a way to implement the SQL Server command 'BACKUP DATABASE'?
Not from within the Postgres instance.
You will need to use:
https://www.postgresql.org/docs/current/app-pgdump.html
>
> Is there a way to see the restores performed on a database?
> Is there an equivalent table to msdb.dbo.restorehistory in SQL Server?
> Is there a way to implement an equivalent if one doesn't exist?
From what I understand there are various ways of doing this in SQL
Server, which way are you interested in?
>
> Thank you very much.
> Regards
>
> Félix
>
>
--
Adrian Klaver
[email protected]
view thread (10+ messages) latest in thread
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 using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: About backups
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox