pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
About rsync
2+ messages / 2 participants
[nested] [flat]

* About rsync
@ 2024-03-11 10:22 Rama Krishnan <raghuldrag@gmail.com>
  2024-03-11 10:36 ` Re: About rsync Stephen Frost <sfrost@snowman.net>
  0 siblings, 1 reply; 2+ messages in thread

From: Rama Krishnan @ 2024-03-11 10:22 UTC (permalink / raw)
  To: pgsql-general

Hi Team,


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

Thanks
RK

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: About rsync
  2024-03-11 10:22 About rsync Rama Krishnan <raghuldrag@gmail.com>
@ 2024-03-11 10:36 ` Stephen Frost <sfrost@snowman.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Stephen Frost @ 2024-03-11 10:36 UTC (permalink / raw)
  To: Rama Krishnan <raghuldrag@gmail.com>; +Cc: 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

Attachments:

  signature.asc (application/pgp-signature, 832B) download

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2024-03-11 10:36 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-03-11 10:22 About rsync Rama Krishnan <raghuldrag@gmail.com>
2024-03-11 10:36 ` Stephen Frost <sfrost@snowman.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox