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

Hello,

You can't only move the directory, because both database use diferent
structure. (tha's why the 7.3 doesn't start!!)

Do you want to use the 7.3 or 7.2?

If you want to use the 7.3, and conserve the 7.2's data, you have to:

1. Uninstall Postgresql 7.3
2. Install Postgresql 7.2 (and start the service)
3. pg_dumpall or pg_dump > x.sql (to make a backup of your structures
and data)
4. Uninstall the 7.2
5. Install 7.3
6. pgsql -f x.sql

There is more information about this commands in the man pages.

Good luck!

On Sat, 10 May 2003, [big5] Raymond Chan wrote:

> Hello,
>
> I am a new user to use the PostgreSQL,so there is no
> database.I moved all the /var/lib/pgsql/data to the
> other place.Then start the postgresql.It works!!
>
> BUt when i logged in as postgres and start the psql.
> It states this message::
>
> psql: FATAL: Database "postgres" does not exist in
> the system catalog.
>
> Please help
> Raymond
> --- Erick Dennis <edennis(at)rootshell(dot)be> ªº¶l¥ó¤º®e¡G>
> 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(at)kzsdabas(dot)sulinet(dot)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-----
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please
> > send an appropriate
> > subscribe-nomail command to majordomo(at)postgresql(dot)org
> > so that your
> > message can get through to the mailing list cleanly
>
> _________________________________________________________
> ²Ä¤G¥@(Á¾^¾W)¡A²ßºD¥¢ÅÊ(®e¯ª¨à)¡A¥S©f(³¯«³¨³)...
> Yahoo! ¹aÁn¤U¸ü
> http://ringtone.yahoo.com.hk
>

--
-----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-----