We just want to ask the community if someone has user the postgis_tiger_geocoder and has loaded TIGER data into an GCP Cloud SQL Postgres instance? If this entails downloading the entire set of TIGER files and using standard utilities to write to the instance or if someone has devised any other efficient method using native cloud storage and parallel threads etc?
The extensions are created without any special installations (pls see below),
psql (9.3.18, server 9.6.1)
WARNING: psql major version 9.3, server major version 9.6.
Some psql features might not work.
Type "help" for help.
test=>
test=> create extension postgis;
CREATE EXTENSION
test=> create extension postgis_tiger_geocoder;
ERROR: required extension "fuzzystrmatch" is not installed
HINT: Use CREATE EXTENSION ... CASCADE to install required extensions too.
test=> create extension postgis_tiger_geocoder cascade;
CREATE EXTENSION
test=> create extension postgis_topology;
CREATE EXTENSION
test=> \d
List of relations
Schema | Name | Type | Owner
----------+-------------------+----------+----------
public | geography_columns | view | mdxadmin
public | geometry_columns | view | mdxadmin
public | raster_columns | view | mdxadmin
public | raster_overviews | view | mdxadmin
public | spatial_ref_sys | table | mdxadmin
topology | layer | table | mdxadmin
topology | topology | table | mdxadmin
topology | topology_id_seq | sequence | mdxadmin
(8 rows)