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 3E2083A2C43 for ; Thu, 20 Jan 2005 12:58:23 +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 91045-03 for ; Thu, 20 Jan 2005 12:58:14 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.204]) by svr1.postgresql.org (Postfix) with ESMTP id DEAF23A4730 for ; Thu, 20 Jan 2005 12:58:13 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id b11so3576rne for ; Thu, 20 Jan 2005 04:58:12 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:from:to:cc:subject:date:mime-version:content-type:x-mailer:in-reply-to:x-mimeole:thread-index:message-id; b=AauAunXn4y/X/GMJXaLJcfmQurHr4Fg1+P+0riZ/AHibuThKCQ5EWVEFEeXjcTXgPta27Ec3EqAHmHu4N+4akkdIbq+TaXanX3r5veN64BZ/t9nSItL8y6s1nGPk6pdtbxhqoyqdzcdq0OYAYGAdEpDomv+A83fXeORMf5tbyr0= Received: by 10.38.4.61 with SMTP id 61mr17381rnd; Thu, 20 Jan 2005 04:58:11 -0800 (PST) Received: from athena ([24.34.183.155]) by smtp.gmail.com with ESMTP id 63sm5324rna.2005.01.20.04.58.11; Thu, 20 Jan 2005 04:58:11 -0800 (PST) From: "Troyston Campano" To: , Cc: "'Ian Barwick'" Subject: Re: [GENERAL] Oracle and Postgresql Play Nice Together on Same Computer? Date: Thu, 20 Jan 2005 07:58:04 -0500 Mime-Version: 1.0 Content-Type: text/plain; X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: <1d581afe05012000067864ca78@mail.gmail.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 thread-index: AcT+xvrsYyyOZqQUSd+Xm2ycp2nW+gAKA+Bw Message-ID: <41efaae3.39b41852.390e.00a8@smtp.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.035 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200501/214 X-Sequence-Number: 16073 I guess what I am concerned about *is* running on a production server more than a test server. Basically, I'd be taking a couple applications that are running on the Oracle database instance, building a Postgresql instance, and migrating them to that postgresql database instance. I'm just wondering whether it's a bad idea to run them on the same server machine in a production environment. (So instead of having 10 applications running on Oracle on ServerComputerA...build a new postgresql instance on ServerComputerA that lives along with Oracle and migrating 3 of the applications to Postgresql. Thank you for your time! ~ Troyston Campano ~ -----Original Message----- From: Ian Barwick [mailto:barwick@gmail.com] Sent: Thursday, January 20, 2005 3:07 AM To: Troyston Campano Cc: pgsql-admin@postgresql.org; pgsql-general@postgresql.org Subject: Re: [GENERAL] Oracle and Postgresql Play Nice Together on Same Computer? On Thu, 20 Jan 2005 00:03:28 -0500, Troyston Campano wrote: > > Hello, > > 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 in > our environment. I want to install Postgresql onto a "production" server > that currently runs Oracle. Are there any problems with running Postgresql > and Oracle on the same machine? I mean, I've heard that the way Sybase and > 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). > > Are there any issues running Postgresql and Oracle on the same > machine.anything special to know about memory, disk layout, and things 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. 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