Strange, it appears your database isn't running.

thank you for the clarification Martin, when trying to upgrade to 12.04 with:

sudo apt-get install update-manager-core

I get a : "1 not fully installed or removed." which is airtime, how can I fix that?

I purged airtime anyway, but after upgrading to precise and and installing icecast2 I still had errors:

stream:/etc/apache2/sites-enabled$ sudo apt-get install airtime
Reading package lists... Done
Building dependency tree
Reading state information... Done
airtime is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue [Y/n]? y
Setting up airtime (2.3.0-1) ...
Site airtime-vhost already disabled
Setting up apache2...
Module rewrite already enabled
Configuring php5...
Setting up monit configuration...
/etc/init.d/monit: 39: [: restart: unexpected operator
/etc/init.d/monit: 39: [: stop: unexpected operator
* Stopping daemon monitor monit [ OK ]
/etc/init.d/monit: 39: [: start: unexpected operator
* Starting daemon monitor monit [ OK ]
* Restarting web server apache2 ... waiting [ OK ]
Liquidsoap symlink points to the right place!
* Making sure /etc/default/locale is set properly
LANG="en_US.UTF-8"
* Checking for existing Airtime installation...
* None found.
* Temporarily stopping any previous running services

******************************** Install Begin *********************************
Ensuring python-virtualenv version > 1.4.8...Success!

*** Creating Virtualenv for Airtime ***
Already using interpreter /usr/bin/python
The --no-site-packages flag is deprecated; it is now the default behavior.
New python executable in /usr/lib/airtime/airtime_virtualenv/bin/python
Installing distribute.............................................................................................................................................................................................done.
Installing pip...............done.

*** Installing Python Libraries ***
Unpacking /var/lib/airtime/tmp/python_apps/python-virtualenv/airtime_virtual_env.pybundle
Downloading/unpacking mutagen
Running setup.py egg_info for package mutagen

Downloading/unpacking kombu
Running setup.py egg_info for package kombu

Downloading/unpacking pytz
Running setup.py egg_info for package pytz

warning: no files found matching '*.pot' under directory 'pytz'
warning: no previously-included files found matching 'test_zdump.py'
Downloading/unpacking configobj
Running setup.py egg_info for package configobj

Downloading/unpacking poster
Running setup.py egg_info for package poster

Downloading/unpacking pyinotify
Running setup.py egg_info for package pyinotify

Downloading/unpacking amqplib
Running setup.py egg_info for package amqplib

Requirement already satisfied (use --upgrade to upgrade): argparse in /usr/lib/python2.7
Downloading/unpacking anyjson
Running setup.py egg_info for package anyjson

Downloading/unpacking docopt
Running setup.py egg_info for package docopt

Downloading/unpacking PyDispatcher
Running setup.py egg_info for package PyDispatcher

warning: no previously-included files matching '*.bat' found anywhere in distribution
warning: no previously-included files matching './CVS' found anywhere in distribution
warning: no previously-included files matching '.cvsignore' found anywhere in distribution
Requirement already satisfied (use --upgrade to upgrade): wsgiref in /usr/lib/python2.7
Installing collected packages: mutagen, kombu, pytz, configobj, poster, pyinotify, amqplib, anyjson, docopt, PyDispatcher
Running setup.py install for mutagen
changing mode of build/scripts-2.7/mid3iconv from 644 to 755
changing mode of build/scripts-2.7/mutagen-inspect from 644 to 755
changing mode of build/scripts-2.7/mid3v2 from 644 to 755
changing mode of build/scripts-2.7/moggsplit from 644 to 755
changing mode of build/scripts-2.7/mutagen-pony from 644 to 755

changing mode of /usr/lib/airtime/airtime_virtualenv/bin/mid3iconv to 755
changing mode of /usr/lib/airtime/airtime_virtualenv/bin/mutagen-inspect to 755
changing mode of /usr/lib/airtime/airtime_virtualenv/bin/mid3v2 to 755
changing mode of /usr/lib/airtime/airtime_virtualenv/bin/moggsplit to 755
changing mode of /usr/lib/airtime/airtime_virtualenv/bin/mutagen-pony to 755
Running setup.py install for kombu

Running setup.py install for pytz

warning: no files found matching '*.pot' under directory 'pytz'
warning: no previously-included files found matching 'test_zdump.py'
Running setup.py install for configobj

Running setup.py install for poster

Running setup.py install for pyinotify

Running setup.py install for amqplib

Running setup.py install for anyjson

Running setup.py install for docopt

Running setup.py install for PyDispatcher

warning: no previously-included files matching '*.bat' found anywhere in distribution
warning: no previously-included files matching './CVS' found anywhere in distribution
warning: no previously-included files matching '.cvsignore' found anywhere in distribution
Successfully installed mutagen kombu pytz configobj poster pyinotify amqplib anyjson docopt PyDispatcher
Cleaning up...

*** Patching Python Libraries ***
* Patching virtualenv libraries in /usr/lib/airtime/airtime_virtualenv/lib/python2.7

---Applying Patches for mutagen---
patching file site-packages/mutagen/mp3.py
Hunk #2 succeeded at 169 (offset -4 lines).
patching file site-packages/mutagen/mp3.py
Hunk #1 succeeded at 204 (offset -5 lines).
* Checking for user pypo
User already exists.
* Creating INI files
* Initializing INI files
* Airtime Version: 2.3.0
* Storage directory setup
* Skipping directory already exists: /srv/airtime/stor
* Giving Apache permission to access /srv/airtime/stor
* Skipping directory already exists: /srv/airtime/stor/organize
* Giving Apache permission to access /srv/airtime/stor/organize
* Checking database for correct encoding

* Database Installation
* Creating Airtime database user
* Database user 'airtime' created.
* Creating Airtime database
Unable to open PDO connection [wrapped: SQLSTATE[08006] [7] could not connect to server: Connection refused
Is the server running on host "localhost" (127.0.0.1) and accepting
TCP/IP connections on port 5432?]
Database connection problem.
Check if database 'airtime' exists with corresponding permissions.
* Creating /etc/airtime
* Creating /etc/monit/conf.d/monit-airtime-generic.cfg
* Creating /etc/cron.d/airtime-crons
* Creating /usr/lib/airtime
* Creating symbolic links in /usr/bin
* Creating /var/log/airtime
* Creating /usr/share/airtime
* Creating /var/log/airtime
* Creating /var/tmp/airtime
Generating locales
Generating locales...
cs_CZ.UTF-8... done
Generation complete.
Generating locales...
de_DE.UTF-8... done
Generation complete.
Generating locales...
el_GR.UTF-8... done
Generation complete.
Generating locales...
en_CA.UTF-8... done
Generation complete.
Generating locales...
en_GB.UTF-8... done
Generation complete.
Generating locales...
en_US.UTF-8... up-to-date
Generation complete.
Generating locales...
es_ES.UTF-8... done
Generation complete.
Generating locales...
fr_FR.UTF-8... done
Generation complete.
Generating locales...
it_IT.UTF-8... done
Generation complete.
Generating locales...
ko_KR.UTF-8... done
Generation complete.
Generating locales...
pl_PL.UTF-8... done
Generation complete.
Generating locales...
pt_BR.UTF-8... done
Generation complete.
Generating locales...
ru_RU.UTF-8... done
Generation complete.
Generating locales...
zh_CN.UTF-8... done
Generation complete.
* Waiting for media-monitor processes to start...
Starting Airtime Media Monitor: Done.
* Detecting OS: ... Found Ubuntu 12.04.2 LTS (precise) on amd64 architecture
* Creating symlink to Liquidsoap binary
* Clearing previous pypo cache
* Waiting for pypo processes to start...
* Stopping daemon monitor monit [ OK ]
* Starting daemon monitor monit [ OK ]

*** Verifying your system environment, running airtime-check-system ***
AIRTIME_STATUS_URL = http://localhost:80/api/status/format/json/api_key/%%api_key%%
AIRTIME_SERVER_RESPONDING = OK
KERNEL_VERSION = UNKNOWN
MACHINE_ARCHITECTURE = UNKNOWN
TOTAL_MEMORY_MBYTES = UNKNOWN
TOTAL_SWAP_MBYTES = UNKNOWN
AIRTIME_VERSION = UNKNOWN
OS = Ubuntu 12.04.2 LTS x86_64
CPU = Intel(R) Xeon(R) CPU E5606 @ 2.13GHz
WEB_SERVER = A
PLAYOUT_ENGINE_PROCESS_ID = FAILED
PLAYOUT_ENGINE_RUNNING_SECONDS = 0
PLAYOUT_ENGINE_MEM_PERC = 0%
PLAYOUT_ENGINE_CPU_PERC = 0%
-- Displaying log file /var/log/airtime/pypo/pypo.log
-- raise HTTPError(req.get_full_url(), code, msg, hdrs, fp)
-- HTTPError: HTTP Error 404: Not Found
--
-- 2013-03-12 17:04:31,120 INFO - [api_client.py : is_server_compatible() : line 158] - Unable to get Airtime version number.
--
--
--
LIQUIDSOAP_PROCESS_ID = FAILED
LIQUIDSOAP_RUNNING_SECONDS = 0
LIQUIDSOAP_MEM_PERC = 0%
LIQUIDSOAP_CPU_PERC = 0%
-- Displaying log file /var/log/airtime/pypo-liquidsoap/ls_script.log
--
--
MEDIA_MONITOR_PROCESS_ID = FAILED
MEDIA_MONITOR_RUNNING_SECONDS = 0
MEDIA_MONITOR_MEM_PERC = 0%
MEDIA_MONITOR_CPU_PERC = 0%
-- Displaying log file /var/log/airtime/media-monitor/media-monitor.log
-- File "/usr/lib/python2.7/urllib2.py", line 527, in http_error_default
-- raise HTTPError(req.get_full_url(), code, msg, hdrs, fp)
-- HTTPError: HTTP Error 404: Not Found
--
-- 2013-03-12 17:04:27,679 INFO - [Thread-1] [syncdb.py : reload_directories()] : LINE 49 - HTTP Error 404: Not Found
--
--
RABBITMQ_PROCESS_ID = FAILED
RABBITMQ_RUNNING_SECONDS = 0
RABBITMQ_MEM_PERC = 0%
RABBITMQ_CPU_PERC = 0%
-- There appears to be a problem with your Airtime installation.
-- Please visit http://wiki.sourcefabric.org/x/HABQ
dpkg: error processing airtime (--configure):
subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
airtime
E: Sub-process /usr/bin/dpkg returned an error code (1)

Here's the relevant error message:

it seems that I have both postgres 8.4 and 9.1! any recommendation?

Sorry,

 sudo apt-get purge postgresql-8.4
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be REMOVED:
postgresql-8.4*
0 upgraded, 0 newly installed, 1 to remove and 0 not upgraded.
After this operation, 0 B of additional disk space will be used.
Do you want to continue [Y/n]? y
(Reading database ... 83006 files and directories currently installed.)
Removing postgresql-8.4 ...
Purging configuration files for postgresql-8.4 ...
Dropping cluster main...
me@stream:~$ dpkg -l | grep postgres
ii odbc-postgresql 1:09.00.0310-2 ODBC driver for PostgreSQL
ii postgresql 9.1+129ubuntu1 object-relational SQL database (supported version)
ii postgresql-9.1 9.1.8-0ubuntu12.04 object-relational SQL database, version 9.1 server
ii postgresql-client-9.1 9.1.8-0ubuntu12.04 front-end programs for PostgreSQL 9.1
ii postgresql-client-common 129ubuntu1 manager for multiple PostgreSQL client versions
ii postgresql-common 129ubuntu1 PostgreSQL database-cluster manager

now should I just change the port on postgres conf file and will be fine?

Giga said:

 sudo apt-get purge postgresql-8.4
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be REMOVED:
postgresql-8.4*
0 upgraded, 0 newly installed, 1 to remove and 0 not upgraded.
After this operation, 0 B of additional disk space will be used.
Do you want to continue [Y/n]? y
(Reading database ... 83006 files and directories currently installed.)
Removing postgresql-8.4 ...
Purging configuration files for postgresql-8.4 ...
Dropping cluster main...
me@stream:~$ dpkg -l | grep postgres
ii odbc-postgresql 1:09.00.0310-2 ODBC driver for PostgreSQL
ii postgresql 9.1+129ubuntu1 object-relational SQL database (supported version)
ii postgresql-9.1 9.1.8-0ubuntu12.04 object-relational SQL database, version 9.1 server
ii postgresql-client-9.1 9.1.8-0ubuntu12.04 front-end programs for PostgreSQL 9.1
ii postgresql-client-common 129ubuntu1 manager for multiple PostgreSQL client versions
ii postgresql-common 129ubuntu1 PostgreSQL database-cluster manager

now should I just change the port on postgres conf file and will be fine?

It should be ok. Please change the port to 5432 and you should be set.

Thank you Martin, all seems well now, but how can I add the old audio files to the library, they are all at /srv/airtime/stor/ and I can add that folder to the "Watched Folder" it says that it has been already added - of course - but non of the files from the previous installation are showing in the library!

anyone have an idea how to restore the playlists?

sadly No, are the playlists stored somewhere else?