Thread: problem starting 7.3 server
hi I have installed the newest 7.3.1 rpms for RH 7.3. before I removed the 7.2 binaries with rpm -e now I get this error: /etc/rc.d/init.d$ sudo ./postgresql start An old version of the database format was found.\nYou need to upgrade the data format before using PostgreSQL.\nSee (Your System's documentation directory)/postgresql-7.3/README.rpm-dist for more information. but in this file I can not find information about the data format or I have overseen it. I even made a $ grep -i format with no proper result. any ideas what to do ? I have no important data so it would be possible to remove the old databases but I do not know if this is the solution. markus __________________________________________________________________ Gesendet von Yahoo! Mail - http://mail.yahoo.de Bis zu 100 MB Speicher bei http://premiummail.yahoo.de
On Saturday 25 January 2003 22:40, Markus Jais wrote: > hi > I have installed the newest 7.3.1 rpms for RH 7.3. > before I removed the 7.2 binaries with rpm -e Usually PostgreSQL data file formats are not compatible between major releases, e.g. between 7.2.x and 7.3.x. (...) > any ideas what to do ? > I have no important data so it would be possible to remove > the old databases but I do not know if this is the solution. You can delete the directories containing the data files (don't know where they will be on RedHat, try /var/db ) and create a new database "cluster" using the initdb installed with 7.3.1. See e.g.: http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/creating-cluster.html (If you suddenly find you want the old data you can alway reinstall 7.2.x, dump the data and import it in to 7.3.x, see: http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/backup.html ) Ian Barwick barwick@gmx.net
On Saturday 25 January 2003 16:40, Markus Jais wrote: > /etc/rc.d/init.d$ sudo ./postgresql start > An old version of the database format was found.\nYou need to upgrade > the data format before using PostgreSQL.\nSee (Your System's > documentation directory)/postgresql-7.3/README.rpm-dist for more > information. > but in this file I can not find information about the data format > or I have overseen it. I even made a $ grep -i format > with no proper result. Well, you have found a documentation bug -- I removed the information from the README but forgot to synchronize the initscript accordingly. > any ideas what to do ? > I have no important data so it would be possible to remove > the old databases but I do not know if this is the solution. rm -rf /var/lib/pgsql/data/* will wipe the data tree. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11