Problem starting postgresql !!
Hi,
I had postgresql 7.3 rpm installed on redhat 9 platform. i removed it
and downloaded and installed following rpm's from ur ftp site:-
[root@reporter postgresql-7.4]# rpm -qa |grep postgre
postgresql-debuginfo-7.4-0.5PGDG
postgresql-libs-7.4-0.5PGDG
postgresql-contrib-7.4-0.5PGDG
postgresql-devel-7.4-0.5PGDG
postgresql-test-7.4-0.5PGDG
postgresql-7.4-0.5PGDG
postgresql-server-7.4-0.5PGDG
now when i try to start postgresql, i am getting :-
[root@reporter init.d]# ./postgresql start
An old version of the database format was found.\nYou need to upgrade
the data format before using PostgreSQL.\nSee
/usr/share/doc/postgresql-7.4/README.rpm-dist for more information.
could u please let me know, how to get rid of this problem.
Regards
Rahul D.
On Monday 29 March 2004 02:51 am, rahul wrote:
I had postgresql 7.3 rpm installed on redhat 9 platform. i removed it
and downloaded and installed following rpm's from ur ftp site:-
An old version of the database format was found.\nYou need to upgrade
the data format before using PostgreSQL.\nSee
/usr/share/doc/postgresql-7.4/README.rpm-dist for more information.
could u please let me know, how to get rid of this problem.
If you did not have any data you want to keep, run 'rm
-rf /var/lib/pgsql/data/* ' and execute the initscript again.
If you DO have data you want to keep, you need to reinstall the old version,
dump its data, remove the old/install the new, blow out the directory, start
the new, and restore your data.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554
www.pari.edu
rahul wrote:
An old version of the database format was found.\nYou need to upgrade
the data format before using PostgreSQL.\nSee
/usr/share/doc/postgresql-7.4/README.rpm-dist for more information.could u please let me know, how to get rid of this problem.
Follow the instructions in
/usr/share/doc/postgresql-7.4/README.rpm-dist.