dbTalk Databases Forums  

Howto run PG 8.0 Online Backup

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss Howto run PG 8.0 Online Backup in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Renê Salomão
 
Posts: n/a

Default Howto run PG 8.0 Online Backup - 08-19-2004 , 12:08 PM






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

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly


Reply With Quote
  #2  
Old   
Bruce Momjian
 
Posts: n/a

Default Re: Howto run PG 8.0 Online Backup - 08-19-2004 , 12:16 PM






Renê Salomão wrote:
Quote:
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 (AT) candle (DOT) 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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.