On Monday, July 29, 2019, 9:53:42 AM GMT+8, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Saturday, July 27, 2019, Karen Goh <karenworld@yahoo.com> wrote:
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.
Start from scratch on a clean system and consider your existing database lost. If that is not acceptable then probably should just find someone locally to do this for you. Your reported setup of seeing a 7.* psql application on Windows 10 is so far off track that trying to figure out your unique situation over email seems unlikely to attract free help from qualified people.
I can't really start from scratch as I need the database which is already in my version 10 pgAdmin4 cos I painstakingly built them up and because I am not familiar with PostgreSQL system I don't want to throw them away and start afresh cos I have million things to tackle including a serious case of moving to VPS etc or Cloud and I need to be sure my next webhost works.
I don't have anybody to turn to. Everything I learnt is from forum, online free courses etc. so that is the reason I asked for help here.
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.
You should understand that as used on these list “psql 10” typically refers to the server. Since you seem to mean just the command line program you need to be a bit more verbose here.
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.
People have written many beginner level books on this kind of thing. You should read a number of them.
Frankly I’d suggest you use VirtualBox to run Linux inside Windows. Spending some time learning that will go a long way if you plan on picking up experience with Linux starting from a position of primary Windows usage.
David J.