Restoring data dump in rosetta container fails

[xin-hedera]

Description

When trying to restore a data dump for rosetta using restorein the entrypoint script, it fails.

At one point, it failed since pg_restore can't create temporary schema as it already exists. On another count, it failed as the user mirror_node doesn't have privilege to create btree_gist extension.

With some tricky workaround, a dump to get around the schema and extension issue made it work. We need to create a runbook and note the workarounds.

Steps to reproduce

create a db dump using pg_dump and try to restore it with the rosetta container.

Additional context

No response

Hedera network

other

Version

v0.116.0

Operating system

None

[xin-hedera]

for the record, this is the command to workaround the issues

$ pg_dump -F d -f data_dump -N temporary -e plpgsql -h localhost -U mirror_node mirror_node

• skips the temporary schema
• only dump plpgsql extension which turns out with no extensions dumped