N
NoAgendas
Guest
Tried to upgrade using this method
http://kb.linuxnetworkcare.com/node/21
Already removed the old, installed new rpm's
[email protected] [~]# 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:
[email protected] [~]# 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.
[email protected] [~]# 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?
http://kb.linuxnetworkcare.com/node/21
Already removed the old, installed new rpm's
[email protected] [~]# 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:
[email protected] [~]# 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.
[email protected] [~]# 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?
