no. I think you have problem understanding my requirements. I need to know how to upgrade my psql 7 to 10! I need to solve this for good
You must dump and restore your database to upgrade from a version that old. pgupgrade will not work with a version jump that drastic.
But, my database is residing in version 10, not 7. So, I really need to just upgrade the psql.exe to version 10. Actually I don’t know why psql is version 7 and the server for my database is in 10.
Use pg_dumpall -g to dump out the global objects (roles, tablespaces, etc). And use pg_dump to dump out the individual databases. And be sure to use the pgdump from version 10 to create the dump files, not the old version.
Then you can feed the file created by pg_dumpall into the new database using psql -f since it's a plain sql file. Then use pg_restore to restore the database dump(s).
