search

hunzikp / velox

https://hunzikp.github.io/velox/
119 stars 23 forks source link

schema "raster" does not exist #4

Closed edzer closed 7 years ago

edzer commented 7 years ago

when trying to run your benchmark, I get:

> ## Import raster into PostGIS and index
> dbSendQuery(con, "DROP TABLE IF EXISTS raster.large;")
NOTICE:  schema "raster" does not exist, skipping
edzer commented 7 years ago

Well, I uncommented a few of these statements, set bench=TRUE, but then get

Error in postgresqlExecStatement(conn, statement, ...) : 
  RS-DBI driver: (could not Retrieve the result : ERROR:  relation "raster.large" does not exist
LINE 4:               FROM raster.large,
                           ^
)
Calls: benchmark ... dbSendQuery -> dbSendQuery -> postgresqlExecStatement -> .Call
Execution halted
hunzikp commented 7 years ago

The PostgreSQL NOTICE is harmless; the 'DROP .. IF EXISTS' statement triggering it is just a precautionary measure. The second error indicates that uploading the raster data to the PostGIS DB using the raster2pgsql utility must have failed. That may have been caused by the fact that the script used my username (hunzikp) when requesting the upload in a static manner. I've addressed this in two ways: You can now easily opt out of the PostGIS part of the benchmarking procedure using the TEST_PGIS boolean. You can also set your PostgreSQL username and password at the very beginning in a consistent manner. Would you try again with the new script? Thx.

edzer commented 7 years ago

Thanks, all runs well now, can confirm your outcomes.