Mongify does not work with Postgresql adapter

[nguyenhoangnhon]

Hi guys, I am using Mongify to migrate data from PostgreSQL to Mongo DB. When I run command to check PostgreSQL connection , I get a following issue, please help me fix it .
My OS is Ubuntu18.04.

lab@lab:~/mongify$ mongify check database.config
Traceback (most recent call last):
22: from /usr/local/bin/mongify:23:in

' 21: from /usr/local/bin/mongify:23:inload'
20: from /var/lib/gems/2.5.0/gems/mongify-1.3.2/bin/mongify:17:in <top (required)>' 19: from /var/lib/gems/2.5.0/gems/mongify-1.3.2/lib/mongify/cli/application.rb:28:inexecute!'
18: from /var/lib/gems/2.5.0/gems/mongify-1.3.2/lib/mongify/cli/command/worker.rb:68:in execute' 17: from /var/lib/gems/2.5.0/gems/mongify-1.3.2/lib/mongify/cli/command/worker.rb:99:incheck_sql_connection'
16: from /var/lib/gems/2.5.0/gems/mongify-1.3.2/lib/mongify/database/sql_connection.rb:57:in has_connection?' 15: from /var/lib/gems/2.5.0/gems/activerecord-4.2.11.1/lib/active_record/connection_handling.rb:87:inconnection'
14: from /var/lib/gems/2.5.0/gems/activerecord-4.2.11.1/lib/active_record/connection_handling.rb:113:in retrieve_connection' 13: from /var/lib/gems/2.5.0/gems/activerecord-4.2.11.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:571:inretrieve_connection'
12: from /var/lib/gems/2.5.0/gems/activerecord-4.2.11.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:262:in connection' 11: from /usr/lib/ruby/2.5.0/monitor.rb:226:inmon_synchronize'
10: from /var/lib/gems/2.5.0/gems/activerecord-4.2.11.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:263:in block in connection' 9: from /var/lib/gems/2.5.0/gems/activerecord-4.2.11.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:348:incheckout'
8: from /usr/lib/ruby/2.5.0/monitor.rb:226:in mon_synchronize' 7: from /var/lib/gems/2.5.0/gems/activerecord-4.2.11.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:349:inblock in checkout'
6: from /var/lib/gems/2.5.0/gems/activerecord-4.2.11.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:422:in acquire_connection' 5: from /var/lib/gems/2.5.0/gems/activerecord-4.2.11.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:448:incheckout_new_connection'
4: from /var/lib/gems/2.5.0/gems/activerecord-4.2.11.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:438:in new_connection' 3: from /var/lib/gems/2.5.0/gems/activerecord-4.2.11.1/lib/active_record/connection_adapters/postgresql_adapter.rb:45:inpostgresql_connection'
2: from /var/lib/gems/2.5.0/gems/activerecord-4.2.11.1/lib/active_record/connection_adapters/postgresql_adapter.rb:45:in new' 1: from /var/lib/gems/2.5.0/gems/activerecord-4.2.11.1/lib/active_record/connection_adapters/postgresql_adapter.rb:243:ininitialize'
/var/lib/gems/2.5.0/gems/activerecord-_### 4.2.11.1/lib/active_record/connection_adapters/postgresql_adapter.rb:652:in `connect': uninitialized constant ActiveRecord::ConnectionAdapters::PostgreSQLAdapter::PGconn (NameError)_

[anlek]

@nguyenhoangnhon. See if you can run gem install pg. I believe ActiveRecord uses that gem to make the connection.

[nguyenhoangnhon]

Hi anlek,
I run command "gem install pg" but it isn't ok. I checked mongify with mysql2 , it worked fine with mysql2 but with postgesql i get that issue

[anlek]

This might help: https://stackoverflow.com/questions/3116015/how-to-install-postgresqls-pg-gem-on-ubuntu