Re: Hot backup in PostgreSQL

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.

https://www.postgresql.org/docs/11/app-pgbasebackup.html

On Thu, Oct 22, 2020 at 12:12 PM W.P. <laurentp(at)wp(dot)pl> 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.
>
>
>
>