Hi,
If the requirement is to take online backup(hot) backup that can be used to do point in time recovery, you can rely on low-level API functionality mentioned earlier by Paul. If you to be care free about not missing any specific mount point other than default mount point, you can use pg_basebackup for online backup.
Pg_basebackup will take care of backing up all database files including custom tablespace and has the option to compress the backup.You can refer to below link for more information.
On Thu, Oct 22, 2020 at 12:12 PM W.P. <laurentp@xxxxx> wrote:
Hi there,
how to do "hot backup" (copying files) while database running?
Not using pg_dump.
Is there some equivalent of Oracle (I knew v8) "ALTER DATABASE BEGIN
BACKUP", which froze writes to database files, pushing everything to
redo files?
Laurent.
