The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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