pg_stop_backup fails to complete

Поиск
Список
Период
Сортировка
От Birchall, Austen
Тема pg_stop_backup fails to complete
Дата
Msg-id A2E53AF8AE1C284C8F8B648653C0920B1D6A5029@EXXMAIL02.desktop.frd.metoffice.com
обсуждение исходный текст
Ответы Re: pg_stop_backup fails to complete  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-novice

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)

Etc.

If I do a ctrl-C I then get

testrec=# select pg_stop_backup();
ERROR:  a backup is not in progress
testrec=#

I tried doing a  select pg_switch_xlog(); before/during and after the backup but this didn't help

I've seen this error in the lists but I am still unsure what's going on.

Can anybody explain what's happening and how to 'fix' it?

Thanks

Austen

Austen Birchall  Senior Database Administrator
Met Office
FitzRoy Road Exeter EX1 3PB United Kingdom
Tel: +44 (0)1392 884481 Fax: +44 (0)1392 885681
E-mail: austen.birchall@metoffice.gov.uk Website:
http://www.metoffice.gov.uk

В списке pgsql-novice по дате отправления:

Предыдущее
От: e-letter
Дата:
Сообщение: how to select rows for a sum function
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: pg_stop_backup fails to complete