From: Mikko Partio <mpartio@gmail.com>
To: Thomas Bräutigam <thomas.braeutigam@nexustelecom.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Recommended RAID for Postgres
Date: Mon, 7 Jul 2008 11:28:28 +0300
Message-ID: <2ca799770807070128l2498e9c3pe5d9e469d0dc8269@mail.gmail.com> (raw)
In-Reply-To: <46F5921DF52F6E40860287B30CADADC79463A3@EROS.nexus-ag.com>
References: <46F5921DF52F6E40860287B30CADADC79463A3@EROS.nexus-ag.com>
On Mon, Jun 30, 2008 at 3:30 PM, Thomas Bräutigam <
thomas.braeutigam@nexustelecom.com> wrote:
> 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?
>
We are running one ~2 TB database, mainly read-only stuff except for at
batch import process every night. We are using RAID5 (RAID10 would require
too many hard disk drives).
> 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.
>
I'd say that backup (using filesystem tools) the database once a week or
fortnight and archive wals everyday. That's what we are doing and it's been
working just fine.
Regards
Mikko
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: mpartio@gmail.com, thomas.braeutigam@nexustelecom.com
Subject: Re: Recommended RAID for Postgres
In-Reply-To: <2ca799770807070128l2498e9c3pe5d9e469d0dc8269@mail.gmail.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