Re: About rsync - Mailing list pgsql-general

From Stephen Frost
Subject Re: About rsync
Date
Msg-id Ze7erv8M+EXS3yo3@tamriel.snowman.net
Whole thread Raw
In response to About rsync  (Rama Krishnan <raghuldrag@gmail.com>)
List pgsql-general
Greetings,

* Rama Krishnan (raghuldrag@gmail.com) wrote:
> I have primary and stand by setup in that customer using wal_keep_segment
> very low number and database size were also high so that cilent asking with
> me in order use pgbase backup can't we use rsyn
>
> Here my question is if the wal is is presented on primary and not in
> standby then rsync will work but if the wal files were missed at primary if
> I am using rsync to the db will be work here please explain me

Not really following what's being asked here, but one thing that I can
certainly say is that rsync, by itself, is not an acceptable solution
for performing online backups of PostgreSQL.

I'd strongly suggest you continue to use pg_basebackup or look into a
more advanced tool like pgBackRest if you need a backup solution for
PostgreSQL.

Thanks,

Stephen

Attachment

pgsql-general by date:

Previous
From: Rama Krishnan
Date:
Subject: About rsync
Next
From: Michał Kłeczek
Date:
Subject: Pgxs - How to reference another extension