Re: pg_stop_backup fails to complete

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: pg_stop_backup fails to complete
Date: 2011-05-23 11:56:15
Message-ID: BANLkTimu8Do_+x9pT5FG5xaQR2O8GDGkdA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Mon, May 23, 2011 at 11:56 AM, Birchall, Austen
<austen(dot)birchall(at)metoffice(dot)gov(dot)uk> wrote:
> I trying to do a backup on my test database however I get
>
> testrec=# select pg_stop_backup();
> WARNING:  pg_stop_backup still waiting for archive to complete (60 seconds
> elapsed)
> WARNING:  pg_stop_backup still waiting for archive to complete (120 seconds
> elapsed)

This means your archive_command has not successfully executed.

Read the server log and find out why, then fix.

Please include the version in use when reporting possible problems. Thanks.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Frank Bax 2011-05-23 14:09:29 Re: how to select rows for a sum function
Previous Message Birchall, Austen 2011-05-23 10:56:05 pg_stop_backup fails to complete