How to dump, edit dump and restore PGSTAC db?

[luipir]

hi, I'm using standard eoAPI docker compose and correctly created stac catalog with relative collections and items.
Now I need to move the db in another stac db but editing some items asset urls before to populate the new db,

What would be the the correct procedure? I did pg_dump in sql format and restored via psql but some import error are triggered and result stac catalog result empty to stac-browser.

So my question is, what would be the proper dump/restore procedure for a stac DB?

[drnextgis]

Hi @luipir! How I solved it in the past: I created a dump using standard PostgreSQL tools, then converted that dump into a new ndjson file containing properly formatted STAC items, which then ingested into a new database using pypgstac CLI.

[luipir]

tnx @drnextgis too many manual steps that can be wrong! so lack of proper pypgstac dump command in ndjson to be used in pypgstac load command?

[drnextgis]

That would be great to have!

[luipir]

tnx @drnextgis too many manual steps that can be wrong! so lack of proper pypgstac dump command in ndjson to be used in pypgstac load command?

did you dump all or just data and blobs? e.g. -a and -b pg_dump options?

[drnextgis]

I'm not entirely sure, but it's most likely just the data.

[vincentsarago]

We hope at one point we would have a dump tool either in pypgstac or in https://github.com/stac-utils/stac-rs but we will need $$ for this at the moment

cc @bitner @gadomski

[luipir]

checking https://github.com/stac-utils/rustac-py if export has been simplified

[gadomski]

Not yet, at least in a published way. We'd like to but, speaking for myself, no one's funding me to work on it yet.