![]() I can confirm that I was able to get pgloader working using Docker for Windows. This solution may come a little late to the original asker, but for those still searching for a windows solution. Suggestions for using Python to clean up the data prior to import (caveat: I have very little experience with Python).Detailed instructions for compiling pg_loader on Windows.Windows installer of a comparable alternative to pg_loader.However, the website does not offer either a Windows installer or instructions for compiling it on Windows.Ĭan anyone point me in the direction of one of the following, with the list going from most desirable to least desirable? Given all this as a backdrop, I have a need to use pg_loader to import various datasets. For one dataset, I first import it into MySQL, strip offending characters from the data, export it back out to CSV, and finally import this cleaned-up data into PostgreSQL.Īs an experiment, I installed PostgreSQL 9.6 and pg_loader on my home iMac running macOS 10.12, and it is able to import all of the datasets with no problem. These datasets have a crazy variation of encoding and formatting which creates challenges while importing them. I use this database to import a number of medium-sized datasets from various sources and perform some in-depth analysis and reporting. #Download pg commander software#I do not have admin privileges on this laptop, but can do "many" things, including software installation, through elevated rights granted through BeyondTrust. I am running PostgreSQL 9.6 on a Windows 7 laptop that is tightly managed by corporate IT. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |