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

Thx for your instructions

I have type this rpm -Fvh --oldpackage
postgresql*7.2.4.i386.rpm and the command line doesn't
display any comment.The version is still in 7.3.2

How can I downgrade the postgresql??

THX
Raymond

--- G幦es_G憴a <geza(at)kzsdabas(dot)sulinet(dot)hu>
的郵件內容：> Lamar Owen 甏ta:
>
> >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
>

_________________________________________________________
第二世(謝霆鋒)，習慣失戀(容祖兒)，兄妹(陳奕迅)...
Yahoo! 鈴聲下載
http://ringtone.yahoo.com.hk