I am trying to export a table from postgres to a geopackage. But I get the following errors with the following command.
ogr2ogr -f GPKG /opt/data/ways.gpkg "PG:host=postgres dbname=osm user=postgres port=5432 " -sql "select * from ways" ERROR 1: COMMIT transaction failed: disk I/O error ERROR 1: Terminating translation prematurely after failed translation from sql statement. ERROR 1: Transaction not established ERROR 1: COMMIT transaction failed: disk I/O error
If I do the same thing but export to shapefile I dont have any issues. It will successfully export. Also it may be worth noting that Postgres is running in a docker container and I am trying to run this command in a seperate container. If I run the same command to export to gpkg from my macbook it works fine.
I am wondering if it is a sqlite issue but cant find anything there that has helped either.