Problems installing PostgresQL on Debian 2.12 Testing

LDMohican · 03-02-2006, 11:42 AM

Hi,

I'm having problems installing Postgresql using apt-get install along the lines of:

dpkg: error processing postgresql-common (--configure):
subprocess post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of postgresql-client-7.4:
postgresql-client-7.4 depends on postgresql-common (>= 24); however:
Package postgresql-common is not configured yet.

Any help would be gratefully appreciated.

rickh · 03-02-2006, 12:33 PM

I just installed it from AMD64 testing the other day ... no problems. The current version I got was 7.5.16. Also I have kernel 2.6.15.

Try again:
# apt-get update
# apt-get install postgresql

LDMohican · 03-06-2006, 10:44 AM

Yeah did that.

Getting this error at the end of the failed install:

Errors were encountered while processing:
postgresql-common
postgresql-client-7.4
postgresql-7.4
postgresql-client
postgresql
E: Sub-process /usr/bin/dpkg returned an error code (1)

LDMohican · 03-07-2006, 08:21 AM

Anyone?!?!?!?!?!?!

rickh · 03-07-2006, 09:50 AM

You have a difficult problem. According to the book, such an error should be filed as a 'grave' bug report. OTOH, I think if there really was such a bug in a package of the stature of POSTGRESQL, it's unlikely that you are the 1st to discover it, and by now the developers should have been all over it.

I assume that you are getting the package from an official Debian repo, and that you haven't installed some peculiar program that owns a library which the Debian installer wants to overwrite.

Your problem seems to be in postgresql-common ... I think I would try apt-get install postgresql-common by itself, and see if you get a clearer error message.

LDMohican · 03-07-2006, 10:14 AM

Hi Rick,

Firstly thanks for helping me out, I need to get PostgreSQL up and running for a project I need to do to earn a pay rise so you'll understand I need to get this sorted!

I'm getting the packages from uk.debian.org which should be fairly reputable.

I don't think I have installed anything peculiar.

This is the error I'm getting when trying to install postgresql-common only:-

Unpacking postgresql-common (from .../postgresql-common_43_all.deb) ...
Setting up postgresql-common (43) ...
Creating generic self-signed certificate: /etc/postgresql-common/postgresql.crt
(replace with hand-crafted or authorized one if needed).
hostname: Unknown host
dpkg: error processing postgresql-common (--configure):
subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
postgresql-common
E: Sub-process /usr/bin/dpkg returned an error code (1)

I'm a relative Linux newcomer but my brother is quite experienced and this issue is perplexing him.

Cheers.

rickh · 03-07-2006, 10:44 AM

I'm really out of my league here, but maybe by running through the new posts a few times, it'll attract the eye of someone who knows.

The next thing I would try is to completely purge postgres and then try a reinstall.

# dpkg --purge postgresql
# apt-get install postgresql

LDMohican · 03-07-2006, 10:58 AM

That didn't do it, came up with the same error.

I need a pay rise!!!!

rickh · 03-07-2006, 12:26 PM

Somthing is wrong in your system, as opposed to POSTGRESQL. I've caught a lot of flak for making this suggestion before, but, is reinstalling Debian an option?

I know it's a pain, but it only takes a few hours, and at the rate you're going ...

After the base-config is done, your choices of which package groups to install include a database server ... That will install POSTGRESQL right on your brand new OS. I would say that's practically a guarantee to work.