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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

 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?



Renê Salomão
IBIZ Tecnologia -
(011) 5579-3178



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-2017 The PostgreSQL Global Development Group