Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 925579FA316 for ; Mon, 27 Aug 2007 14:04:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 29592-07 for ; Mon, 27 Aug 2007 14:04:03 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.182]) by postgresql.org (Postfix) with ESMTP id 28EB59FA269 for ; Mon, 27 Aug 2007 14:04:01 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id u77so1183557pyb for ; Mon, 27 Aug 2007 10:04:01 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=uAtL27pVbvkdTbIqYXPdqe5JHdEBCCrdjAzt3Vmg8/maH24wE2WVagelDar0JC49EKX7lnY62nPAtIxIh+VFe50zAETXR8AQM9cwVZCzUkEmBuy6m5zi3/QTZCIVLwSMYhYAexdOQqem7P00rz8QHofsi15boSaOS6N1saihIR0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=Uy7VRdBq9sWHh4C43tunGjmUfC87amM1wHY8iWd7rYMA1Gk3XW4RQugPEJcK2LuLpQl+OMJLPci+4mw7TCwB52azElxj4JAxGMF6VD872d+vof95tBGV0cVoXIy39dPV8HevKUVNmZmZI97WbT4ahGKZf5q3xB4ZV4qldfR1AE4= Received: by 10.64.196.9 with SMTP id t9mr11185008qbf.1188234240140; Mon, 27 Aug 2007 10:04:00 -0700 (PDT) Received: by 10.65.110.15 with HTTP; Mon, 27 Aug 2007 10:04:00 -0700 (PDT) Message-ID: <8078a1730708271004g869c572y372a7bee2f844950@mail.gmail.com> Date: Mon, 27 Aug 2007 10:04:00 -0700 From: "Medi Montaseri" To: "Johann Spies" , pgsql-admin@postgresql.org Subject: Re: PostgreSQL and virtualization In-Reply-To: <20070827091403.GA28060@sun.ac.za> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_203615_30208194.1188234240083" References: <46CEDC5C.6020801@andromeiberica.com> <46CEEB1B.4090500@commandprompt.com> <20070827091403.GA28060@sun.ac.za> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/331 X-Sequence-Number: 26662 ------=_Part_203615_30208194.1188234240083 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Another view is...by the time you figure out all these virtualization solutions you can buy a used box for less than $100 (no monitor needed) and focus on the real test. By the way, in any HA one issue will be the IP takeover on the surviving node. Under the IP will be the Mac address of the previous primary node which is now cached in switches and/or routers so a rebuild of the ARP cache will be needed. I am not sure how these virtualizations play the MAC game but minimally your test is tainted from that point of the view Cheers Medi On 8/27/07, Johann Spies wrote: > > On Fri, Aug 24, 2007 at 07:28:43AM -0700, Joshua D. Drake wrote: > > -----BEGIN PGP SIGNED MESSAGE----- > > Hash: SHA1 > > > > Arnau wrote: > > > Hi all, > > > > > > 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? > > > > Vmware server is free (as in beer) as it by far the easiest to get > > running. However, it will also be slower than Xen. If you are just > > testing, use VMWare. > > You can also look at VirtualBox (www.virtualbox.org). I my experience > it is as easy as VMWare and faster. > > Regards > Johann > > -- > Johann Spies Telefoon: 021-808 4036 > Informasietegnologie, Universiteit van Stellenbosch > > "But the end of all things is at hand; be ye therefore > sober, and watch unto prayer. And above all things > have fervent love among yourselves; for love shall > cover the multitude of sins." I Peter 4:7,8 > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > ------=_Part_203615_30208194.1188234240083 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Another view is...by the time you figure out all these virtualization solutions you can buy a used box for less than $100 (no monitor needed) and focus on the real test. By the way, in any  HA one issue will be the IP takeover on the surviving node. Under the IP will be the Mac address of the previous primary node which is now cached in switches and/or routers so a rebuild of the ARP cache will be needed. I am not sure how these virtualizations play the MAC game but minimally your test is tainted from that point of the view

Cheers
Medi

On 8/27/07, Johann Spies <jspies@sun.ac.za> wrote:
On Fri, Aug 24, 2007 at 07:28:43AM -0700, Joshua D. Drake wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Arnau wrote:
> > Hi all,
> >
> >   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?
>
> Vmware server is free (as in beer) as it by far the easiest to get
> running. However, it will also be slower than Xen. If you are just
> testing, use VMWare.

You can also look at VirtualBox (www.virtualbox.org).  I my experience
it is as easy as VMWare and faster.

Regards
Johann

--
Johann Spies          Telefoon: 021-808 4036
Informasietegnologie, Universiteit van Stellenbosch

     "But the end of all things is at hand; be ye therefore
      sober, and watch unto prayer. And above all things
      have fervent love among yourselves; for love shall
      cover the multitude of sins."      I Peter 4:7,8

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

------=_Part_203615_30208194.1188234240083--