Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)

Поиск
Список
Период
Сортировка
От apoc9009
Тема Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)
Дата
Msg-id 46E039CD.8000400@yahoo.de
обсуждение исходный текст
Ответ на Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)  (Hannu Krosing <hannu@skype.net>)
Список pgsql-hackers
Simon Riggs schrieb:
> On Thu, 2007-09-06 at 12:53 +0200, apoc9009 wrote:
>   
>>> You've either not read 23.4.4 or haven't understood it. If the text is 
>>> unclear, documentation additions/changes are always welcome.
>>>       
>> I have read this:
>>
>> PostgreSQL directly supports file-based log shipping as described above. 
>> It is also possible to implement record-based log shipping, though this 
>> requires custom development.
>>     
>
> We may expect that feature in later releases, but definitely not in 8.3
>
>   
>> I wish to have an Solution, thadt backup my Database DB wihout 
>> Datalosses,  without locking Tables, without Shutdown
>> and without any User must be forced for logging out (Backup in 
>> Production State Online without Datalosses).
>>     
>
> I'm not clear whether you are looking for Backup, or High Availability
> Replication.
>
> There is no data loss with the online backup technique described in the
> manual.
>   
No, there is a lost of Data.

The WAL File musst bei generated by the Postmaster and this File must be 
copied to the
safe Remote Backupserver. If the Machine, where the Database is running 
crashed, then the Last
WAL is lost and the Backup isnt complet,e this is the Center of the Problem.
> If you require HA replication with zero data-loss then you are currently
> restricted to non-database techniques, which you already mentioned, so
> you have your answer already.
>   
we talking about Backup this isnt the same as Replication.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: apoc9009
Дата:
Сообщение: Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)
Следующее
От: John DeSoi
Дата:
Сообщение: Re: Has anyone tried out the PL/pgSQL debugger?