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]
