pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedOld database format..
4+ messages / 3 participants
[nested] [flat]
* Old database format..
@ 2010-09-27 13:36 Anuj Pankaj <anujp@cybage.com>
0 siblings, 2 replies; 4+ messages in thread
From: Anuj Pankaj @ 2010-09-27 13:36 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Old database format..
@ 2010-09-27 14:23 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Anuj Pankaj <anujp@cybage.com>
1 sibling, 1 reply; 4+ messages in thread
From: Kevin Grittner @ 2010-09-27 14:23 UTC (permalink / raw)
To: Anuj Pankaj <anujp@cybage.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Old database format..
@ 2010-09-27 18:39 Lennin Caro <lennin.caro@yahoo.com>
parent: Anuj Pankaj <anujp@cybage.com>
1 sibling, 0 replies; 4+ messages in thread
From: Lennin Caro @ 2010-09-27 18:39 UTC (permalink / raw)
To: pgsql-admin@postgresql.org, Anuj Pankaj <anujp@cybage.com>
--- On Mon, 9/27/10, Anuj Pankaj <anujp@cybage.com> wrote:
From: Anuj Pankaj <anujp@cybage.com>
Subject: [ADMIN] Old database format..
To: pgsql-admin@postgresql.org
Date: Monday, September 27, 2010, 1:36 PM
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
when making your new database installation, you created a new cluster? or you used the old cluster?
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Old database format..
@ 2010-09-29 09:46 Anuj Pankaj <anujp@cybage.com>
parent: Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 0 replies; 4+ messages in thread
From: Anuj Pankaj @ 2010-09-29 09:46 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; pgsql-admin
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 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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2010-09-29 09:46 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-09-27 13:36 Old database format.. Anuj Pankaj <anujp@cybage.com>
2010-09-27 14:23 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-09-29 09:46 ` Anuj Pankaj <anujp@cybage.com>
2010-09-27 18:39 ` Lennin Caro <lennin.caro@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox