Export staging databse and import to production site

[garethrees]

Confirm with team Nicaragua that these are good to be published on the production site:

• [ ] Public Authorities
• [ ] Existing Requests
• [ ] User Accounts
• [ ] Categories
• [ ] Tracks

[jbaezni]

Asi es.

[garethrees]

Import everything mentioned here.

[garethrees]

Imported the whole staging DB to preserve all the existing associations.

Had a couple of errors that I need to check out tomorrow:

Password:
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 230; 1255 722599 FUNCTION plpgsql_call_handler() postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  permission denied for language c
    Command was: CREATE FUNCTION plpgsql_call_handler() RETURNS opaque
    LANGUAGE c
    AS '$libdir/plpgsql', 'plpgsql_call_handler';

pg_restore: WARNING:  no privileges could be revoked for "public"
pg_restore: WARNING:  no privileges could be revoked for "public"
pg_restore: WARNING:  no privileges were granted for "public"
pg_restore: WARNING:  no privileges were granted for "public"
WARNING: errors ignored on restore: 1

[garethrees]

Done