X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id CFB78D1BB89 for ; Thu, 12 Feb 2004 20:58:38 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 92482-10 for ; Thu, 12 Feb 2004 16:58:35 -0400 (AST) Received: from ecintweb.eldocomp.com (smtp.eldocomp.com [205.159.99.8]) by svr1.postgresql.org (Postfix) with ESMTP id 04003D1B911 for ; Thu, 12 Feb 2004 16:58:31 -0400 (AST) Received: by ecintweb.eldocomp.com with XWall v3.29 ; Thu, 12 Feb 2004 13:58:15 -0700 From: Naomi Walker To: "pgsql-admin@postgresql.org" Subject: Distributed Environment Date: Thu, 12 Feb 2004 13:58:14 -0700 X-Assembled-By: XWall v3.29 X-Mailer: QUALCOMM Windows Eudora Version 5.1 Message-ID: <5.1.0.14.2.20040212134618.03537788@imap.eldocomp.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/183 X-Sequence-Number: 12357 We currently use a legacy database (DB/C) for our application. Because it= =20 is old and funky, the only reasonable way at the moment to get decent=20 ODBC-accessed realtime reporting data, is by using a Veritas clustered file= =20 system (on our Sun platforms). This will work since the underlying code=20 uses fcntl. In the meantime, we are (very slowly) rewriting our application to use=20 postgres and java servlets. It will probably be years before we are=20 completely off DB/C. Still, I hate to spend gobs of money on the clustered= =20 file system, since I do not believe it will work with Postgres, since the= =20 locking mechanism is in shared memory. When we are all postgres, i'll=20 probably use replication for realtime data copying to a report server. Unless, of course, someone is considering making postgres work in a=20 distributed environment. Is this on anyones to-do list? Does anyone think= =20 it would be an important addition to postgres? Naomi ---------------------------------------------------------------------------= ---------------------------------------------- Naomi Walker Chief Information Officer Eldorado Computing, Inc. nwalker@eldocomp.com 602-604-3100 ---------------------------------------------------------------------------= ---------------------------------------------- Forget past mistakes. Forget failures. Forget everything except what you're= =20 going to do now and do it. - William Durant, founder of General Motors ---------------------------------------------------------------------------= --------------------------------------------- -- CONFIDENTIALITY NOTICE -- This message is intended for the sole use of the individual and entity to w= hom it is addressed, and may contain information that is privileged, confid= ential and exempt from disclosure under applicable law. If you are not the = intended addressee, nor authorized to receive for the intended addressee, y= ou are hereby notified that you may not use, copy, disclose or distribute t= o anyone the message or any information contained in the message. If you ha= ve received this message in error, please immediately advise the sender by = reply email, and delete the message. Thank you.