Обсуждение: Howto run PG 8.0 Online Backup

Поиск
Список
Период
Сортировка

Howto run PG 8.0 Online Backup

От
Renê Salomão
Дата:
Hello,

 I'm currently involved in determing if PG 8.0 fulfill our
expectations and it is applicable to upgrade our current versions of Pg
7.4& 7.3 into 8.xx...
 So far so good...
 My problem right now is concerning about online
backup... According to manual, I'm supposed to set up
archive_command(archive_command='cp %p /path/%f'), start backup
(select pg_start_backup('label')), and stop backup (select
pg_start_backup())... Question is: does PG copy according to
archive_command by itself or I'm responsable to manually copy files?

Thks...

-----------------------------

Cordialmente,

Renê Salomão
rene@ibiz.com.br
IBIZ Tecnologia - www.ibiz.com.br
(011) 5579-3178

--------------------------------

Re: Howto run PG 8.0 Online Backup

От
Bruce Momjian
Дата:
Ren� Salom�o wrote:
> Hello,
>
>  I'm currently involved in determing if PG 8.0 fulfill our
> expectations and it is applicable to upgrade our current versions of Pg
> 7.4& 7.3 into 8.xx...
>  So far so good...
>  My problem right now is concerning about online
> backup... According to manual, I'm supposed to set up
> archive_command(archive_command='cp %p /path/%f'), start backup
> (select pg_start_backup('label')), and stop backup (select
> pg_start_backup())... Question is: does PG copy according to
> archive_command by itself or I'm responsable to manually copy files?

The copies are done automatically using the command line you supplied.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073