Re: Howto run PG 8.0 Online Backup - Mailing list pgsql-novice

From Bruce Momjian
Subject Re: Howto run PG 8.0 Online Backup
Date
Msg-id 200408191716.i7JHG1L23806@candle.pha.pa.us
Whole thread Raw
In response to Howto run PG 8.0 Online Backup  (Renê Salomão <rene@ibiz.com.br>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Renê Salomão
Date:
Subject: Howto run PG 8.0 Online Backup
Next
From:
Date:
Subject: dup(0) failed after 3195 successes: Bad file descriptor