azavea / vagrant-cartodb

Ansible role to build a multi-machine vagrant setup for CartoDB
Apache License 2.0
13 stars 3 forks source link

Provision foreign data wrapper setup #16

Closed CloudNiner closed 8 years ago

CloudNiner commented 8 years ago

Updates the provisioner to properly setup the FDW configuration when using the cartodb-org fork of cartodb, when using the ansible/group_vars/all.cartodb-org.example group vars file instead of all.example.

To Test

Clone the cartodb-org fork to ../cartodb and checkout the bbg_production branch. Then copy the ansible/group_vars/all.cartodb-org.example file to ansible/group_vars/all. Then run vagrant up and wait for the provisioner. Once it runs, you should be able to properly import FDW synced tables via the data library in the dashboard.

The existing all.example file will still work for the current master branch of hte upstream cartodb repository, and skips all of the local common data/FDW specific tasks.

I'm reprovisioning one more time on the bbg_production branch to verify this works as expected.

sharph commented 8 years ago

It looks like this repo is used by many folks at this point (as indicated by the number of stargazers.) Will this break the development environment for those people?

sharph commented 8 years ago

Nevermind!

sharph commented 8 years ago

I get Error importing dataset 'portland_building_footprints_r' : PG::Error: FATAL: remaining connection slots are reserved for non-replication superuser connections

as part of the large output of a ansible task (which was marked ok.)

CloudNiner commented 8 years ago

Thats fine, you should still have datasets added to your development user data library when you first go to your dashboard, although it may take a second or two.

We need to look into cleaning that up a bit, but its low priority ATM.

sharph commented 8 years ago

LGTM