Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

postgresql upgrade to 8 problem

Discussion in 'General Discussion' started by NoAgendas, Jul 27, 2006.

  1. NoAgendas

    NoAgendas Guest

    Tried to upgrade using this method
    http://kb.linuxnetworkcare.com/node/21

    Already removed the old, installed new rpm's

    root@server [~]# rpm -Uhv postgresql*.rpm
    warning: postgresql-8.1.4-3PGDG.i686.rpm: V3 DSA signature: NOKEY, key ID 748f7d0e
    Preparing... ########################################### [100%]
    1 postgresql-libs ########################################### [ 17%]
    2 postgresql ########################################### [ 33%]
    3 postgresql-contrib ########################################### [ 50%]
    4 postgresql-devel ########################################### [ 67%]
    5 postgresql-python ########################################### [ 83%]
    6 postgresql-server ########################################### [100%]


    Now, I did a backup first using the method shown here
    http://forums.cpanel.net/showthread.php?p=189646

    Tried to restore as well, got the below:

    root@server [~]# service postgresql restart
    Stopping postgresql service: [FAILED]

    An old version of the database format was found.
    You need to upgrade the data format before using PostgreSQL.
    See /usr/share/doc/postgresql-8.1.4/README.rpm-dist for more information.
    root@server [~]# su - postgres
    -bash-3.00$ psql -f /tmp/dbdo28.out template1
    psql: could not connect to server: No such file or directory
    Is the server running locally and accepting
    connections on Unix domain socket "/tmp/.s.PGSQL.5432"?


    my pg_hba.conf file is correct also:
    local all all trust
    host all all 127.0.0.1 255.255.255.255 trust


    I already did "install config" and set root password in whm prior to attempting the restore.

    What should I do?
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice