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@xxxxxxxxxxxx] Sent: Monday, September 27, 2010 7:53 PM To: Anuj Pankaj; pgsql-admin@xxxxxxxxxxxxxx Subject: Re: Old database format.. Anuj Pankaj <anujp@xxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
