Re: Hot backup in PostgreSQL

Поиск
Список
Период
Сортировка
От Sushant Pawar
Тема Re: Hot backup in PostgreSQL
Дата
Msg-id CAF2=t-rHuv5k9O=3OCs90+FLjjOEfVzTvARUDJD2YnHrd0JArg@mail.gmail.com
обсуждение исходный текст
Ответ на Hot backup in PostgreSQL  ("W.P." <laurentp@wp.pl>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Devrim Gündüz
Дата:
Сообщение: Re: How to get debuginfo from building source code
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Initplan placed at the righttree or the lefttree of joinnode