hot backup

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

hot backup

Steulet Grégory
Hi,
 
I just would like to know if it's possible to dot hot backup(not dump) with postgres.
 
Thank you
 
Greg
 

 

Grégory Steulet
Assistant HES         

 


HEG Haute école de gestion Arc
Laboratoire de Base de Données
84, rue de la Maladière
CH-2007 Neuchâtel


Tél.
Fax
Internet


+41 32 717 42 22
+41 32 889 60 33
http://libd.isnetne.ch

 
 
Reply | Threaded
Open this post in threaded view
|

Re: hot backup

Jeff Frost
On Wed, 3 Aug 2005, Steulet Grégory wrote:

> I just would like to know if it's possible to dot hot backup(not dump) with
> postgres.

That probably depends what you define as a hot backup. Likely what you are
looking for is Point in Time Recovery through WAL archiving.  Read about it
here:

http://www.postgresql.org/docs/8.0/interactive/backup-online.html

--
Jeff Frost, Owner <[hidden email]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org
Reply | Threaded
Open this post in threaded view
|

Re: hot backup

KÖPFERL Robert
In reply to this post by Steulet Grégory
yes, either by snapshot (Os-feature) or pg_dump
-----Original Message-----
From: Steulet Grégory [mailto:[hidden email]]
Sent: Mittwoch, 03. August 2005 10:47
To: [hidden email]
Subject: [ADMIN] hot backup

Hi,
 
I just would like to know if it's possible to dot hot backup(not dump) with postgres.
 
Thank you
 
Greg
 

 

Grégory Steulet
Assistant HES         

 


HEG Haute école de gestion Arc
Laboratoire de Base de Données
84, rue de la Maladière
CH-2007 Neuchâtel


Tél.
Fax
Internet


+41 32 717 42 22
+41 32 889 60 33
http://libd.isnetne.ch