Thread: RE: How do I upgrade psql from version 7 to be 10 in Windows 10? [SEC=UNOFFICIAL]
RE: How do I upgrade psql from version 7 to be 10 in Windows 10? [SEC=UNOFFICIAL]
UNOFFICIAL
A good webhost will offer phpPgAdmin in its control panel if it offers postgres. If not, ask them to install it. It is the primary way I have developed databases on my home computer and uploaded them to a website. It’s also good for off webhost backups.
Regards, Michael |
|
Dr Michael Pilling Land Capability Analysis Branch Joint and Operations Analysis Division Defence Science & Technology Group Bay 35, Bld 23, West Ave, Edinburgh SA 5111 Australia Mail: PO Box 1500, Edinburgh SA 5111 Australia P: 08 7389 7017 |
Defence Science and Technology acknowledges the Traditional Custodians of the Country throughout Australia. We recognise their continuing connection to land, waters and community. We pay our respects to them, their culture and to their Elders past and present.
IMPORTANT: This email remains the property of the Department of Defence and is subject to the jurisdiction of section 70 of the Crimes Act 1914. If you have received this email in error, you are requested to contact the sender and delete the email.
I can’t install phpPgAgmin on both system since the system belongs to the webhost right?
Sent from Yahoo Mail for iPhone
On Wednesday, July 31, 2019, 9:24 AM, Pilling, Michael <Michael.Pilling@dst.defence.gov.au> wrote:
UNOFFICIAL
You might consider installing phpPgAdmin on both systems, and using it to dump a text version of your database. You can then use it to reload your database on the new installation. It definitely retains data and table structures. It is very simple to use. I’d try to have both systems running concurrently so you can retry the dump and load with different settings if necessary.
Regards,
Michael
From: David G. Johnston [mailto:david.g.johnston@gmail.com]
Sent: Monday, 29 July, 2019 11:23 a.m.
To: Karen Goh
Cc: pgsql-novice@lists.postgresql.org
Subject: Re: How do I upgrade psql from version 7 to be 10 in Windows 10?
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.
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.