Meteogalicia PostgreSQL Database (2000 - 2018)

This database contains: rainfall, humidity, temperature, global solar radiation, wind velocity and wind direction ten-minute data from 150 stations of the Meteogalicia network between 1-jan-2000 and 31-dec-2018.

Version installed: postgresql 9.1

Extension installed: postgis 1.5.3-1

Instructions to restore the database:

Create template: 

createdb -E UTF8 -O postgres -U postgres template_postgis

Activate PL/pgSQL language: 

createlang plpgsql -d template_postgis -U postgres

Load definitions of PostGIS:

psql -d template_postgis -U postgres -f /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql

psql -d template_postgis -U postgres -f /usr/share/postgresql/9.1/contrib/postgis-1.5/spatial_ref_sys.sql

psql -d template_postgis -U postgres -f /usr/share/postgresql/9.1/contrib/postgis_comments.sql

Create database with "MeteoGalicia" name with PostGIS extension: 

createdb -U postgres -T template_postgis MeteoGalicia

Restore backup: 

cat Meteogalicia* | psql MeteoGalicia