Re: Upgrade to RH9.....Help....PostgreSQL newbie - Mailing list pgsql-admin

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@rootshell.be> 的郵件內容：>
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幦es_G憴a <geza@kzsdabas.sulinet.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
> >
> >
> > ---------------------------(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@postgresql.org
> so that your
> message can get through to the mailing list cleanly

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