Timeline for Schema error while uploading raster in PostgreSQL
Current License: CC BY-SA 4.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 30, 2021 at 2:20 | history | edited | PolyGeo♦ | CC BY-SA 4.0 |
added 173 characters in body
|
| May 29, 2021 at 17:13 | comment | added | Abhilash Singh Chauhan | But it works fine when i use it from command prompt as raster2pgsql.exe -I -C -s 4326 D:\Advisory\Raster\MODIS_All_India_NDVI_2001_01_01.tif -t auto public.MODIS_All_India_NDVI_2001_01_01 | psql -d agro_dss -U postgres -p 5432 -h localhost | |
| May 29, 2021 at 17:11 | comment | added | Vince | If the error says it can't read "file" tablename, then it is not a schema issue (instead, it is likely a syntax issue). You have provided two different failure cases, and they are obfuscated by being invoked from Python (without even a diagnostic print statement showing the actual usage). | |
| May 29, 2021 at 15:54 | comment | added | Abhilash Singh Chauhan | however, the error says Unable to read raster file: public.polys, rather it is schema instead of rater, so not sure where this syntax is wrong | |
| May 29, 2021 at 15:51 | comment | added | Abhilash Singh Chauhan | @Vince, It has one question only. I have tried many ways to insert the raster in PostgreSQL database,but the same error is coming from all of these. | |
| May 29, 2021 at 15:49 | history | edited | Abhilash Singh Chauhan | CC BY-SA 4.0 |
deleted 189 characters in body
|
| May 29, 2021 at 15:02 | review | Close votes | |||
| Jun 6, 2021 at 0:31 | |||||
| May 29, 2021 at 14:49 | comment | added | Vince | The database instance is called a "server" even it runs on a toaster-oven. Worst-practice security destroys servers. | |
| May 29, 2021 at 14:45 | comment | added | Abhilash Singh Chauhan | Thanks for the concern @Vince, It was on localhost, not on server though. | |
| May 29, 2021 at 14:43 | history | edited | Vince | CC BY-SA 4.0 |
naming
|
| May 29, 2021 at 14:43 | comment | added | Vince |
Never, never use the postgres login for anything other than creating new user-privilege logins and roles for managing access to the server. Please ask only one question per Question.
|
|
| May 29, 2021 at 14:28 | history | edited | Abhilash Singh Chauhan | CC BY-SA 4.0 |
edited title
|
| May 29, 2021 at 14:20 | history | asked | Abhilash Singh Chauhan | CC BY-SA 4.0 |