Re: About backups

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