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(dot)klaver(at)aklaver(dot)com> wrote:

On 1/26/26 08:01, felix(dot)quintgz(at)yahoo(dot)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(dot)klaver(at)aklaver(dot)com