Hi, I have try to upgrade PostgreSQL from 7.1 to 7.2, but the system
tell me I can't do it directly. It give me a readme file for the detail
procedure.

Then I try to follow the instructions to upgrade. The readme tell that I
need to manually output the old db first, and Mandrake provide a script
mdk-dump.sh for that. However, after I output the db, how to I import it
back to PostgreSQL? I try to use the command:

psql -e < db_backup.sql 

to run. But it fail, because there are many databases create by many
user, and the command "psql -e" only able to import it own database. 
Then I get the backup copy and try to use pg_dump for that. The
same message appear. Can anyone give me more detail procedure for this?

                \\\|///
                \- - -//
               (  @ @  )
  -----------oOOo-(_)-oOOo-------------------------------
        Visit my homepage at http://www.carfield.com.hk
  -------------------------------------------------------





Reply via email to