I'm trying to uninstall postgresql, but its really complaining. I suspect something is broken. I'm on 12.04, installed via apt-get.
sudo apt-get remove postgresql
Reading package lists... Done Building dependency tree Reading state information... Done Package postgresql is not installed, so not removed 0 upgraded, 0 newly installed, 0 to remove and 9 not upgraded. 2 not fully installed or removed. After this operation, 0 B of additional disk space will be used. Setting up postgresql-common (129ubuntu1) ... * Starting PostgreSQL 9.1 database server
* The PostgreSQL server failed to start. Please check the log output: 2013-07-12 11:13:30
BST FATAL: private key file "server.key" has group or world access 2013-07-12 11:13:30
BST DETAIL: File must be owned by the database user or root, must have no write permission for "group", and must have no permissions for "other".
invoke-rc.d: initscript postgresql, action "start" failed. dpkg: error processing postgresql-common (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of postgresql-9.1: postgresql-9.1 depends on postgresql-common (>= 115~); however: Package postgresql-common is not configured yet. dpkg: error processing postgresql-9.1 (--configure): dependency problems - leaving unconfigured
Now I have tried to fix the server.key file; I copied the snake oil file to
/var/lib/postgresql/9.1/main/server.key then I have modded it:
chmod 700 server.key chown postgres:postgres server.key
ls -l server.key
-rwx------ 1 postgres postgres 887 Jul 12 10:07 server.key
But it still complains that the file has group access.
Would appreciate any help to remove this, forced reinstall with
install -f doesn't help. :(