Postgres Pro
Downloads
Home   >   mailing lists

RE: WAL archive (archive_mode = always) ? - Mailing list pgsql-hackers

From Tsunakawa, Takayuki
Subject RE: WAL archive (archive_mode = always) ?
Date
Msg-id 0A3221C70F24FB45833433255569204D1FAE5273@G01JPEXMBYT05
Whole thread Raw
In response to WAL archive (archive_mode = always) ?  (Adelino Silva <adelino.j.silva@googlemail.com>)
Responses Re: WAL archive (archive_mode = always) ?  (Adelino Silva <adelino.j.silva@googlemail.com>)
List pgsql-hackers
Tree view 
From: Adelino Silva [mailto:adelino.j.silva@googlemail.com]
> What is the advantage to use archive_mode = always in a slave server compared
> to archive_mode = on (shared WAL archive) ?
> 
> I only see duplication of Wal files, what is the purpose of this feature ?

This also saves you the network bandwidth by not sending the WAL archive from the primary to the standby(s).  The
networkbandwidth can be costly between remote regions for disaster recovery.
 


Regards
Takayuki Tsunakawa

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: More issues with pg_verify_checksums and checksum verificationin base backups
Next
From: Stephen Frost
Date:
Subject: Re: More issues with pg_verify_checksums and checksum verificationin base backups