From: | David Steele <david(at)pgmasters(dot)net> |
---|---|
To: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>, pgsql-general(at)postgresql(dot)org, ramkumar(dot)yelai(at)siemens(dot)com |
Subject: | Re: Pgbasebackup help |
Date: | 2015-12-04 12:38:02 |
Message-ID: | 5661892A.3000105@pgmasters.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 12/2/15 6:25 PM, Jim Nasby wrote:
> On 12/2/15 1:56 PM, David Steele wrote:
>>> >Also, I don’t want enable archive_mode = on as it needs to maintain
>>> >archives files.
>> As it turns out, archiving would be the solution to your problem. If
>> you were archiving you could restore a*previous* backup and then replay
>> WAL to exactly T3. There might be some jitter from clock differences
>> but it should have the desired effect.
>
> And in this case previous could be a PG backup taken immediately before
> the backup of the private DBMS.
Exactly.
> I don't remember off-hand if pg_basebackup has an option for delaying
> the pg_stop_backup() call, but if it does then I think the simplest
> thing is to just delay that until after your private DBMS backup is
> complete.
There's no option to delay it in pg_basebackup but it can be called
whenever you like when using pg_start/stop_backup. So, yeah, if the
postgres backup were started first then pg_stop_backup() could be called
right after the private backup stops. That would make them pretty much
in sync.
Of course, it's a lot of work to get that going. pg_basebackup does a
lot of work for you.
--
-David
david(at)pgmasters(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | David Steele | 2015-12-04 12:56:19 | Re: Pgbasebackup help |
Previous Message | Bill Moran | 2015-12-04 12:17:58 | Re: JDBC and inet type |