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

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

pgsql-novice by date

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

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