I did not have the logs activated but I need to know who have accessed my database is a postgres sql

Question

I did not have the logs activated but I need to know who have accessed my database is a postgres sql

Victor Alan Miranda Cortez 0

I did not have the logs activated but I need to know who have accessed my database to know that IP was used to access the system is there a way to get that historical the database is SQL progress?

Sai Raghunadh M 2,890 Reputation points Microsoft External Staff

2025-01-31T01:26:21.8133333+00:00

Hi @Victor Alan Miranda Cortez

Just checking in to see if the below answer provided by @Abiola Akinbade helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

Your answer

Sai Raghunadh M 2,890 Reputation points Microsoft External Staff

2025-01-31T01:26:21.8133333+00:00

Hi @Victor Alan Miranda Cortez

Just checking in to see if the below answer provided by @Abiola Akinbade helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Abiola Akinbade 24,745

Hello Victor Alan Miranda Cortez,

Thanks for your question.

To my knowledge, If logging wasn’t previously enabled, retrieving past access details isn’t possible. However, to ensure you have this information moving forward, you can set up logging and auditing features in Azure Database for PostgreSQL. See: Configure Logs

You can mark it 'Accept Answer' and 'Upvote' if this helped you

Regards,

Abiola

Sai Raghunadh M 2,890 Reputation points Microsoft External Staff

2025-02-03T02:30:22.17+00:00

Hi @Victor Alan Miranda Cortez

Just checking in to see if the above answer provided by @Abiola Akinbade helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

I did not have the logs activated but I need to know who have accessed my database is a postgres sql

1 answer

Your answer