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

apoc9009 wrote:
> Hi Hackers,
>
> In my Project i have to handle a Database with 600 GByte Text only,
> distributed on 4 Tablespaces
> on multiple Harddisks and Remote SAN's connected via Gigaethernet to the
> Remote SAN-Storage.
>
> I need more flexibility by doing Backups of my big Database, but the
> built in Online Backupsystem
> dont work for my Setup good enought for me. I Can not accept 16 MByte
> big WAL's Files
> for securing it on Tape. 16 MByte Data loss on a Crash Situation is
> Fatal and no helpfully
> (1 MByte to). I wish to have a continoues Backup without any data losses.

http://www.postgresql.org/docs/8.2/static/warm-standby.html
Particularly section 23.4.4

That can get you to 1 second or less.

--
Richard Huxton
Archonet Ltd