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