[google-cloud-sql-discuss] Re: Cloud SQL postgres tiger geocoder + data

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)

On Thursday, September 7, 2017 at 3:17:58 PM UTC-4, Jordan (Cloud Platform Support) wrote:

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. 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/63fca8a2-22f3-4a96-bc93-67a37f8fd6d8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.