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

Hello,

If using --oldpackage doesn't work, soo try uninstalling the package
manually, and then install the 7.2 package.

Best Regards.


On Fri, 9 May 2003, [big5] Raymond Chan wrote:

> 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émes_Géza <geza@kzsdabas.sulinet.hu>
> ªº¶l¥ó¤º®e¡G> 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
> >
>
> _________________________________________________________
> ²Ä¤G¥@(Á¾^¾W)¡A²ßºD¥¢ÅÊ(®e¯ª¨à)¡A¥S©f(³¯«³¨³)...
> Yahoo! ¹aÁn¤U¸ü
> http://ringtone.yahoo.com.hk
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

mQGiBD3AVWoRBACodcxl03gUoJOqgzRfAheGLKeri8MdDy8F3fX/LwIihpWQMwh6
goSEhp6f+VkINDJ3cX3OgTYVAIJLBrzzka2wbDHnTv9A7j8+VB4Nh2ZY9RrcZdxX
g2z2NNdWVmxLPKTK+wbTXFsyLtj2IR0TASQdJKOL+VX6W7N/LYY2Mz4AXwCg8DC3
8cBi8P2ld48Un/Gvl1s/xHkD/j4r3WCsDGAzof2FiZ3wOkP9fgPbOk7v20FdXhOA
hjmGY7GCb0tsEPALPj2St3BKVgTH7iJ08us9lIx9Kux9XV1ZhlkZr1G3A0bkgUfk
Fcmih3FWmbV88Z4JFB1vhsrCFzgq3PHu5Wy37ObhpoVbs9ajo9vX09xZAL4SYq6o
7STAA/9UYgUwbB8fzG68Z7WLG8SDgEy5AL9ObHIUri+HeIHGSMtbjcksIMXkL1L5
CedPJDf/tphWrgvgROSWALJOvwc8cDAX/iwWyzAtmj+X8Xbx1QS0OJc8yPk4j9VI
Fp7zusVbRprBaIuk3ur29WbDCGFUpkyBTIdxjyw04P+sjcIxObQtRXJpY2sgRGVu
bmlzIChlRGVubmlzKSA8ZWRlbm5pc0Byb290c2hlbGwuYmU+iFcEExECABcFAj3A
VWoFCwcKAwQDFQMCAxYCAQIXgAAKCRBAR/8wlx6vQEk5AJ0fK5oMOR7Xhh6ZU4qB
Q4eFq6a/uQCcCgQ42duQ/0qgsmnu/aBcEi0EtHO5AQ0EPcBVbhAEAORKwkRPWpS5
qDe35p97UTcD2T2Oe2q29U2MV9Z5eDM5oPWYpXhGyIsKVUW2UyVpWfbVvLQfWVO+
ehfoDBHPI0GUZoOjjGBmwprII8hVc+YpJHnjTkB7ZoxNUlwCamuYXlNmQr6saQZO
sfCJO9og64+25/OGZXmd2oOC/C1qeYmTAAMFA/4xRwY6r5m03lZI1hdlR/9PzC01
ZD46bTrhIYFAeZZmyVbsttmz3A0/gMxj2sxaHoFnQE4QO3xqAV8k2KvxNzArEuj/
rpu6SaFTBG+u7ikkkCb1hCgukF6kKIAZKP9QSsTGFVgBaUlaT6PLm7LMHq2Mauap
OfztGsOfayzARNwu0IhGBBgRAgAGBQI9wFVuAAoJEEBH/zCXHq9A9FkAnjVE9wCa
i1Gau6ypIxomane6UD3NAKDkl1ulR3iEsdy8fF99Oo95tSkawg==
=86sd
-----END PGP PUBLIC KEY BLOCK-----