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

Karen Goh <[email protected]> Sun, 28 Jul 2019 04:00:42 +0000 (UTC)
Newsgroups gmane.comp.db.postgresql.novice
Message-ID <[email protected]>
Greetings,

I was wrestling with my database migration till I found out that I actually had a 7.6 PSQL version instead of 10 which I had downloaded this year.

Now, I have problem in upgrading PSQL to 10 even though I had done all the ncessary steps like setting the permission to All in Windows 10.

Now, I tried to follow this article : https://www.arencambre.com/blog/2014/12/24/postgress-pg_upgrade-on-windows-the-documentation-misses-a-lot/ But, I am getting denial of access using my postgres user password.

And it seems that it is easier to operate psql using linux.  But, I am new to Linux, just like PostgreSQL.

So, I hope someone can really come and help me out in terms of upgrading my PSQL and then secondly share with me article how to use Linux from installation as a dual boot drive in my laptop and using Linux with Postgresql.

Thanks

Karen