Re: [GENERAL] RAID0 and pg_xlog

2005-09-10 Thread Tatsuo Ishii
> On Fri, 2005-09-09 at 18:54, Jim C. Nasby wrote: > > On Fri, Sep 09, 2005 at 06:20:21PM -0500, Scott Marlowe wrote: > > > > pgpool is a connection pool; it has (almost) nothing to do with > > > > replication. It certainly doesn't work to provide any kind of data > > > > security on a RAID0 setup.

Re: [GENERAL] RAID0 and pg_xlog

2005-09-09 Thread Tatsuo Ishii
> > On Fri, Sep 09, 2005 at 06:20:21PM -0500, Scott Marlowe wrote: > > > > pgpool is a connection pool; it has (almost) nothing to do with > > > > replication. It certainly doesn't work to provide any kind of data > > > > security on a RAID0 setup. > > > > > > > > I'm not arguing against anything

Re: [GENERAL] RAID0 and pg_xlog

2005-09-09 Thread Jim C. Nasby
On Fri, Sep 09, 2005 at 06:20:21PM -0500, Scott Marlowe wrote: > > pgpool is a connection pool; it has (almost) nothing to do with > > replication. It certainly doesn't work to provide any kind of data > > security on a RAID0 setup. > > > > I'm not arguing against anything people have suggested, o

Re: [GENERAL] RAID0 and pg_xlog

2005-09-09 Thread Scott Marlowe
On Fri, 2005-09-09 at 18:54, Jim C. Nasby wrote: > On Fri, Sep 09, 2005 at 06:20:21PM -0500, Scott Marlowe wrote: > > > pgpool is a connection pool; it has (almost) nothing to do with > > > replication. It certainly doesn't work to provide any kind of data > > > security on a RAID0 setup. > > > >

Re: [GENERAL] RAID0 and pg_xlog

2005-09-09 Thread Scott Marlowe
On Fri, 2005-09-09 at 18:16, Jim C. Nasby wrote: > On Fri, Sep 09, 2005 at 09:43:56AM -0500, Scott Marlowe wrote: > > On Wed, 2005-09-07 at 16:15, Jim C. Nasby wrote: > > > On Wed, Sep 07, 2005 at 01:02:18PM -0500, Scott Marlowe wrote: > > > > On Wed, 2005-09-07 at 12:40, Jim C. Nasby wrote: > > >

Re: [GENERAL] RAID0 and pg_xlog

2005-09-09 Thread Jim C. Nasby
On Fri, Sep 09, 2005 at 09:43:56AM -0500, Scott Marlowe wrote: > On Wed, 2005-09-07 at 16:15, Jim C. Nasby wrote: > > On Wed, Sep 07, 2005 at 01:02:18PM -0500, Scott Marlowe wrote: > > > On Wed, 2005-09-07 at 12:40, Jim C. Nasby wrote: > > > > On Wed, Sep 07, 2005 at 12:47:43PM -0700, Qingqing Zhuo

Re: [GENERAL] RAID0 and pg_xlog

2005-09-09 Thread Scott Marlowe
On Wed, 2005-09-07 at 16:15, Jim C. Nasby wrote: > On Wed, Sep 07, 2005 at 01:02:18PM -0500, Scott Marlowe wrote: > > On Wed, 2005-09-07 at 12:40, Jim C. Nasby wrote: > > > On Wed, Sep 07, 2005 at 12:47:43PM -0700, Qingqing Zhuo wrote: > > > > Xlog will be the only believable data if your system cr

Re: [GENERAL] RAID0 and pg_xlog

2005-09-07 Thread Jim C. Nasby
On Wed, Sep 07, 2005 at 01:02:18PM -0500, Scott Marlowe wrote: > On Wed, 2005-09-07 at 12:40, Jim C. Nasby wrote: > > On Wed, Sep 07, 2005 at 12:47:43PM -0700, Qingqing Zhuo wrote: > > > Xlog will be the only believable data if your system crashed. So it is a > > > dangerous practice to put xlog s

Re: [GENERAL] RAID0 and pg_xlog

2005-09-07 Thread Scott Marlowe
On Wed, 2005-09-07 at 12:40, Jim C. Nasby wrote: > On Wed, Sep 07, 2005 at 12:47:43PM -0700, Qingqing Zhuo wrote: > > Xlog will be the only believable data if your system crashed. So it is a > > dangerous practice to put xlog stuff in RAID0. > > No more or less so than putting your main database

Re: [GENERAL] RAID0 and pg_xlog

2005-09-07 Thread Welty, Richard
Jim C. Nasby wrote: >No more or less so than putting your main database on RAID0. If any >drive fails, you lose everything. perhaps it's time to start writing it [^r]A[^i]D 0 to try and make the point. richard ---(end of broadcast)--- TIP 5: don't

Re: [GENERAL] RAID0 and pg_xlog

2005-09-07 Thread Jim C. Nasby
On Wed, Sep 07, 2005 at 12:47:43PM -0700, Qingqing Zhuo wrote: > Xlog will be the only believable data if your system crashed. So it is a > dangerous practice to put xlog stuff in RAID0. No more or less so than putting your main database on RAID0. If any drive fails, you lose everything. -- Jim

Re: [GENERAL] RAID0 and pg_xlog

2005-09-07 Thread Qingqing Zhuo
Xlog will be the only believable data if your system crashed. So it is a dangerous practice to put xlog stuff in RAID0.   Regards, Qingqing "Carlos Benkendorf" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... Hi,   Does it make any sense to change the pg_xlog position