pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Thomas Bräutigam <thomas.braeutigam@nexustelecom.com>
To: pgsql-admin@postgresql.org
Subject: Recommended RAID for Postgres
Date: Mon, 30 Jun 2008 14:30:23 +0200
Message-ID: <46F5921DF52F6E40860287B30CADADC79463A3@EROS.nexus-ag.com> (raw)

Hello all,
 
I have a pretty huge Postgres DB, about 1,3 to 1,5 Terra. What do you guys recommend on RAID Levels for this Database. Which does Postgres recommend, and with which do Postgres run very good or in the best way?
 
What Backup Strategy do you think would be the best. Dump the DB once a week or work with the WAL`s? For your info, the data which is feeded to the database is available and could be feeded again but it would maybe take a couple of days. So what would be a solution to bring up the huge DB in about one day after a crash. This would be the target.
 
Thanks for a feedback and Cheers Thomas

view thread (8+ messages)  latest in thread

Message-ID: <46F5921DF52F6E40860287B30CADADC79463A3@EROS.nexus-ag.com>
Permalink:  ../46F5921DF52F6E40860287B30CADADC79463A3@EROS.nexus-ag.com/
Also on:    postgresql.org/message-id/46F5921DF52F6E40860287B30CADADC79463A3@EROS.nexus-ag.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: thomas.braeutigam@nexustelecom.com
  Subject: Re: Recommended RAID for Postgres
  In-Reply-To: <46F5921DF52F6E40860287B30CADADC79463A3@EROS.nexus-ag.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox