Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 8F46F9F978F for ; Fri, 24 Aug 2007 10:43:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 90279-05 for ; Fri, 24 Aug 2007 10:43:12 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.233]) by postgresql.org (Postfix) with ESMTP id 96B8E9F9824 for ; Fri, 24 Aug 2007 10:43:12 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id l8so473020nzf for ; Fri, 24 Aug 2007 06:43:11 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:subject:from:reply-to:to:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding; b=cRu5jsUeDs1yOK0iVXm7luw3xCUmfrPwLio0G68eWQdNGd+QpcneuFf1TUfF0wrWR9D05uVk7QUBN0sZ2vr0dlYUzp4tN3ixC+oqEilbxk+IfFSEsa9RGaEs5Qh9x40we1UWZBDQodOIL88GYh2hzmC0skloQvx+cKX76YIFHQE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:subject:from:reply-to:to:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding; b=F+5nkqlyl2pUj2Womuc/9nwVOWP0S0bGWqTr5CUAsywl672cixHzM0MV+53Jo9e10v38Z5iHNDJahh84L9v9EP/AbriFOXB71ESruCmL4zYjHT7iSBWNmtw4tJ5zL7aVZ9R98fqEl/BrqeMBfKYzoVU1Vyt3v+sIGabZNcp/HA4= Received: by 10.114.132.5 with SMTP id f5mr3476024wad.1187962989000; Fri, 24 Aug 2007 06:43:09 -0700 (PDT) Received: from ?192.168.1.212? ( [206.114.45.106]) by mx.google.com with ESMTPS id 15sm9132943nzn.2007.08.24.06.43.06 (version=SSLv3 cipher=RC4-MD5); Fri, 24 Aug 2007 06:43:07 -0700 (PDT) Subject: Re: PostgreSQL and virtualization From: Adam Tauno Williams Reply-To: adamtaunowilliams@gmail.com To: pgsql-admin@postgresql.org In-Reply-To: <46CEDC5C.6020801@andromeiberica.com> References: <46CEDC5C.6020801@andromeiberica.com> Content-Type: text/plain Date: Fri, 24 Aug 2007 09:43:26 -0400 Message-Id: <1187963006.4952.7.camel@aleph.wmmi.net> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/316 X-Sequence-Number: 26647 > I'd like to do some tests with replication, high availability, ... > with PostgreSQL. The problem I have is I don't have enough hardware to > do such tests, so I'd like to use virtualization. I'd like to do it > using linux. Nowadays there several products to do it Xen, Qemu, VMware, > ... and I don't have any experience with any of them. Anybody has tried > anything like this? Sure, I host PostgreSQL on vmware-server. As far as PostgreSQL or any application is concerned - it makes no difference at all - which is the point of virtualization. I'd recommend vmware-server because it is (a) free and (b) much more mature compared to the other two. The price of virtualization is slower I/O so for high loads you need (1) more RAM [never a bad thing anyway] and (2) emphasis on a good I/O subsystem [also never a bad thing].