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