Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Error with Postgresql after recent dist-upgrade

Hybrid View

  1. #1
    Just burned his ISO
    Join Date
    Dec 2006
    Posts
    8

    Default

    I just applied the latest batch of updates, as the twitter post announced.

    Everything went well apart from the Postgresql upgrade, the following error was given.

    Setting up postgresql-8.3 (8.3.8-0ubuntu8.10) ...
    Starting PostgreSQL 8.3 database server: main* The PostgreSQL server failed to start. Please check the log output:
    2009-09-29 12:21:43 BST FATAL: could not load server certificate file "server.crt": No such file or directory
    failed!
    invoke-rc.d: initscript postgresql-8.3, action "start" failed.
    dpkg: error processing postgresql-8.3 (--configure):
    subprocess post-installation script returned error exit status 1
    dpkg: dependency problems prevent configuration of postgresql:
    postgresql depends on postgresql-8.3; however:
    Package postgresql-8.3 is not configured yet.
    dpkg: error processing postgresql (--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-8.3
    postgresql
    E: Sub-process /usr/bin/dpkg returned an error code (1)

    I'm not conversant with Postgresql and after a bit of google'ing around I cant find a fix.

    Anyone else got this problem or does anyone have any pointers or a fix??

    Regards
    Dave

    Done some more Google'ing and found a fix, maybe.

    Do we need ssl?, if not just turn off ssl in /etc/postgresql/8.3/main/postgresql.conf

    And then /etc/init.d/postrgresql start and it runs

    If we need ssl then we need a new certificate, the certs are linked to a snake-oil cert

    lrwxrwxrwx 1 root root 36 Jun 22 17:19 server.crt -> /etc/ssl/certs/ssl-cert-snakeoil.pem
    lrwxrwxrwx 1 root root 38 Jun 22 17:19 server.key -> /etc/ssl/private/ssl-cert-snakeoil.key

    which is not present in the /etc/ssl/certs.

    The new certificates can be created by :-

    cd /etc/ssl/certs
    make-ssl-cert generate-default-snakeoil --force-overwrite

    Now retstart postgresql

    /etc/init.d/postgresql restart

    This should be everything back to life.

  2. #2
    Just burned his ISO
    Join Date
    Jul 2006
    Posts
    6

    Default

    When you try to start postgres with ssl set to true it fails because Postgres can't find a server certificate file named server.cert. Should we just create with openssl? Just did it it works. Thanks for your posting!!!

    Mcugk

  3. #3

    Default

    Fixed my issue also. Thanks!
    "You can get more with a kind word and a gun than you can with a kind word alone."
    - Al Capone

  4. #4
    Just burned his ISO
    Join Date
    Jan 2010
    Posts
    13

    Default

    I got the same problem, after a dist-upgrade,
    and the trick done it well
    thank's davehardy20

  5. #5
    Just burned his ISO
    Join Date
    Feb 2010
    Posts
    4

    Default

    Same here. Searching for a fix last 2 days :-)
    thanks for fix.

  6. #6
    Just burned his ISO
    Join Date
    Dec 2007
    Posts
    5

    Default

    Hello,

    I found on my BT4 install that the "/etc/init.d/postgresql" is rename to "/etc/init.d/postgresql-8-3".
    I have to create a link to the file with the name "/etc/init.d/postgresql" and the problem is solved.

    Regards

  7. #7
    Member iceman_3233's Avatar
    Join Date
    Jan 2010
    Location
    Fort Washington
    Posts
    56

    Default

    Hello Laurenzo
    Did you ln -s /etc/init.d/postgresq /etc/init.d/postgresql-8-3
    or
    ln -s /etc/init.d/postgresql-8-3 /etc/init.d/postgresq
    To fix the Postgresql Error
    The enemy is no longer ignorance - It is vigilance

  8. #8
    Just burned his ISO
    Join Date
    Jun 2009
    Posts
    19

    Default

    Im trying to customize the bt4pf livecd and im getting this error when i try to apt-get upgrade. this fix worked for me on my install so i figured it would work when i try to update/upgrade the livecd files but it doesnt. maybe im just doing it wrong but im just pointing that out.

    EDIT: here is my error
    Code:
    2009-11-18 18:51:41 EST LOG:  could not bind IPv4 socket: Address already in use
    2009-11-18 18:51:41 EST HINT:  Is another postmaster already running on port 54$
    2009-11-18 18:51:41 EST WARNING:  could not create listen socket for "localhost"
    2009-11-18 18:51:41 EST FATAL:  could not create any TCP/IP sockets
    Well I made the changes onto the livecd then installed it and i didnt get the error.. I guess you cant do too much editing of this livecd until they fix the problem on the cd itself.

  9. #9
    Just burned his ISO
    Join Date
    Oct 2009
    Posts
    2

    Default cool thx

    it's a working, needed a email program (apt-get install kmail)


  10. #10
    Just burned his ISO
    Join Date
    Sep 2009
    Posts
    7

    Default

    hello, I can not English so well, I have the same problem, I have made so

    backtrack new install

    now
    console

    cd /etc/ssl/certs

    ls -ld /etc/ssl/private
    sudo ls -l /etc/ssl/private/

    make-ssl-cert generate-default-snakeoil --force-overwrite

    BackTrack 4 Pre Final Kernel Update

    apt-get update
    apt-get install -d linux-image
    cd /var/cache/apt/archives/
    dpkg -i –force all linux-image-2.6.30.5_2.6.30.5-10.00.Custom_i386.deb
    apt-get dist-upgrade
    apt-get install madwifi-drivers
    apt-get install r8187-drivers

    After a reboot, you might want to run:

    fix-splash

    no error with Postgresql

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •