Re: pg_archivecleanup with multiple slaves

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <elatllat(at)gmail(dot)com>,<benlancaster(at)holler(dot)co(dot)uk>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_archivecleanup with multiple slaves
Date: 2011-05-20 13:15:30
Message-ID: 4DD62322020000250003D9C3@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Tim wrote:

> I would just make 2 copies of the WAL file one for each slave in
> different folders.
> That way if one slave is offline for a period of time it can
> catch up when it comes back online.

If you used hard links, that wouldn't even take any extra disk
space (beyond the directory space). I would copy to a staging
directory, hard link (cp -l) to each of the target directories,
and then delete from the staging area.

-Kevin

Browse pgsql-admin by date

  From Date Subject
Next Message Mark Johnson 2011-05-20 13:27:26 Re: LDAP Authentication
Previous Message Raghavendra 2011-05-20 12:54:57 Re: LDAP Authentication