Meteogalicia PostgreSQL Database (2000 - 2018)

<p>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.</p> <p>Version installed: postgresql 9.1</p> <p>Extension installed: postgis 1.5.3-1</p> <p>Instructions to restore the database:</p> <ol> <li>Create template:&nbsp; <p>createdb -E UTF8 -O postgres -U postgres template_postgis</p> </li> <li>Activate PL/pgSQL language:&nbsp; <p>createlang plpgsql -d template_postgis -U postgres</p> </li> <li>Load definitions of PostGIS: <p>psql -d template_postgis -U postgres -f /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql</p> <p>psql -d template_postgis -U postgres -f /usr/share/postgresql/9.1/contrib/postgis-1.5/spatial_ref_sys.sql</p> <p>psql -d template_postgis -U postgres -f /usr/share/postgresql/9.1/contrib/postgis_comments.sql</p> </li> <li>Create database with "MeteoGalicia" name with PostGIS extension:&nbsp; <p>createdb -U postgres -T template_postgis MeteoGalicia</p> </li> <li>Restore backup:&nbsp; <p>cat Meteogalicia* | psql MeteoGalicia</p> </li> </ol>