Hi Tino and Michael, What storage subsystem do you use? This sounds like you want something like snapshots or similar to do backup. How long do you expect a 1-1.5 TB backup to run? I don't know. My biggest DBs are like 110 GB (compressed dump), 300-400 GB on disk and they are difficult to handle already. I would like that a backup runs during the system is live, a snapshot would be okay. How long would a 1-1.5 TB backup run for this size of a Postgres DB? To bring the backup back after a crash again live, I would want a solution which takes me one or two days but not longer. Do you think I can reach the target with a snapshot and also keep in mind the size of the DB? Cheers Thomas -----Original Message----- From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Tino Schwarze Sent: Montag, 30. Juni 2008 15:36 To: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] Recommended RAID for Postgres On Mon, Jun 30, 2008 at 03:15:34PM +0200, Thomas Bräutigam wrote: > Why avoid RAID5? I though that would be good? Can you explain this? RAID5 has a lot of disadvantages, especially in terms of performance. .oO(There was a link posted recently...) > 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? What storage subsystem do you use? This sounds like you want something like snapshots or similar to do backup. How long do you expect a 1-1.5 TB backup to run? I don't know. My biggest DBs are like 110 GB (compressed dump), 300-400 GB on disk and they are difficult to handle already. Maybe other Postgres admins have more experience with such big DBs. 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
