Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

WAL backups



Hi,
I've only just started doing WAL backups, and so far am not able to
keep a running backup due to lack of hardware.
Obviously I gzip the WAL fioles, but I'm fast running out of disk
space. I have a second standy server with 200GB disk, where I store
the compressed WAL files, which quickly fills up.
Archiving is difficult simply because the server is in a server room
in Johannesburg 1000km away. We pay them to keep the server powered
up, safe, and connected. They can slip a DVD into it, but that
requires me to book it in advance, and it takes maybe a few hours
before they can do it.

I want to be able to do historical recoveries to any point in time if necessary.

I'm interested to hear from other's about hardware for backup.
I'm thinking of a second dedicated server offsite (near me), with a
large, large disk.

Thanks.
Brian
-- 
Brian Modra   Land line: +27 23 5411 462
Mobile: +27 79 183 8059
6 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group