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