Thread: Problem starting postgresql !!

Problem starting postgresql !!

From
rahul
Date:
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.

Re: Problem starting postgresql !!

From
Lamar Owen
Date:
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

Re: Problem starting postgresql !!

From
Peter Eisentraut
Date:
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.