Re: How do I upgrade psql from version 7 to be 10 in Windows 10?

On Sun, Jul 28, 2019 at 8:27 PM Karen Goh <[email protected]> wrote:

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

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.

https://www.postgresql.org/docs/10/app-pg-dumpall.html
https://www.postgresql.org/docs/10/app-pgdump.html
https://www.postgresql.org/docs/10/app-pgrestore.html

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