PG_Restore error

[David Haynes]

Hello,

I have an old PostgreSQL database dump file that uses the old PostGIS
extension. What I mean is that the database was created when the extension
used to be CREATE Extension PostGIS. Now there are at least 2 commands:
CREATE Extension postgis and  CREATE Extension postgis_raster; This
particular database has both vector and raster datasets. To complicate
matters, I unintentionally dumped it in a binary format.

I have been somewhat successful in getting the DB to load. I'm using a
pg_restore command using the following flags (--no-owner --create --clean).
However, I get a lot of errors because the database can not create raster
datasets as that datatype does not exist. Is there a command that I can
issue during this pg_restore process to initialize the postgis_raster
extension? If not, what are my next steps? Do I need to load the database
onto an older version of PostGIS?

Thanks for any feedback
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20260210/76d69330/attachment.htm>