Join GitHub today
GitHub is home to over 50 million developers working together to host and review code, manage projects, and build software together.
Sign upGitHub is where the world builds software
Millions of developers and companies build, ship, and maintain their software on GitHub — the largest and most advanced development platform in the world.
pgloader failed sqlite to postgresql migration (pgloader failed to find column) #1077
Comments
|
Can you share your redline SQLite database for me to reproduce the error locally and maybe fix it then? Thanks |
hello,
i want to migrate sqlite database to postgresql. unfortunately i got strange error.
i am using ubuntu 18.04
steps i follows:
1.
cp /var/lib/dbconfig-common/sqlite3/redmine/instances/default/redmine_default /tmp/redmine_backupdb.sqlite32
gem install rack -v 1.4.5 sqlite3 pg taps3 update Gemfile
bundle installcreate a new postgresql database CREATE DATABASE redmine WITH ENCODING='UTF8' OWNER=redmine;6 edit /etc/postgresql/10/main/pg_hba.conf
8 migrate
cd /usr/share/redmine
rake db:migrate
rake db:setup
pgloader --with "data only" /tmp/redmine_backupdb.sqlite3 postgresql://redmine:"Qwe12345!"@localhost/redmine**Error i got **