Re: Hot backup in PostgreSQL

From: Paul Förster <paul(dot)foerster(at)gmail(dot)com>
To: "W(dot)P(dot)" <laurentp(at)wp(dot)pl>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Hot backup in PostgreSQL
Date: 2020-10-22 06:46:58
Message-ID: 0A5B194D-1EDD-4354-B6DB-564CCF3ED63D@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Laurent,

> On 22. Oct, 2020, at 08:42, 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?

yes, there is. Please read the chapter: 25.3.3.1. Making A Non-Exclusive Low-Level Backup

https://www.postgresql.org/docs/current/continuous-archiving.html#BACKUP-LOWLEVEL-BASE-BACKUP

Cheers,
Paul

In response to

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2020-10-22 07:35:17 Re: Hot backup in PostgreSQL
Previous Message W.P. 2020-10-22 06:42:08 Hot backup in PostgreSQL