SHARE
TWEET

Untitled

a guest Jul 19th, 2019 53 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. raster2pgsql -s 96482 -I -d -F -R NETCDF:"/home/rowangaffney/Projects/CPER_DB_Testing/GIS_Data/MODIS_8day_VI.nc":_250m_16_days_NDVImodtest_rr modtest_rr | psql -d cper_test2
  2.      
  3. cper_test2=# d+ modtest_rr
  4.                                                   Table "public.modtest_rr"
  5.   Column  |  Type   | Collation | Nullable |                 Default                 | Storage  | Stats target | Description
  6. ----------+---------+-----------+----------+-----------------------------------------+----------+--------------+-------------
  7.  rid      | integer |           | not null | nextval('modtest_rr_rid_seq'::regclass) | plain    |              |
  8.  rast     | raster  |           |          |                                         | extended |              |
  9.  filename | text    |           |          |                                         | extended |              |
  10. Indexes:
  11.     "modtest_rr_pkey" PRIMARY KEY, btree (rid)
  12.     "modtest_rr_st_convexhull_idx" gist (st_convexhull(rast))
  13.  
  14. cper_test2=# SELECT (ST_METADATA(rast)).* FROM modtest_rr;
  15.     upperleftx     |    upperlefty    | width | height |      scalex      |      scaley       | skewx | skewy | srid  | numbands
  16. -------------------+------------------+-------+--------+------------------+-------------------+-------+-------+-------+----------
  17.  -8820663.32543447 | 4544750.26460167 |    83 |     44 | 231.656358264387 | -231.656358263455 |     0 |     0 | 96842 |      834
  18. (1 row)
  19.      
  20. gdalinfo PG:"host=localhost dbname=cper_test2 port=5434 table=modtest_rr"
  21. Driver: PostGISRaster/PostGIS Raster driver
  22. Files: none associated
  23. Size is 83, 44
  24. Coordinate System is:
  25. PROJCS["Sinusoidal",
  26.     GEOGCS["GCS_Undefined",
  27.         DATUM["Undefined",
  28.             SPHEROID["User_Defined_Spheroid",6371007.181,0.0]],
  29.         PRIMEM["Greenwich",0.0],
  30.         UNIT["Degree",0.0174532925199433]],
  31.     PROJECTION["Sinusoidal"],
  32.     PARAMETER["False_Easting",0.0],
  33.     PARAMETER["False_Northing",0.0],
  34.     PARAMETER["Central_Meridian",0.0],
  35.     UNIT["Meter",1.0]]
  36. Origin = (-8820663.325434470549226,4544750.264601670205593)
  37. Pixel Size = (231.656358264386995,-231.656358263454990)
  38. Corner Coordinates:
  39. Upper Left  (-8820663.325, 4544750.265) (104d54'15.75"W, 40d52'18.75"N)
  40. Lower Left  (-8820663.325, 4534557.385) (104d45'34.09"W, 40d46'48.75"N)
  41. Upper Right (-8801435.848, 4544750.265) (104d40'32.53"W, 40d52'18.75"N)
  42. Lower Right (-8801435.848, 4534557.385) (104d31'52.01"W, 40d46'48.75"N)
  43. Center      (-8811049.587, 4539653.825) (104d43' 3.29"W, 40d49'33.75"N)
  44. Band 1 Block=83x44 Type=Float32, ColorInterp=Undefined
  45.   NoData Value=-3000
  46. Band 2 Block=83x44 Type=Float32, ColorInterp=Undefined
  47.   NoData Value=-3000
  48. Band 3 Block=83x44 Type=Float32, ColorInterp=Undefined
  49.   NoData Value=-3000
  50. Band 4 Block=83x44 Type=Float32, ColorInterp=Undefined
  51.   NoData Value=-3000
  52. Band 5 Block=83x44 Type=Float32, ColorInterp=Undefined
  53.   NoData Value=-3000
  54. ...
  55.      
  56. cper_test2=# SELECT ST_SUMMARYSTATS(rast) FROM modtest_RR;
  57. SSL SYSCALL error: EOF detected
  58. The connection to the server was lost. Attempting reset: Failed.
  59. !> ^C
  60. !> q
  61.      
  62. 2019-07-19 09:17:38 MDT [1425-55] LOG:  server process (PID 14277) was terminated by signal 11: Segmentation fault
  63. 2019-07-19 09:17:38 MDT [1425-56] DETAIL:  Failed process was running: SELECT ST_SUMMARYSTATS(rast) FROM modtest_rr;
  64. 2019-07-19 09:17:38 MDT [1425-57] LOG:  terminating any other active server processes
  65. 2019-07-19 09:17:38 MDT [14269-1] WARNING:  terminating connection because of crash of another server process
  66. 2019-07-19 09:17:38 MDT [14269-2] DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
  67. 2019-07-19 09:17:38 MDT [14269-3] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
  68. 2019-07-19 09:17:38 MDT [14973-1] rowangaffney@cper_test2 FATAL:  the database system is in recovery mode
  69. 2019-07-19 09:17:38 MDT [14974-1] rowangaffney@cper_test2 FATAL:  the database system is in recovery mode
  70. 2019-07-19 09:17:38 MDT [1425-58] LOG:  all server processes terminated; reinitializing
  71. 2019-07-19 09:17:38 MDT [14975-1] LOG:  database system was interrupted; last known up at 2019-07-19 09:04:22 MDT
  72. 2019-07-19 09:17:39 MDT [14975-2] LOG:  database system was not properly shut down; automatic recovery in progress
  73. 2019-07-19 09:17:39 MDT [14975-3] LOG:  redo starts at 9/4CE01B00
  74. 2019-07-19 09:17:39 MDT [14975-4] LOG:  invalid record length at 9/4CE01B38: wanted 24, got 0
  75. 2019-07-19 09:17:39 MDT [14975-5] LOG:  redo done at 9/4CE01B00
  76. 2019-07-19 09:17:39 MDT [1425-59] LOG:  database system is ready to accept connections
  77.      
  78. postgis_version            |                                                                   version                                                                  
  79. ---------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------
  80.  2.5 USE_GEOS=1 USE_PROJ=1 USE_STATS=1 | PostgreSQL 10.8 (Ubuntu 10.8-1.pgdg16.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.11) 5.4.0 20160609, 64-bit
  81.  
  82. raster2pgsql -?
  83. RELEASE: 2.4.3 GDAL_VERSION=22 (r16312)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top