Re: Archive fails due to missing backup file

From: Payal Singh <payal(at)omniti(dot)com>
To: Robert Burgholzer <rburghol(at)vt(dot)edu>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Archive fails due to missing backup file
Date: 2013-11-21 15:09:43
Message-ID: CANUg7LBCtieuULf1Zk-DRkmqBKhHzvyP5y0cz8M=pr_ZVWdUxw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Also, if you are using a script/program for this, having set -x and
checking program logs might help too.

Payal Singh,
OmniTi Computer Consulting Inc.
Junior Database Architect,
Phone: 240.646.0770 x 253

On Thu, Nov 21, 2013 at 10:08 AM, Payal Singh <payal(at)omniti(dot)com> wrote:

> I would check the file and directory permissions.
>
> Payal Singh,
> OmniTi Computer Consulting Inc.
> Junior Database Architect,
> Phone: 240.646.0770 x 253
>
>
> On Thu, Nov 21, 2013 at 7:34 AM, Robert Burgholzer <rburghol(at)vt(dot)edu>wrote:
>
>> My archiving is failing on the master with the following error, any help
>> would be much appreciated:
>>
>> The failed archive command was: rsync -a
>> pg_xlog/00000003000002A00000004B.0000CD40.backup postgres(at)dbase1
>> :/data/postgres/master_walf/00000003000002A00000004B.0000CD40.backup
>>
>>
>> --
>> --
>> Robert W. Burgholzer
>> 'Making the simple complicated is commonplace; making the complicated
>> simple, awesomely simple, that's creativity.' - Charles Mingus
>> Athletics: http://athleticalgorithm.wordpress.com/
>> Science: http://robertwb.wordpress.com/
>> Wine: http://reesvineyard.wordpress.com/
>>
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Robert Burgholzer 2013-11-21 15:27:52 INSERT performance tuning experiences
Previous Message Payal Singh 2013-11-21 15:08:53 Re: Archive fails due to missing backup file