Re: Old database format..

Hi,

Earlier, I had installed Postgres 8.1.9 on Linux and then uninstalled
the same(Postgres 8.1.9) .
Now I have installed the Postgres 8.1.4 and while running up server, I
am getting error.
I have logged in as Postgres user and it takes me to Bash Shell and then
I fired the following commands

    Command 1.    initdb -D /var/lib/pgsql/data

    Result of the command:
        The files belonging to this database system will be
owned by user "postgres".
        This user must also own the server process.

        The database cluster will be initialized with locale
en_US.UTF-8.
        The default database encoding has accordingly been set
to UTF8.

        initdb: directory "/var/lib/pgsql/data" exists but is
not empty
        If you want to create a new database system, either
remove or empty
        the directory "/var/lib/pgsql/data" or run initdb
        with an argument other than "/var/lib/pgsql/data".

    Command 2. /etc/init.d/postgresql  start

    Result of the command:
        cat: /var/lib/pgsql/data/PG_VERSION: Permission denied

        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.

Please help me to up the server.

Regards,
Anuj Pankaj

-----Original Message-----
From: Kevin Grittner [mailto:Kevin.Grittner@wicourts.gov]
Sent: Monday, September 27, 2010 7:53 PM
To: Anuj Pankaj; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Old database format..

Anuj Pankaj <anujp@cybage.com> wrote:

> I had higher version of Postgres might be 8.1.9,but  I am not
> sure.
>
> Now I am trying to install Postgres 8.1.4, I installed all rpm,
> however
> If I try  to run the  server I am getting error below

> 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.

The short answer is that if you replaced 8.1.9 with 8.1.4 on the
same OS with the same build options, it should be able to fire up
against the existing database with the older, buggier software.
There's a lot you're not telling us, and somewhere in that missing
information would be the clue to why you're experiencing a problem
and how to fix it.  Please read this page and post again:

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

-Kevin


"Legal Disclaimer: This electronic message and all contents contain information from Cybage Software Private Limited
whichmay be privileged, confidential, or otherwise protected from disclosure. The information is intended to be for the
addressee(s)only. If you are not an addressee, any disclosure, copy, distribution, or use of the contents of this
messageis strictly prohibited. If you have received this electronic message in error please notify the sender by reply
e-mailto and destroy the original message and all copies. Cybage has taken every reasonable precaution to minimize the
riskof malicious content in the mail, but is not liable for any damage you may sustain as a result of any malicious
contentin this e-mail. You should carry out your own malicious content checks before opening the e-mail or attachment."

www.cybage.com