X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6B0F93A46F4 for ; Thu, 20 Jan 2005 08:06:50 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 47388-05 for ; Thu, 20 Jan 2005 08:06:44 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.192]) by svr1.postgresql.org (Postfix) with ESMTP id CE8083A46CC for ; Thu, 20 Jan 2005 08:06:44 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 50so99961wri for ; Thu, 20 Jan 2005 00:06:44 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=paJLmzCGbNv44S1n4RNdzc3tFFxxrvSyXKxzCtoXXN8cbsyb0xhVaG4pCxBmss7LMpyQhAclDdou06/X+LTqtluglVthmmwWDEw79YAPzF7LzCJFz+ZHF9UoZlFDX3njLv4VL4s9rjqok0qSIC5jzIPNH25A+jB1yfDS/zy+5Ug= Received: by 10.54.16.5 with SMTP id 5mr42443wrp; Thu, 20 Jan 2005 00:06:44 -0800 (PST) Received: by 10.54.5.58 with HTTP; Thu, 20 Jan 2005 00:06:44 -0800 (PST) Message-ID: <1d581afe05012000067864ca78@mail.gmail.com> Date: Thu, 20 Jan 2005 09:06:44 +0100 From: Ian Barwick Reply-To: Ian Barwick To: Troyston Campano Subject: Re: [GENERAL] Oracle and Postgresql Play Nice Together on Same Computer? Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org In-Reply-To: <41ef3ba8.6eecd830.614a.0054@smtp.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable References: <41ef3ba8.6eecd830.614a.0054@smtp.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.027 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200501/209 X-Sequence-Number: 16068 On Thu, 20 Jan 2005 00:03:28 -0500, Troyston Campano wrote: >=20 > Hello,=20 >=20 > I am an Oracle DBA and I want do a Postgresql 'proof of concept' at the > large corporation where I work to test the benefits of using Postgresql i= n > our environment. I want to install Postgresql onto a "production" server > that currently runs Oracle. Are there any problems with running Postgresq= l > and Oracle on the same machine? I mean, I've heard that the way Sybase an= d > DB2 UDB are architected to handle memory hurts Sybase when DB2 UDB is > installed on the same machine as the Sybase Server (something about UDB > eating up all the memory and not giving it back to Sybase).=20 >=20 > Are there any issues running Postgresql and Oracle on the same > machine=E2=80=A6anything special to know about memory, disk layout, and t= hings like > that? I just want to make sure the two engines play together on this same > server. I had a hard time finding information about this via google.=20 For testing purposes there shouldn't be any problems, at least in a *NIX environment. PostgreSQL is very undemanding and compared to Oracle is positively minuscule (at least as far as its "installation footprint" goes). I've run PostgreSQL, MySQL, DB2 and Oracle on the same development machine without any issues. Of course if another application is in constant use on a production server PostgreSQL won't perform as well as it could. Ian Barwick