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

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 (view raw or flat)
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

pgsql-novice by date

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

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