Try Postgres 8.4 Beta1 using OpenSolaris Appliance for VirtualBox

Postgres 8.4 Beta1 community binaries are now for OpenSolaris 2008.11. The Beta1 binaries for OpenSolaris can be downloaded from postgresql.org binary location. Postgres 8.4 binaries for Solaris 10 are also available.

For people who don't have OpenSolaris installed on their laptop but want to try out the new improved DTrace Probes in Postgres 8.4beta1, you can install the Minimal OpenSolaris Appliance OVF image for VirtualBox 2.2 and install the Postgres 8.4beta1 binaries in the appliance to try it out. You can also use the DTrace probes on your Mac OS X too.

Easiest way to install the binaries on the OpenSolaris Appliance is to first install SUNWwget package from the OpenSolaris repository

pkg install SUNWwget

and then using copy the download mirror url for those binaries using http and download it with wget in the appliance

wget "http://wwwmaster.postgresql.org/redir/198/h/binary/v8.4beta\\
/solaris/opensolaris/i386/postgresql-8.4beta1-opensolaris.i386-32.tar.bz2"

The community binaries typically should be untarred in /opt.

bzcat postgresql-8.4beta1-opensolaris.i386-32.tar.bz2 |tar -xf -

This will then have the binaries in /opt/postgres/8.4beta1/. If you also untar the 64-bit binaries then the the 64-bit binaries are available from /opt/postgres/8.4beta1/64.

One thing that I have noticed with these binaries that it does not pick up the libraries if installed in /opt by default so depending on the type of bits you may need to set the following

LD_LIBRARY_PATH=/opt/postgres/8.4beta1/lib; export LD_LIBRARY_PATH

or

LD_LIBRARY_PATH_64=/opt/postgres/8.4beta1/lib/64; export LD_LIBRARY_PATH_64

Beyond that everything should work as you would expect. Well almost... One thing to also note is that the new 8.4 GUC parameter effective_io_concurrency to allow readahead for bitmap scan index scans is disabled on OpenSolaris / Solaris 10.

 If you do find something that doesn't seem to work, please feel free to leave comments.

 

Comments:

1. For creatin gmore secure Virtual Appliances itself can be interesting new Postgresql feature , identify usrrs by certificates.

2. Is there docs how to use a D-trace on Postresgl like this one for MySQl ?

Optimizing MySQL Database Application Performance with Solaris Dynamic Tracing
http://wikis.sun.com/display/BluePrints/Optimizing+MySQL+Database+Application+Performance+with+Solaris+Dynamic+Tracing

Posted by VirtualGuru on April 22, 2009 at 01:38 AM EDT #

Can OpenSolaris run like a server? for 400 clients?

Posted by Hugo on April 22, 2009 at 02:40 AM EDT #

Hi Hugo,

Current VM allocates 1 core for the OpenSolaris Appliance VM. VirtualBox 2.2 does not support SMP. However even with 1 core, if the underlying processor/system is powerful enough then it can handle significant number of clients. How many? That depends on the type of work each client does. If it is simple get-set type of operations then yes probably very high. If it is very cpu intensive then probably 2-4 clients can saturate the VM. Best way to know is try it out for your workload and report back what you see.

Hope this helps.

Posted by Jignesh Shah on April 22, 2009 at 02:53 AM EDT #

Hugo,

if your question was releated to OpenSolaris 2008.11 in general , then yes it can run like a server. Infact we do lot of performance work with OpenSolaris running as a server handling more than 1200 clients. Again notion of clients depends on the work it does.

Posted by Jignesh Shah on April 22, 2009 at 02:57 AM EDT #

"Jignesh Shah published a HOWTO on trying Postgres 8.4 Beta1 using OpenSolaris Appliance for VirtualBox."

<a href="http://www.pythian.com/news/2182/log-buffer-143-a-carnival-of-the-vanities-for-dbas">Log Buffer #143</a>

Posted by Log Buffer on April 24, 2009 at 07:47 AM EDT #

Post a Comment:
Comments are closed for this entry.
About

Jignesh Shah is Principal Software Engineer in Application Integration Engineering, Oracle Corporation. AIE enables integration of ISV products including Oracle with Unified Storage Systems. You can also follow me on my blog http://jkshah.blogspot.com

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today