Re: [GENERAL] Recomended FS

2003-10-25 Thread Murthy Kambhampaty
This has been discussed on the XFS list. Basically, IIRC, you have to get a drive tool like OnTrak, attach the drive via the IDE controller, disable the cache, then reconnect it to the 3-ware controller (which does not include an option to disable write caching; pester 3ware). >-Original Mes

Re: [GENERAL] summary and request

2003-08-16 Thread Murthy Kambhampaty
I like the COALESCE() function for the "insert into ..." statement below. See: http://www.postgresql.org/docs/7.3/interactive/functions-conditional.html#AE N9753 Cheers, Murthy -Original Message- From: Jason Godden To: [EMAIL PROTECTED] Sent: 8/15/2003 7:33 PM Subject: Re: [GENERAL] sum

Re: [GENERAL] importing db as text files

2003-08-15 Thread Murthy Kambhampaty
On Friday, August 15, 2003 03:53, expect [mailto:[EMAIL PROTECTED] wrote: >On Fri, 15 Aug 2003 00:32:01 -0700 (PDT) >Stephan Szabo <[EMAIL PROTECTED]> wrote: > ... >> Given >> create table test( >> a text default 'abc', >> b int default 5 >> ); >> >> copy test from stdin with delimiter ','; >> ,

Re: [GENERAL] importing db as text files

2003-08-15 Thread Murthy Kambhampaty
>-Original Message- >From: expect [mailto:[EMAIL PROTECTED] >Sent: Friday, August 15, 2003 11:56 >To: [EMAIL PROTECTED] >Subject: Re: [GENERAL] importing db as text files > > >On Fri, 15 Aug 2003 11:32:20 -0400 >Murthy Kambhampaty <[EMAIL PROTECTED]> wrote

Re: [GENERAL] postgres+daemontools

2003-08-06 Thread Murthy Kambhampaty
We recently started using daemontools to manage the herd of postmasters (see the recent thread regarding running multiple postmasters on a single machine), and its working quite well. We still have to figure out how to mimic the "pg_ctl stop -m fast|immediate" modes, svc -d /service/ mimics "pg_c