DB restore errors

root@Dev:~ # pg_restore -h localhost -U superuser -d postgres -C Room-DB
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 3700; 1262 16384 DATABASE room postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  database "room" already exists
    Command was: CREATE DATABASE room WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8';



pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER DATABASE room OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 7; 2615 34105 SCHEMA tiger postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  schema "tiger" already exists
    Command was: CREATE SCHEMA tiger;



pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER SCHEMA tiger OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 9; 2615 34673 SCHEMA tiger_staging postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  schema "tiger_staging" already exists
    Command was: CREATE SCHEMA tiger_staging;



pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER SCHEMA tiger_staging OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 3026; 3602 41230 TEXT SEARCH CONFIGURATION english postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  duplicate key value violates unique constraint "pg_ts_config_cfgname_index"
DETAIL:  Key (cfgname, cfgnamespace)=(english, 2200) already exists.
    Command was: CREATE TEXT SEARCH CONFIGURATION english (
    PARSER = pg_catalog."default" );

ALTER TEXT SEARCH CONFIGURATION english
   ...
pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER TEXT SEARCH CONFIGURATION public.english OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 175; 1259 32781 TABLE cities postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "cities" already exists
    Command was: CREATE TABLE cities (
    city_id integer NOT NULL,
    name character varying(50),
    short_name character varying(5)
);



pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER TABLE public.cities OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 176; 1259 32786 TABLE countries postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "countries" already exists
    Command was: CREATE TABLE countries (
    country_id integer NOT NULL,
    name character varying(30),
    short_name character varying(4...
pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER TABLE public.countries OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 246; 1259 41059 SEQUENCE country_country_id_seq postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "country_country_id_seq" already exists
    Command was: CREATE SEQUENCE country_country_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;



pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER TABLE public.country_country_id_seq OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 245; 1259 41057 SEQUENCE county_country_id_seq postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "county_country_id_seq" already exists
    Command was: CREATE SEQUENCE county_country_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;



pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER TABLE public.county_country_id_seq OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 251; 1259 41197 TABLE event_messages postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "event_messages" already exists
    Command was: CREATE TABLE event_messages (
    message_id bigint NOT NULL,
    user_id integer,
    event_id integer,
    sent timestamp(...
pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER TABLE public.event_messages OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 174; 1259 32768 TABLE event_tags postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "event_tags" already exists
    Command was: CREATE TABLE event_tags (
    event_id integer,
    tag_id integer
);



pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER TABLE public.event_tags OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 177; 1259 32791 TABLE events postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER TABLE public.events OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 247; 1259 41067 SEQUENCE events_event_id postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "events_event_id" already exists
    Command was: CREATE SEQUENCE events_event_id
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;



pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER TABLE public.events_event_id OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 248; 1259 41069 SEQUENCE events_event_id_seq postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "events_event_id_seq" already exists
    Command was: CREATE SEQUENCE events_event_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;



pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER TABLE public.events_event_id_seq OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 244; 1259 41047 TABLE global_points postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER TABLE public.global_points OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 243; 1259 41045 SEQUENCE global_points_id_seq postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "global_points_id_seq" already exists
    Command was: CREATE SEQUENCE global_points_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;



pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER TABLE public.global_points_id_seq OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 253; 1259 42739 TABLE roles postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "roles" already exists
    Command was: CREATE TABLE roles (
    role_id integer NOT NULL,
    name character varying(50) DEFAULT NULL::character varying
);



pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER TABLE public.roles OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 173; 1259 24576 TABLE tags postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "tags" already exists
    Command was: CREATE TABLE tags (
    tag_id integer NOT NULL,
    name character varying(10) NOT NULL,
    description character varying(...
pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER TABLE public.tags OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 254; 1259 42745 TABLE user_events postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "user_events" already exists
    Command was: CREATE TABLE user_events (
    user_id integer NOT NULL,
    event_id integer NOT NULL,
    role_id smallint NOT NULL
);



pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER TABLE public.user_events OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 250; 1259 41184 TABLE user_phones postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "user_phones" already exists
    Command was: CREATE TABLE user_phones (
    user_id integer,
    phone_country smallint,
    phone_area smallint,
    phone_number charac...
pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER TABLE public.user_phones OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 249; 1259 41174 TABLE users postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "users" already exists
    Command was: CREATE TABLE users (
    user_id integer NOT NULL,
    fname character varying(255) DEFAULT NULL::character varying,
    lna...
pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER TABLE public.users OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 252; 1259 41215 TABLE users_followed postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "users_followed" already exists
    Command was: CREATE TABLE users_followed (
    user_id integer,
    followed_id integer
);



pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER TABLE public.users_followed OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 241; 1259 34674 TABLE county_all postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER TABLE tiger_data.county_all OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 242; 1259 41037 TABLE county_all_lookup postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER TABLE tiger_data.county_all_lookup OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 240; 1259 34531 TABLE state_all postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist
    Command was: ALTER TABLE tiger_data.state_all OWNER TO postgres;


pg_restore: [archiver (db)] Error from TOC entry 3679; 0 32786 TABLE DATA countries postgres
pg_restore: [archiver (db)] COPY failed for table "countries": ERROR:  duplicate key value violates unique constraint "countries_pkey"
DETAIL:  Key (country_id)=(1) already exists.
CONTEXT:  COPY countries, line 1
pg_restore: [archiver (db)] Error from TOC entry 3424; 0 34112 TABLE DATA geocode_settings postgres
pg_restore: [archiver (db)] COPY failed for table "geocode_settings": ERROR:  duplicate key value violates unique constraint "geocode_settings_pkey"
DETAIL:  Key (name)=(debug_geocode_address) already exists.
CONTEXT:  COPY geocode_settings, line 1