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