Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 4023D63323E for ; Mon, 29 Mar 2010 11:52:04 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 61181-07-2 for ; Mon, 29 Mar 2010 14:51:53 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ww0-f46.google.com (mail-ww0-f46.google.com [74.125.82.46]) by mail.postgresql.org (Postfix) with ESMTP id 59D9A63321A for ; Mon, 29 Mar 2010 11:50:03 -0300 (ADT) Received: by wwe15 with SMTP id 15so8307066wwe.19 for ; Mon, 29 Mar 2010 07:50:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:received:message-id :subject:from:to:content-type; bh=iKiZypFmh8NUQua4OBjfY0xxtqof/gF2Uxrgk1IB+dc=; b=N9Fp4jj0oNxyGkqtVDFqqFWvOLe1JUel1bo12Y/1LGPkog6cuXa9pEQGsmbG5X9s40 BvHkpOo9tmdY5xQ9tSM072y6xnSimZWSAj3DjBiSeTLhxDDEbg/dQ//VB3atmCHnW3bF MenU3uaTeJqHeNOpDvqy/4X7Mf24I5ZLxMRPs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=Z1Pg7XOYrGsPZGAIM14cBG653mvXpD3BHLhizxMTqhyAhaMhR0KCXjeCSQ0t5m+QYM y/H6bgMKmNRH0SLl3OPdPhVAIuiYiDF4qqU+k7GEV4Wkf0aBvTR/2ngZR3neTohzwbDq /fbX4/CJETnzxq0DZG0eiHrR1ghF2Ire+EfVs= MIME-Version: 1.0 Received: by 10.216.159.148 with HTTP; Mon, 29 Mar 2010 07:50:01 -0700 (PDT) Date: Mon, 29 Mar 2010 11:50:01 -0300 Received: by 10.216.86.196 with SMTP id w46mr3000580wee.201.1269874201192; Mon, 29 Mar 2010 07:50:01 -0700 (PDT) Message-ID: Subject: Virtualization vs. sharing a server From: Ramiro Barreca To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=0016e6d99b98abec8a0482f1a052 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.598 tagged_above=-10 required=5 tests=BAYES_00=-2.599, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201003/228 X-Sequence-Number: 34027 --0016e6d99b98abec8a0482f1a052 Content-Type: text/plain; charset=ISO-8859-1 At this moment we are considering a plan for upgrading many servers in our datacenter. As this is a very heterogeneous platform (from Oracle 10g, SQL Server 2008, Firebird 2.1, Mysql 5, Postgre 8.4 up to Informix 5 and even COBOL apps) whe are evaluating Virtualization or just sharing a server among PostgreSQL and firebird or MySQL. As Virtualiaztion is almost discarded after reading many articles that locate this option in the "don'ts-list", we want to know your experience (if any) about installing a PostgreSQL and a Firebird server in the same Linux server. Postgre is the DB that we are trying to migrate from Firebird, but this process will demand several months to conclude. 1. Is there a configuration option we need to consider to share this server? 2. What is the recomended hardware for a PostgreSQL server that has to support between 500 and 1000 simultaneous user connections? Is there a whitepaper about this? Thanks in advance. -- Ramiro Barreca rbarreca@gmail.com --0016e6d99b98abec8a0482f1a052 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable At this moment we are considering a plan for upgrading many servers in our = datacenter.
As this is a very heterogeneous platform (from Oracle 10g, = SQL Server 2008, Firebird 2.1, Mysql 5, Postgre 8.4 up to Informix 5 and ev= en COBOL apps) whe are evaluating Virtualization or just sharing a server a= mong PostgreSQL and firebird or MySQL.
As Virtualiaztion is almost discarded after reading many articles that= locate this option in the "don'ts-list", we want to know you= r experience (if any) about installing a PostgreSQL and a Firebird server i= n the same Linux server.
Postgre is the DB that we are trying to migrate from Firebird, but thi= s process will demand several months to conclude.=A0
  1. Is there a configuration option we need to consider to= share this server?
  2. What is the recomended hardware for a PostgreSQ= L server that has to support between 500 and 1000 simultaneous user connect= ions? Is there a whitepaper about this?
Thanks in advance.

--
Ramiro Barreca
rbarreca@gmail.com
--0016e6d99b98abec8a0482f1a052--