For complement only...

If you are trying to do backup pay attemption on Postgres' 22.3. On-line backup and point-in-time recovery (PITR). It's introduced on version 8.x and permit filesystem backup without lock tables (mysqlhotcopy do it!).