Re: Basebackup - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Basebackup
Date
Msg-id 6202aa6d565279470c4b1fe4c895342d954f8df4.camel@cybertec.at
Whole thread Raw
In response to Basebackup  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
List pgsql-admin
On Tue, 2024-09-03 at 18:01 +0530, Rajesh Kumar wrote:
> How different is basebackup from new server with primary host and rsync from primary,  move to new server and start
cluster?

The main difference is that you have to stop the server if you want to use "rsync",
otherwise the backup will be inconsistent.

A backup taken with "pg_basebackup" will be recovered when you start it.

You *can* perform an online file system backup with "rsync", but then you will
have to use the low-level backup API:
https://www.postgresql.org/docs/current/continuous-archiving.html#BACKUP-LOWLEVEL-BASE-BACKUP

Yours,
Laurenz Albe



pgsql-admin by date:

Previous
From: ajit wangkhem
Date:
Subject: Re: Basebackup
Next
From: Asad Ali
Date:
Subject: Re: Basebackup