Обсуждение: Old database format..
Hi,
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.
Help me to up the server of newly installed Postgres 8.1.4
Thanks & Regards,
Anuj Pankaj
"Legal Disclaimer: This electronic message and all contents contain information from Cybage Software Private Limited which may 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 message is strictly prohibited. If you have received this electronic message in error please notify the sender by reply e-mail to and destroy the original message and all copies. Cybage has taken every reasonable precaution to minimize the risk of malicious content in the mail, but is not liable for any damage you may sustain as a result of any malicious content in this e-mail. You should carry out your own malicious content checks before opening the e-mail or attachment." www.cybage.com
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
--- On Mon, 9/27/10, Anuj Pankaj <anujp@cybage.com> wrote:
when making your new database installation, you created a new cluster? or you used the old cluster? |
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