PostgreSQL & $base_url support

[ElusiveMind]

Code support changes for Postgres. Does not import postgres db as part of the Drupal plugin due to some issues that need to be worked out. I have worked through this by the following in my probo.yml with this recipe handling import.

- name: Setup PostgreSQL . plugin: Script . script: | . gunzip $ASSET_DIR/fsis-analytics.sql.gz . psql drupal < $ASSET_DIR/fsis-analytics.sql

Also includes support for the optional $base_url variable for Drupal 7. This was needed for open source to mitigate issues when serving pages under the probo random SSL.

[kleinmp]

Would exporting with the no-owner flag get around this issue?

[ElusiveMind]

A good question. I will need to run a test of this to see if it works but I can do that sooner than later. I didn't know PostgreSQL had an option (not that versed in pg). Will report back later tonight

[ElusiveMind]

That worked swimmingly. I removed the sed line and it worked fine. It even worked on the old non-exported db, but had a lot of warnings.... but I'd suggest we recommend pg_dump with the -O -x flags.

[kleinmp]

I added some updates to this so that we can import a pgsql database in the LAMP plugin. I couldn't figure out how to branch off of this one since it's coming from a forked repo so I copied the code and created a totally separate branch. I did not include the base_url code because I haven't tested it yet.

You can see it at https://github.com/ProboCI/probo/pull/155.

[ElusiveMind]

Needs to be refactored. Will re-develop.