I've got a server with zoneminder, mysql, ffserver and some ffmpeg instances running on it, but for some reason everything seems to be tied to PostgreSQL. I noticed an error when loading the zoneminder viewer, saying it couldn't connect to mysql. I checked mysql and found it didn't create the socket, using sudo start mysql yields a service could not start error and absolutely nothing in the logs (even when manually specifying a log file to use). I tried to reinstall mysql with sudo apt-get remove mysql-server and got an error saying it couldn't start PostgreSQL server (nothing in the log for that either). Tried to uninstall postgresql with sudo apt-get remove postgresql and got the same error.
So my question is, why does everything seem to be tied to PostgreSQL on the machine, and why can't I remove it? I'm trying to get MySQL Server up and running but apt-get fails every commend I give it trying to access PostgreSQL.
$ sudo apt-get purge postgresql Reading package lists... Done Building dependency tree Reading state information... Done Package postgresql is not installed, so not removed The following packages were automatically installed and are no longer required: libmime-types-perl libyaml-syck-perl unzip php5 libavfilter2 libarchive-zip-perl libmime-tools-perl libdate-manip-perl libavdevice53 linux-headers-3.5.0-25-generic libsys-mmap-perl linux-headers-3.5.0-23-generic linux-headers-3.5.0-23 linux-headers-3.5.0-25 libraw1394-11 libphp-serialization-perl libemail-date-format-perl libdc1394-22 zip libdevice-serialport-perl libconvert-binhex-perl libmime-lite-perl libjs-mootools Use 'apt-get autoremove' to remove them. 0 upgraded, 0 newly installed, 0 to remove and 18 not upgraded. 2 not fully installed or removed. After this operation, 0 B of additional disk space will be used. Setting up postgresql-9.1 (9.1.9-0ubuntu12.04) ... * Starting PostgreSQL 9.1 database server * The PostgreSQL server failed to start. Please check the log output. [fail] invoke-rc.d: initscript postgresql, action "start" failed. dpkg: error processing postgresql-9.1 (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of postgresql-contrib-9.1: postgresql-contrib-9.1 depends on postgresql-9.1 (= 9.1.9-0ubuntu12.04); however: Package postgresql-9.1 is not configured yet. dpkg: error processing postgresql-contrib-9.1 (--configure): dependency problems - leaving unconfigured No apport report written because the error message indicates its a followup error from a previous failure. Errors were encountered while processing: postgresql-9.1 postgresql-contrib-9.1 E: Sub-process /usr/bin/dpkg returned an error code (1)
Edit: I found the issue: Zoneminder was filling up all 8TB of disk space. Still curious why apt-get needs postgresql though if anyone knows.