Migrate databases files from one service to another

[bolinocroustibat]

Contrats for the great work.

Is there a way to copy all databases and associates settings from one DBngin service to another, for example to migrate from a PostgreSQL version to another?

For example:
I have a DBngin service for PostgreSQL 14 with several databases, and want to migrate the all the dabatases to PostgreSQL 15. So I created another service with PostgreSQL 15, and then I browsed the service files with "show database files" and copied them to the other one, with no success. What would be the right procedure / right files to copy for this?

An feature to upgrade the DB version of an existing service, or an option to copy databases files from one service to another, could also be a useful future DBnginx feature.

DBngin build number: DBngin 6.6
macOS version: MacOs 13.2.1

[huyphams]

Hi @bolinocroustibat you can dump the database with pg_dump and then restore it with pg_restore as that it the standard.