I downloaded the RPMs for RHLinux9 and have run the upgrade, but now I
receive an error about the database format needing to be upgraded when I
attempt to start the service. Fortunately at this point, I have absolutely
NO data that I need to save, so I haven't lost anything. But, I need to
upgrade the database format (or so it says) and I have no idea how to
accomplish that. Have I done something that is not fixable at this point?
HELP!



Michael A Weber

Weber Racing Equipment, Inc.

440-327-7702

440-327-6899 fax

mweber (AT) 4wre (DOT) com

If you are upgrading from a prior version of postgresql you normally
need to backup the database via pg_dump, upgrade, create a new database
and import the data.

See http://www.postgresql.org/docs/7.4/s...upgrading.html

Mike
On Thu, 2004-06-10 at 19:57, Michael A Weber wrote:
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

В Птн, 11.06.2004, в 02:57, Michael A Weber пишет:
as root do

rm -rf /var/lib/pgsql/*

This deletes the old data directory. Upon the next start of the
postgresql service it will create a new one, in the new format.

--
Markus Bertheau <twanger (AT) bluetwanger (DOT) de>


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html