Cloud SQL postgres tiger geocoder + data

[Shankha Basu]

Hi,

We see that the postgis tiger geocoder extension is available. Is there any special/efficient way with respect to getting TIGER data fully loaded on an instance? 

Thanks - sb

[Jordan (Cloud Platform Support)]

According to the documentation you would install PostGIS that same way you would on any other SQL instance, nothing special. Google Groups is meant for general product discussions, if you require technical support for installing PostGIS it is recommended to consult their support channels. 

[Shankha Basu]

Thanks for your reply!! Our assumption (which we tested) is that there should not be any need for enabling the following three extensions. 

• postgis
• postgis_tiger_geocoder
• postgis_topology

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)

[Jordan (Cloud Platform Support)]

If you run into any specific technical issues with directly loading the data into your instance it is recommended to described the full issue on Stack Overflow using the supported Google Cloud tags, as Google Groups is meant for general product discussions and not technical support.