Re: [GENERAL] 3 x PostgreSQL in cluster/redunant

2005-11-15 Thread Trent Shipley
On Tuesday 2005-11-15 13:06, Joshua D. Drake wrote: > Michelle Konzack wrote: > > Am 2005-11-14 16:54:41, schrieb Jim C. Nasby: > >> On Mon, Nov 14, 2005 at 07:36:44PM +0100, Michelle Konzack wrote: > >>> Hello *, > >>> > >>> I have three Sun Server where I have reserved on each Server a Raid-5 > >

Re: [GENERAL] 3 x PostgreSQL in cluster/redunant

2005-11-15 Thread Joshua D. Drake
Michelle Konzack wrote: Am 2005-11-14 16:54:41, schrieb Jim C. Nasby: On Mon, Nov 14, 2005 at 07:36:44PM +0100, Michelle Konzack wrote: Hello *, I have three Sun Server where I have reserved on each Server a Raid-5 of 1 TByte for my PostgreSQL. The first PostgreSQL is up and running w

Re: [GENERAL] 3 x PostgreSQL in cluster/redunant

2005-11-15 Thread Jim C. Nasby
On Tue, Nov 15, 2005 at 07:38:06PM +0100, Michelle Konzack wrote: > Am 2005-11-14 16:54:41, schrieb Jim C. Nasby: > > On Mon, Nov 14, 2005 at 07:36:44PM +0100, Michelle Konzack wrote: > > > Hello *, > > > > > > I have three Sun Server where I have reserved on each Server a Raid-5 > > > of 1 TByte

Re: [GENERAL] 3 x PostgreSQL in cluster/redunant

2005-11-15 Thread Michelle Konzack
Am 2005-11-14 16:54:41, schrieb Jim C. Nasby: > On Mon, Nov 14, 2005 at 07:36:44PM +0100, Michelle Konzack wrote: > > Hello *, > > > > I have three Sun Server where I have reserved on each Server a Raid-5 > > of 1 TByte for my PostgreSQL. The first PostgreSQL is up and running > > with a database

Re: [GENERAL] 3 x PostgreSQL in cluster/redunant

2005-11-15 Thread Michael Glaesemann
On Nov 15, 2005, at 19:03 , Johnny Ljunggren wrote: Sorry for my ignorance but what is WAL? Neither Google nor Wikipedia could come up with an explanation. http://www.postgresql.org/docs/current/static/wal.html http://www.google.com/search?hl=en&q=postgresql+wal&btnG=Google+Search Hopeful

Re: [GENERAL] 3 x PostgreSQL in cluster/redunant

2005-11-15 Thread Johnny Ljunggren
Jim C. Nasby wrote: Keep in mind that databases and RAID5 generally don't mix very well. What is the ideal setup of a database server when it comes to storage? You also want to put the WAL on a seperate set of drives from the main database (though again that doesn't buy much if your database

Re: [GENERAL] 3 x PostgreSQL in cluster/redunant

2005-11-14 Thread Jim C. Nasby
On Tue, Nov 15, 2005 at 12:09:40AM +0100, Johnny Ljunggren wrote: > Jim C. Nasby wrote: > >On Mon, Nov 14, 2005 at 07:36:44PM +0100, Michelle Konzack wrote: > >>I have three Sun Server where I have reserved on each Server a Raid-5 > > >Keep in mind that databases and RAID5 generally don't mix very

Re: [GENERAL] 3 x PostgreSQL in cluster/redunant

2005-11-14 Thread Johnny Ljunggren
Jim C. Nasby wrote: On Mon, Nov 14, 2005 at 07:36:44PM +0100, Michelle Konzack wrote: I have three Sun Server where I have reserved on each Server a Raid-5 Keep in mind that databases and RAID5 generally don't mix very well. oh, how come? What is the ideal setup of a database server when it

Re: [GENERAL] 3 x PostgreSQL in cluster/redunant

2005-11-14 Thread Jim C. Nasby
On Mon, Nov 14, 2005 at 07:36:44PM +0100, Michelle Konzack wrote: > Hello *, > > I have three Sun Server where I have reserved on each Server a Raid-5 > of 1 TByte for my PostgreSQL. The first PostgreSQL is up and running > with a database of 150 GByte. Keep in mind that databases and RAID5 gen

Re: [GENERAL] 3 x PostgreSQL in cluster/redunant

2005-11-14 Thread Scott Marlowe
On Mon, 2005-11-14 at 12:36, Michelle Konzack wrote: > Hello *, > > I have three Sun Server where I have reserved on each Server a Raid-5 > of 1 TByte for my PostgreSQL. The first PostgreSQL is up and running > with a database of 150 GByte. > > Now I like to make the three Sun Servers redunant