Hi Tino, Why avoid RAID5? I though that would be good? Can you explain this? Writing in the DB, I add about 5-10 GB of data a day. There is a lot of writing activity going on in the database every day. What do you recommend how often I should backup the complete database? Cheers Thomas -----Original Message----- From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Tino Schwarze Sent: Montag, 30. Juni 2008 14:53 To: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] Recommended RAID for Postgres On Mon, Jun 30, 2008 at 02:30:23PM +0200, Thomas Bräutigam wrote: > I have a pretty huge Postgres DB, about 1,3 to 1,5 Terra. Thats plenty of data. > 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? Avoid RAID5. Go for RAID10. BTW: I wonder how much the used filesystem affects Postgres' performance... > 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. How much writing activity is on the DB? WALs are probably the way to go. How often you backup the whole DB space (as a starting point for replaying WALs) depends on how much changes the DB gets. And how long it will take to restore the DB space and the WALs afterwards. HTH, Tino. -- "What we nourish flourishes." - "Was wir nähren erblüht." www.craniosacralzentrum.de www.forteego.de -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
