OpenSolaris 2008.05 and Open Source Databases

Lets start at the point where you have just installed OpenSolaris OS 2008.05 and have logged in using your primary userid on the system.

First thing to do is install the packages for PostgreSQL and MySQL on OpenSolaris OS 2008.05. Right click on the desktop and select "Open Terminal" to start a terminal session. Use "su" to assume the root userid. (The primary user already has root role however some programs still explicitly check for userid of root and hence needed to avoid unexpected surprises.)

Verify pkg is able to communicate with the IPS repository.

# pkg search -r postgres

INDEX      ACTION    VALUE                     PACKAGE

basename   dir       usr/postgres              pkg:/SUNWpostgr-82-client@8.2.6-0.86

basename   dir       usr/postgres              pkg:/SUNWpostgr-82-contrib@8.2.6-0.86

basename   dir       usr/postgres              pkg:/SUNWpostgr-82-devel@8.2.6-0.86

basename   dir       usr/postgres              pkg:/SUNWpostgr-82-docs@8.2.6-0.86

basename   dir       usr/postgres              pkg:/SUNWpostgr-82-jdbc@8.2.504-0.86

basename   dir       usr/postgres              pkg:/SUNWpostgr-82-libs@8.2.6-0.86

basename   dir       usr/postgres              pkg:/SUNWpostgr-82-pl@8.2.6-0.86

basename   dir       var/postgres              pkg:/SUNWpostgr-82-server-data-root@8.2.6-0.86

basename   file      usr/postgres/8.2/bin/postgres pkg:/SUNWpostgr-82-server@8.2.6-0.86

basename   dir       usr/postgres              pkg:/SUNWpostgr-82-tcl@1.5-0.86

basename   file      usr/bin/postgres          pkg:/SUNWpostgr-server@8.1.11-0.86

basename   dir       usr/postgres              pkg:/SUNWpostgr-82-l10n-ja@0.5.11-0.86

This confirms that the repository is accessible. If this does not work confirm you have internet connection and/or try:

#  svcadm restart nwam

which currently takes some time to bring a small popup saying the interface is plumbed up and has an IP address assigned.  Anyway lets assume that the internet connects well and we are ready to install the Packages of PostgreSQL and MySQL

To install PostgreSQL binaries (currently PostgreSQL 8.2.6 32-bit  is available):

# pkg install SUNWpostgr-82-client SUNWpostgr-82-contrib SUNWpostgr-82-devel SUNWpostgr-82-docs SUNWpostgr-82-jdbc SUNWpostgr-82-libs SUNWpostgr-82-pl SUNWpostgr-82-server-data-root SUNWpostgr-82-server SUNWpostgr-82-tcl SUNWpostgr-server SUNWpostgr-82-l10n-ja

DOWNLOAD                                    PKGS       FILES     XFER (MB)

Completed                                  13/13   3159/3159   64.03/64.03

PHASE                                        ACTIONS

Install Phase                              3688/3688

Now to install PgAdminIII

 # pkg install SUNWpgadmin3

DOWNLOAD                                    PKGS       FILES     XFER (MB)

Completed                                    1/1     281/281   21.46/21.46

PHASE                                        ACTIONS

Install Phase                                378/378

 

Now to install MySQL packages:

# pkg install SUNWmysql-base SUNWmysql-base SUNWmysql SUNWmysql5test SUNWmysql5 SUNWmysqlt

DOWNLOAD                                    PKGS       FILES     XFER (MB)

Completed                                    5/5   2727/2727 160.65/160.65

PHASE                                        ACTIONS

Update Phase                                     2/2

Install Phase                              2971/2971

If you also want to install webmin:

# pkg install SUNWwebmin

DOWNLOAD                                    PKGS       FILES     XFER (MB)

Completed                                    1/1 19946/19946   40.35/40.35

PHASE                                        ACTIONS

Install Phase                            24298/24298

With this we are now setup with the most common packages required to use Open Source Databases PostgreSQL and MySQL on OpenSolaris 2008.05