problem starting 7.3 server

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