Getting Started
The other day, we at Solaris Offgrid needed to port our database over to PostgreSQL. It was time.
For that task we used the handy tool that Dimitri Fontaine built.
I thought the instructions on installing the tool on a Mac could have been a bit clearer. So I wrote it up.
- In your terminal, clone the project onto your machine
git clone https://github.com/dimitri/pgloader.git
-
brew install sbcl brew install clozure-cl brew install freetds --universal --build-from-source
-
cd pgloader
- You probably wont have to run
as the last command should have run that for you. That did it for me!make
-
Now it is installed../build/bin/pgloader --version
- Create an alias for pgloader
. Then cntrl + o, enter, cntrl + xnano ~/.bash-profile alias pgloader="copied path_to_here/build/bin/pgloader"
- Test again:
pgloader --version pgloader --help
Voila!
Hope it helps! If it doesn't work, let me know and Ill help out as much as possible.