securedrop.org
securedrop.org copied to clipboard
`make dev-restore-db` is not playing nicely with hstore.
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...
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.