How to Fix “An old version of the database format was found” While Starting PostgreSQL

출처 : http://www.ehowstuff.com/how-to-fix-an-old-version-of-the-database-format-was-found-while-starting-postgresql/

 

아래와 같은 문제가 발생하면

[root@server ~]# service postgresql start 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.4.1/README.rpm-dist for more information.

initdb를 다시 하면 된다.

 

먼저 pgsql/data 안의 파일을 모두 삭제 한 후,

 

[root@server ~]# cd /var/lib/pgsql/data [root@server data]# ls base pg_clog pg_ident.conf pg_multixact pg_tblspc PG_VERSION postgresql.conf global pg_hba.conf pg_log pg_subtrans pg_twophase pg_xlog postmaster.opts [root@server data]# rm -rf *

initdb를 다시 한다.

[root@server data]# service postgresql initdb Initializing database: [ OK ]