Installing pgAdminIII for PostgreSQL 9 on Ubuntu

pgAdmin is the best GUI you can use to administrate PostgreSQL, unffortunately the Ubuntu default packages still offer only PostgreSQL 8.4 and an older version of pgAdmin III that does not support PostgreSQL 9.0.x. Thanks to Martin Pitt who maintains the latest packages you can run and maintain the latest PostgreSQL versions.

If you run Maverick:

  • sudo apt-key adv –keyserver keyserver.ubuntu.com –recv-keys 8683D8A2
  • sudo apt-get update
  • sudo apt-get install pgadmin3

Check here for latest or other releases of Ubuntu.

How to install PostgreSQL on OpenSolaris

The installation is not straight forward as a double-click “setup.exe” on Windows. I summarized the steps to get a running PostgreSQL 8.3.x installation on OpenSolaris 2008.11. All done using a terminal session. Commands to execute in green.

  1. Login or open terminal as root user.
  2. pkg install SUNWpostgr-83-server
  3. pkg install SUNWpostgr-83-client
    Continue reading

How to Install Netbeans 6.5 on OpenSolaris

If you are spoilt with double-click Installers and hardly ever opened a DOS-Box, you might be challenged getting some applications up and running in Linux, Unix or OpenSolaris. The Package Manager offers you quite a huge selection of applications and tools that you just select and install, but some stuff requires some manual steps, like Netbeans.

Prerequisites
– Downloaded Netbeans (netbeans-6.5-ml-solaris-x86.sh, link here)
– Installed JDK (link here)

Create JAVA_HOME and PATH
– export JAVA_HOME=/{your jdkpath}
– export PATH=$PATH:$JAVA_HOME/bin:$JAVA_HOME/jre/bin
– Add too add to /etc/profile

Installing Netbeans
– Open terminal session as normal user
– Navigate to the folder with the netbeans-6.5-ml-solaris-x86.sh file
– Make it executable chmod +x netbeans-6.5-ml-solaris-x86.sh
xhost +
– Change to root user su –
export DISPLAY=:0.0
– Execute Installer ./netbeans-6.5-ml-solaris-x86.sh
– Rest self-explaining by the standard interactive GUI installer.

I also recommend to visit the plugins to get the latest updates.

Good Luck

Installing OpenSolaris 2008.11

I downloaded the LiveCD already a while ago, but only after the last SUN TechDays here I was inspired to finally install it.

Requirements: OpenSolaris LiveCD and any Mac or PC.

Before starting: Dont waste your time and bandwidth downloading the CD image. FIRST check if your hardware gonna work with OpenSolaris ! SUN offers a smart Java tool (link here) to check your hardware and available driver.

Get Started: Fairly easy Get the ISO file (link here), create a CD and start on any desktop or notebook up. It is a LiveCD, so it starts up from CD and you can play around with it until you decide to install it (there is a desktop shortcut!) or trash it. Note that all application need to be loadd from CD, so this does not refelct the real performance of an installed system.

Out of 2 desktops and 2 notebooks only 1 works fine, or better all drivers were available:
Notebook Dell Vostro 1500 with Intel 8400, 4GB, NVDIA 8600,..

On 2 desktops there was no lan driver available.

On a Notebook Compaq CQ40 during starting from CD the loudspeaker creates a extreme loud squeeching noise which you cant switch of, after hearing this for 1 minute you wont go further.

Extra Software I installed so far:

  • Virtualbox
  • JDK 1.6_11
  • Netbeans 6.5 with Python addon
  • OpenOffice 3.0
  • MySQL

Problems so far (with my hardware!):
Switching on all desktop special effects and flipping between desktops makes desktop freeze und you only can close windows that are already open.

The next release will hit the road in April 2009.

Install Glassfish on a virtual server (Part 2)

Using the same virtual server I tried to install Glassfish V3 (prelude) which comes in a 26MB zip-file. At least I would avoid the installer complaining about not enough memory available. After unzipping the server and with proper JAVA_HOME path all we need to do is to start the server with /glassfishv3-prelude/glassfish/bin/asadmin start-domain

Starting: java -jar -Xmx128m admin-cli.jar start-domain (here with 128MB setting)

I would get the same error in the logfile in domain1/logs/jvm.log

<tty>
<writer thread='-1209660528'/>
Error occurred during initialization of VM
Could not reserve enough space for object heap
<tty_done stamp='0.013'/>
</tty>
<hotspot_log_done stamp='0.013'/>
</hotspot_log>

Conclusion (again): You need more than the 256MB priced virtual server.

Links:
Glassfish V3 prelude
SUN Quickstart Guide