Skip site navigation (1) Skip section navigation (2)

Re: Hard link / rsync backup strategy successful

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Chander Ganesan" <chander(at)otg-nc(dot)com>
Cc: "[ADMIN]" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Hard link / rsync backup strategy successful
Date: 2009-07-16 22:23:56
Message-ID: 4A5F622C02000025000288B1@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-admin
Chander Ganesan <chander(at)otg-nc(dot)com> wrote: 
 
> I suppose you just have to be careful to make a copy of the cluster
> before trying to start it up (lest you break an older or newer
> backup).
 
Yeah, you don't want to get confused and have the warm standby using a
hard link to a backup.  The trick is to *only* use the cp -l from one
backup copy to another, and then only update the new copy with rsync. 
If you keep that straight, it's not too hard....
 
-Kevin

In response to

pgsql-admin by date

Next:From: rasaDate: 2009-07-17 09:16:38
Subject: Re: PostgreSQL using 100% CPU
Previous:From: Chander GanesanDate: 2009-07-16 22:19:03
Subject: Re: Hard link / rsync backup strategy successful

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group