Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC) - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)
Date
Msg-id 1189087685.7470.21.camel@hannu-laptop
Whole thread Raw
In response to Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)  (apoc9009 <apoc9009@yahoo.de>)
List pgsql-hackers
Ühel kenal päeval, N, 2007-09-06 kell 12:53, kirjutas apoc9009:
> I wish to have an Solution, thadt backup my Database DB wihout 
> Datalosses, 

Then you need the backup record to be completed on the backup machine
before the transaction commit returns on master.

This is quaranteed to be really slow for any significant transaction
rate but can be done using DRBD.

>  without locking Tables, 

No backup I know of needs locking tables

> without Shutdown 

This one I just don't understand. Shtdown what ?

> without any User must be forced for logging out (Backup in 
> Production State Online without Datalosses). 

So you want the user to still be connected to the failed machine, but at
the same time be connected to the new live failover machine ?

-----
Hannu





pgsql-hackers by date:

Previous
From: "korry.douglas"
Date:
Subject: Re: Has anyone tried out the PL/pgSQL debugger?
Next
From: "Kevin Grittner"
Date:
Subject: Re: Just-in-time Background Writer Patch+Test Results