Monthly Archives: February 2017

//February

PostGIS – How to create a Spatial Database with PGC Command Line

We are excited to announce that BigSQL distributions of PostGIS now come bundled with several popular community spatial extensions: postgis fuzzystrmatch postgis_tiger_geocoder postgis_topology ogr_fdw address_standardizer address_standardizer_data_us This is the only community distribution to offer PostGIS with these extensions across ALL platforms (Mac, Linux, and Windows)! So, for all you GeoGeeks using Linux / Mac - [...]

By | February 10th, 2017|Categories: Holly PostGIS|Tags: , , |1 Comment

Are you a Yoda or a Diego?

In the geospatial world there are usually 2 types of people supporting spatially enabled databases: 1. GIS analysts  (scientist, statisticians, analysts, etc) who find themselves as the de facto DBA (among other things). “I don’t have time for this! I’m saving this sea turtle. Just give me a GUI!” 2. DBAs who find themselves supporting these strange [...]

By | February 8th, 2017|Categories: Holly PostGIS|0 Comments

Don’t move your Oracle database to the cloud

Why move your Oracle database to the cloud? It just doesn't make sense. You are moving to the cloud for flexibility, for cost savings, for ease of changing your infrastructure. Does doubling your Oracle license fee for AWS or Azure usage sound like Oracle wants to let you have flexibility or cost savings?? (Hint: NO!!) [...]

By | February 7th, 2017|Categories: OpenSource|Tags: , , , , |0 Comments

Using pg_bulkload to load data to PostgreSQL

PostgreSQL by BigSQL is committed to making Postgres user and developer friendly. As part of this effort, we continue to extend the list of extensions we ship and support. Recently, we started supporting pg_bulkload, a high speed data loading utility for PostgreSQL. In this blog post, we will illustrate how to quickly install and use [...]

By | February 1st, 2017|Categories: Jobin PostgreSQL|Tags: , , |0 Comments