From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Streaming Replication - changing IP addresses |
Date: | 2014-12-09 18:51:54 |
Message-ID: | 548744CA.1040004@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 12/9/2014 9:07 AM, Dara Unglaube wrote:
> Is this neccessary? What is the benefit of having the archive on?
> Could I map a network drive from the slave to the master and set the
> archive_command to that mapped drive? Or what would be the best
> approach for this?
having a wal archive lets the slave resume after a service interruption
faster, and also farther back than your wal_keep_Segments setting would
otherwise allow.
having a wal archive, along with occasional base backups will let you do
'point in time recovery' (PITR) right up to a specified transaction, as
long as you have a base backup from prior to that transaction and all
wal archives since that base backup.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
From | Date | Subject | |
---|---|---|---|
Next Message | Arthur Silva | 2014-12-09 19:44:45 | Re: Help Optimizing a Summary Query |
Previous Message | Robert DiFalco | 2014-12-09 18:18:56 | Re: Help Optimizing a Summary Query |