Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

postgis_raster extension not loaded #161

Open
matburnham opened this issue Jul 19, 2022 · 2 comments
Open

postgis_raster extension not loaded #161

matburnham opened this issue Jul 19, 2022 · 2 comments

Comments

@matburnham
Copy link

flask database init doesn't create extension postgis_raster so raster2pgsql fails:

$ raster2pgsql *.tif -s 4326 -d -M -C -I -F -t 25x25 public.elevation | psql -d ogn
Processing 1/4: 30N000E_20101117_gmted_mea075.tif
BEGIN
NOTICE:  table "elevation" does not exist, skipping
DROP TABLE
ERROR:  type "raster" does not exist
LINE 1: ...lic"."elevation" ("rid" serial PRIMARY KEY,"rast" raster,"fi...
                                                             ^
ERROR:  current transaction is aborted, commands ignored until end of transaction block
@matburnham
Copy link
Author

Simple fix is to apply create extension postgis_raster manually, but it would be nicer if I didn't have to remember.

@matburnham
Copy link
Author

matburnham commented Jul 19, 2022

Looks like sbrodehl/ogn-python@355158c fixes this.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant