Quick Links

Hot backup in PostgreSQL

From:	"W(dot)P(dot)" <laurentp(at)wp(dot)pl>
To:	pgsql-general(at)lists(dot)postgresql(dot)org
Subject:	Hot backup in PostgreSQL
Date:	2020-10-22 06:42:08
Message-ID:	486ad2c5-01e0-fbf7-b09d-88898b28cdb0@wp.pl
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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.

Responses

Re: Hot backup in PostgreSQL at 2020-10-22 06:46:58 from Paul Förster
Re: Hot backup in PostgreSQL at 2020-10-22 07:35:17 from hubert depesz lubaczewski
Re: Hot backup in PostgreSQL at 2020-10-22 13:02:14 from Sushant Pawar
Re: Hot backup in PostgreSQL at 2020-10-22 15:13:39 from Adam Brusselback

Browse pgsql-general by date

	From	Date	Subject
Next Message	Paul Förster	2020-10-22 06:46:58	Re: Hot backup in PostgreSQL
Previous Message	Ian Lawrence Barwick	2020-10-22 03:52:13	Re: How to get debuginfo from building source code