pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PostgreSQL and virtualization
5+ messages / 5 participants
[nested] [flat]

* PostgreSQL and virtualization
@ 2007-08-24 13:25  Arnau <arnaulist@andromeiberica.com>
  0 siblings, 2 replies; 5+ messages in thread

From: Arnau @ 2007-08-24 13:25 UTC (permalink / raw)
  To: pgsql-admin

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?

Cheers!
-- 
Arnau



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: PostgreSQL and virtualization
@ 2007-08-24 13:43  Adam Tauno Williams <adamtaunowilliams@gmail.com>
  parent: Arnau <arnaulist@andromeiberica.com>
  1 sibling, 0 replies; 5+ messages in thread

From: Adam Tauno Williams @ 2007-08-24 13:43 UTC (permalink / raw)
  To: pgsql-admin

>    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].




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: PostgreSQL and virtualization
@ 2007-08-24 14:28  Joshua D. Drake <jd@commandprompt.com>
  parent: Arnau <arnaulist@andromeiberica.com>
  1 sibling, 1 reply; 5+ messages in thread

From: Joshua D. Drake @ 2007-08-24 14:28 UTC (permalink / raw)
  To: arnaulist@andromeiberica.com; +Cc: pgsql-admin

-----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.

Joshua D. Drake

> 
> Cheers!


- --

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/
			UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGzusaATb/zqfZUUQRAo8WAJ9S1lvZbEaEj9X09Z+xFAzD0d8ASACggLQC
QtD7JslEJ5W7GyuHdlUk1TU=
=ohtU
-----END PGP SIGNATURE-----



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: PostgreSQL and virtualization
@ 2007-08-27 09:14  Johann Spies <jspies@sun.ac.za>
  parent: Joshua D. Drake <jd@commandprompt.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Johann Spies @ 2007-08-27 09:14 UTC (permalink / raw)
  To: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: PostgreSQL and virtualization
@ 2007-08-27 17:04  Medi Montaseri <montaseri@gmail.com>
  parent: Johann Spies <jspies@sun.ac.za>
  0 siblings, 0 replies; 5+ messages in thread

From: Medi Montaseri @ 2007-08-27 17:04 UTC (permalink / raw)
  To: Johann Spies <jspies@sun.ac.za>; pgsql-admin

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
>

^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2007-08-27 17:04 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-08-24 13:25 PostgreSQL and virtualization Arnau <arnaulist@andromeiberica.com>
2007-08-24 13:43 ` Adam Tauno Williams <adamtaunowilliams@gmail.com>
2007-08-24 14:28 ` Joshua D. Drake <jd@commandprompt.com>
2007-08-27 09:14   ` Johann Spies <jspies@sun.ac.za>
2007-08-27 17:04     ` Medi Montaseri <montaseri@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox