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 <adrian.klaver@aklaver.com> wrote:
On 1/26/26 08:01, felix.quintgz@yahoo.com 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
adrian.klaver@aklaver.com
