Howto run PG 8.0 Online Backup

From: Renê Salomão <rene(at)ibiz(dot)com(dot)br>
To: pgsql-novice(at)postgresql(dot)org
Subject: Howto run PG 8.0 Online Backup
Date: 2004-08-19 17:08:32
Message-ID: 20040819140832.15c3548e.rene@ibiz.com.br
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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(at)ibiz(dot)com(dot)br
IBIZ Tecnologia - www.ibiz.com.br
(011) 5579-3178

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruce Momjian 2004-08-19 17:16:01 Re: Howto run PG 8.0 Online Backup
Previous Message Tom Tom 2004-08-19 09:16:47 drop all tables in db - without dropdb ?!