Re: How do I upgrade psql from version 7 to be 10 in Windows 10?[SEC=UNOFFICIAL] - Mailing list pgsql-novice

On Monday, August 5, 2019, 9:50 PM, Danny Severns <Danny@eidl-sw.com> wrote:

#yiv7971564659 #yiv7971564659 --_filtered #yiv7971564659 {panose-1:0 0 0 0 0 0 0 0 0 0;}_filtered #yiv7971564659 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} #yiv7971564659 #yiv7971564659 p.yiv7971564659MsoNormal, #yiv7971564659 li.yiv7971564659MsoNormal, #yiv7971564659 div.yiv7971564659MsoNormal{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;} #yiv7971564659 a:link, #yiv7971564659 span.yiv7971564659MsoHyperlink{color:blue;text-decoration:underline;} #yiv7971564659 a:visited, #yiv7971564659 span.yiv7971564659MsoHyperlinkFollowed{color:purple;text-decoration:underline;} #yiv7971564659 p.yiv7971564659msonormal0, #yiv7971564659 li.yiv7971564659msonormal0, #yiv7971564659 div.yiv7971564659msonormal0{margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;} #yiv7971564659 p.yiv7971564659yahoo-quoted-begin, #yiv7971564659 li.yiv7971564659yahoo-quoted-begin, #yiv7971564659 div.yiv7971564659yahoo-quoted-begin{margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;} #yiv7971564659 p.yiv7971564659msonormal0, #yiv7971564659 li.yiv7971564659msonormal0, #yiv7971564659 div.yiv7971564659msonormal0{margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;} #yiv7971564659 p.yiv7971564659msonormal, #yiv7971564659 li.yiv7971564659msonormal, #yiv7971564659 div.yiv7971564659msonormal{margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;} #yiv7971564659 p.yiv7971564659msochpdefault, #yiv7971564659 li.yiv7971564659msochpdefault, #yiv7971564659 div.yiv7971564659msochpdefault{margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;} #yiv7971564659 span.yiv7971564659msohyperlink{} #yiv7971564659 span.yiv7971564659msohyperlinkfollowed{} #yiv7971564659 span.yiv7971564659emailstyle18{} #yiv7971564659 span.yiv7971564659emailstyle20{} #yiv7971564659 p.yiv7971564659msonormal1, #yiv7971564659 li.yiv7971564659msonormal1, #yiv7971564659 div.yiv7971564659msonormal1{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;} #yiv7971564659 p.yiv7971564659msonormal2, #yiv7971564659 li.yiv7971564659msonormal2, #yiv7971564659 div.yiv7971564659msonormal2{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;} #yiv7971564659 span.yiv7971564659msohyperlink1{color:#0563C1;text-decoration:underline;} #yiv7971564659 span.yiv7971564659msohyperlinkfollowed1{color:#954F72;text-decoration:underline;} #yiv7971564659 p.yiv7971564659msonormal01, #yiv7971564659 li.yiv7971564659msonormal01, #yiv7971564659 div.yiv7971564659msonormal01{margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;} #yiv7971564659 p.yiv7971564659msonormal02, #yiv7971564659 li.yiv7971564659msonormal02, #yiv7971564659 div.yiv7971564659msonormal02{margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;} #yiv7971564659 span.yiv7971564659emailstyle181{font-family:sans-serif;color:#1F497D;font-weight:bold;} #yiv7971564659 span.yiv7971564659emailstyle201{font-family:sans-serif;color:#993366;font-weight:bold;} #yiv7971564659 p.yiv7971564659msochpdefault1, #yiv7971564659 li.yiv7971564659msochpdefault1, #yiv7971564659 div.yiv7971564659msochpdefault1{margin-right:0in;margin-left:0in;font-size:10.0pt;font-family:sans-serif;} #yiv7971564659 span.yiv7971564659EmailStyle36{font-family:sans-serif;color:#1F497D;font-weight:bold;} #yiv7971564659 .yiv7971564659MsoChpDefault{font-size:10.0pt;}_filtered #yiv7971564659 {margin:1.0in 1.0in 1.0in 1.0in;} #yiv7971564659 div.yiv7971564659WordSection1{} #yiv7971564659

I would recommend you do not try this yourself.  It isn’t simple or easy for a non-programmer, and there will be no end to the questions you will have, and rightfully so.  It is simple for an experienced programmer, but they will need a clear and concise specifications or written explanations of exactly what you need to accomplish with the conversion program, same as you would if you did it yourself.  For example, details of inputs, outputs, schemas for each, data to pass-thru as is, data to be converted, how it is converted (from what - to what), and expected results.  You need a map to get to an unknown destination.  So, my suggestion is you start there.  If you can’t write a clear specification, you nor anyone else is going to be able to program it.  Right now, all you have mentioned are general ideas and info, nothing specific.  If you don’t know how to write a specification, any developer on the forum will be able to help you.  This is a small task and does not require a long document, just one that is inclusive, concise, clear and accurate.  HTH!

  Hi Danny,

I did a research and am thinking of using flyway to do the migration.

What do you think?

Regards

Danny

 

 

From: Karen Goh <karenworld@yahoo.com>
Sent: Saturday, August 03, 2019 12:01 AM
To: Danny Severns <Danny@eidl-sw.com>; pgsql-novice@lists.postgresql.org
Subject: Re: How do I upgrade psql from version 7 to be 10 in Windows 10? [SEC=UNOFFICIAL]

 

Sent from Yahoo Mail for iPhone

On Friday, August 2, 2019, 4:34 AM, Danny Severns <Danny@eidl-sw.com> wrote:

I take it you are not a programmer, right?  If so, forget writing a simple program.

 

I don’t know of a FOSS tool.  I have a utility in my applications to convert files or tables in various formats to tables in the app’s db, where the user, using a graphical screen points and clicks on columns in the input schema and maps them to columns in the output schema.  The schemas can be loaded from reading the Psql Catalog or from the apps internal Data Dictionary.  However, the utility is embedded as part of our applications.  I would think something like that is available, but I’m not aware of it, if so.  Check on https://www.fosshub.com/ if you haven’t already.  If I were you, if you can’t find something, I would see if your company will pay to have someone write the conversion program before I would reenter the data, assuming there are not many rows.  If it is a large table, I definitely would not reenter the data.  In addition to the time, it would be error prone.   It would not have to be written in PHP, as any language would do that can access the db directly or thru ODBC.

 

I Guess I might have to write a conversion programme if really no choice but I reckon it will be tedious. Cos I need to make the programme know when to look for the next line. ...it will take me Long to figure things out. Do you know how to make how about this part? Because I have other data as numbers in “ “ or I could make it recognised on the 7th data they will consider anything is the next line and then put them within a loop m do the insertion into different table. I don’t know. I never attempted anything like this before....

 

Regards

Danny

 

From: Karen Goh <karenworld@yahoo.com>
Sent: Thursday, August 01, 2019 9:46 AM
To: Pilling, Michael <Michael.Pilling@dst.defence.gov.au>; David G. Johnston <david.g.johnston@gmail.com>; Danny Severns <Danny@eidl-sw.com>
Cc: pgsql-novice@lists.postgresql.org
Subject: Re: How do I upgrade psql from version 7 to be 10 in Windows 10? [SEC=UNOFFICIAL]

 

On Thursday, August 1, 2019, 8:53:29 PM GMT+8, Danny Severns <Danny@eidl-sw.com> wrote:


I am probably missing something, but I will give it a go. When you say “migrate it to another schema”, do you mean the columns in the table have changed, which is which is how I would interpret that phrase, or do you mean the same table schema but in a new Psql DB version?



If the latter, the pqAdmin app should suffice, as others have mentioned. If you mean the former, wouldn’t it just be a matter of writing a simple conversion program to read the old db, populate the new schema, and write out to the new db, i.e. a typical ETL routine? I’m sure you are trying to minimize the amount of manual conversion of data to upgrade, but if a table has changed between the old and new, sometimes a little manual work is required. But, like I said, I’m probably overlooking something and if so, please excuse my ignorance.

Hi Dennis,

Could you elaborate more on writing a simple conversion program to read the old db ? - typical ETL routine...

Actually, I would like to use a too, if it is available to migrate the data to the new schema.

BTW, I just downloaded the PHPMyAdmin and another shock just greeted me.... that I need to use WAMP server to install it. I wonder if there is a exe file that I can unpack on windows......



Regards

Danny



From: Karen Goh <karenworld@yahoo.com>
Sent: Wednesday, July 31, 2019 9:22 PM
To: Pilling, Michael <Michael.Pilling@dst.defence.gov.au>; David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-novice@lists.postgresql.org
Subject: Re: How do I upgrade psql from version 7 to be 10 in Windows 10? [SEC=UNOFFICIAL]



I check my host and it is written phpmyadmin but the strange thing is that the server type is MariaDB....



My problem is that I need to convert to PostgreSQL as now after installing the backup I need to migrate it to another schema. One way is use the web app I have done and key in one by one. Cos I can’t use MYSQL as it is down n bug cannot be fixed.



So everything will change. Since I am already talking about this, I would like to ask you if you know any tool out there, free ones, that can enable me to migrate it into a different scheme?



If I can’t I will then have to adapt my app to talk to phpmyadmin as a last resort.....






Sent from Yahoo Mail for iPhone

On Thursday, August 1, 2019, 8:35 AM, Pilling, Michael <Michael.Pilling@dst.defence.gov.au> wrote:

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






cid:image005.png@01D2822C.E0734BB0


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

E: michael.pilling@dst.defence.gov.au

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.



From: Karen Goh [mailto:karenworld@yahoo.com]
Sent: Wednesday, 31 July, 2019 6:58 p.m.
To: Pilling, Michael; David G. Johnston
Cc: pgsql-novice@lists.postgresql.org
Subject: Re: How do I upgrade psql from version 7 to be 10 in Windows 10? [SEC=UNOFFICIAL]



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.