Postgres Pro
Downloads
Home   >   mailing lists

Re: Hot backup in PostgreSQL - Mailing list pgsql-general

From Sushant Pawar
Subject Re: Hot backup in PostgreSQL
Date
Msg-id CAF2=t-rHuv5k9O=3OCs90+FLjjOEfVzTvARUDJD2YnHrd0JArg@mail.gmail.com
Whole thread Raw
In response to Hot backup in PostgreSQL  ("W.P." <laurentp@wp.pl>)
List pgsql-general
Tree view
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@wp.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.



pgsql-general by date:

Previous
From: Devrim Gündüz
Date:
Subject: Re: How to get debuginfo from building source code
Next
From: Tom Lane
Date:
Subject: Re: Initplan placed at the righttree or the lefttree of joinnode