Thread: hot backup

hot backup

From
Steulet Grégory
Date:
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

 
 

Re: hot backup

From
Jeff Frost
Date:
  This message is in MIME format.  The first part should be readable text,
  while the remaining parts are likely unreadable without MIME-aware tools.

---481964751-187987940-1123219547=:4931
Content-Type: TEXT/PLAIN; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8BIT

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     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954
---481964751-187987940-1123219547=:4931--

Re: hot backup

From
KÖPFERL Robert
Date:
yes, either by snapshot (Os-feature) or pg_dump
-----Original Message-----
From: Steulet Grégory [mailto:Gregory.Steulet@he-arc.ch]
Sent: Mittwoch, 03. August 2005 10:47
To: pgsql-admin@postgresql.org
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