757276 - make setupdb_app.py support both pgsql 9.0 and 9.1

Status: RESOLVED FIXED

(Socorro :: Database, task)

Description

[Robert Helmer [:rhelmer]]

Per bug 757274 we want to switch to 9.0, but we need to load the "citext" extension differently depending on the version, and we should support both versions during the transition period.

I am planning to detect the server version and either load the citext.sql (for 9.0) or execute "CREATE EXTENSION citext FROM unpackaged".

While I am in there, I am thinking the script should prompt for an unknown version e.g.:

"WARNING: socorro has not been tested on PostgreSQL 8.4, run anyway? [y/N]"

Comment 1

[Robert Helmer [:rhelmer]]

r? https://github.com/mozilla/socorro/pull/664

Note that the current schema dump checked in won't work with 9.1 as-is, but this code would load it correctly if it was a psql 9.1-compatible schema dump :)

Comment 2

[[github robot]]

Commits pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/98f7e7ad64ae62e6a70c52d56ca5a93291ca1c92
bug 757276 - support postgresql 9.1

https://github.com/mozilla/socorro/commit/b7a53c77a25d4574dd264d394891d2c63c053415
Merge pull request #664 from rhelmer/bug757276-support-pg91

bug 757276 - support postgresql 9.1

Comment 3

[[github robot]]

Commits pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/d8d7fa31f254fd2888d401498ba1a3be87d3a9f1
bug 757276 - only load citext if --no-schema is specified

https://github.com/mozilla/socorro/commit/397e8b0ed547e2c80a7ad43c1b665eeb35db0c7a
Merge pull request #666 from rhelmer/master

bug 757276 - only load citext if --no-schema is specified