Re: Upgrade to RH9.....Help....PostgreSQL newbie

Lamar Owen írta:

On Wednesday 07 May 2003 20:41, Raymond Chan wrote: 

How can I update the dtatbase??   

I am a new user to use the postgreSQL.Please help me
and state the instruction step by step   

1.) Download the 7.2.4 redhat 9 RPMs from ftp.postgresql.org, in the directory 
/pub/binary/v7.2.4/RPMS/redhat-9
2.) Downgrade your PostgreSQL by using 'rpm -Fvh --oldpackage 
postgresql*7.2.4.i386.rpm'
3.) Restart postmaster. 

Then as root:

su -c 'pg_dumpall > /path/to/an_sql/dump/file ' postgres
Stop the postmaster: service postgresql stop
Move away your directories holding the databases Usualy /var/lib/pgsql/data, don't delete them! It's a backup copy
Upgrade back to postgresql 7.3.2 from the RedHat CDs, DVD, or whatsover
Start the postmaster: service postgresql start
su -c 'psql template1' postgres
at the template1# prompt type \i /path_to_the_previously_saved_sql_file
Thats all hopefully

Best Regards

Geza Gemes