Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Other: Postgres database user based soft delete capabilities

Not planned
Vivek Tiwari User

Right now softdelete can be configured in Oracle and sql server since both the databases records user information in T-log / ArchiveLogs. Its not possible in PostGresql Database as PG doesnt record user information in WAL logs. 

 

But user information is still recorded in many session tables and all other places in PG database. 

 

I want to request a feature in hvr by which it can do softdelete based on user who has submitted the delete/ purge.  

Thanks

Vivek 

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Mark Van de Wiel User

    Hi Vivek,

    Thank you for taking the time to submit this request.

    Unfortunately the user information is not available in the log. Sure it is in session information and can be retrieved from the dictionary at runtime. However, we cannot assume that we always run current replication. It must be possible for HVR to process the log stream even if there is no live database available.

    Introducing a feature that only works under certain conditions and/or may retrieve no data is in my opinion worse than not having the feature at all.

    If you can convince the PostgreSQL community to add this user information to the log then we'll absolutely take advantage of it!

    Mark.