Re: [ADMIN] [GENERAL] Storing database in WORM devices

2005-05-11 Thread Alex Turner
If you simply put your database tables in their own tablespace, then move that tablespace to a WORM device, I can't see why that wouldn't work as long as you keep all the system tables etc.. on the regular RW tablespace Alex Turner netEconomist On 5/11/05, [EMAIL PROTECTED] <[EM

Re: [ADMIN] [GENERAL] Storing database in WORM devices

2005-05-11 Thread Alex Turner
I think simply initialising the system causes writes in the system tables and the WAL... I'm sure someone more knowledgeable can chime in. Alex. Turner netEconomist On 5/11/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Why? Any specific reason that you are aware of ? > Are

Re: [ADMIN] IO Timeout

2005-03-11 Thread Alex Turner
think this puzzle is mostly solved - all we need to do now is figured out what the heck happened on the controller card! Thanks, Alex Turner On Thu, 10 Mar 2005 23:09:07 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: > Alex Turner <[EMAIL PROTECTED]> writes: > > Well - I am so

Re: [ADMIN] IO Timeout

2005-03-10 Thread Alex Turner
is pretty low though). Alex Turner netEconomist On Thu, 10 Mar 2005 19:04:29 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: > Alex Turner <[EMAIL PROTECTED]> writes: > > I have a question about IO timeouts: > > We are using the 3ware escalade 9500S series of cards, and we

[ADMIN] IO Timeout

2005-03-10 Thread Alex Turner
wait 30 seconds before it decided that the system was upset, and put the database in maintainence mode. Is there a way to increase to IO wait timeout so this doesn't happen? Alex Turner netEconomist ---(end of broadcast)--- TIP 1: subscribe and uns

Re: [GENERAL] Re: [ADMIN] Oracle and Postgresql Play Nice Together on Same Computer

2005-01-20 Thread Alex Turner
doing, and also reducing the amount of memory for Postgresql file cache. All in all, I would personaly be very wary of running both together if you are planning on doing any benchmarking. Alex Turner NetEconomist On Thu, 20 Jan 2005 10:20:02 +0100, [EMAIL PROTECTED] <[EMAIL PROTECTED