securedrop.org icon indicating copy to clipboard operation
securedrop.org copied to clipboard

`make dev-restore-db` is not playing nicely with hstore.

Open raq929 opened this issue 7 years ago • 1 comments

make dev-restore-db
./devops/scripts/restoredb.sh
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 279; 1259 17921 TABLE search_searchdocument securedrop
pg_restore: [archiver (db)] could not execute query: ERROR:  type "hstore" does not exist
LINE 6:     data hstore NOT NULL,
                 ^
    Command was: CREATE TABLE search_searchdocument (
    id integer NOT NULL,
    title character varying(255) NOT NULL,
    url character v...
make: *** [dev-restore-db] Error 1

for some reason pg_dump doesn't seem to dump the create extension hstore; command

This may not be worth fixing at this point, as it's just a problem with internal tools, but if there's time...

raq929 avatar Oct 31 '17 15:10 raq929

I am able to reproduce this but I'm not sure I have the bash/postgres-savvy to resolve it myself. I'm going to table it for now and we can revisit if these commands make it through @msheiny's Grand Website Devops Restructure.

harrislapiroff avatar Mar 20 '18 18:03 harrislapiroff