Moving Postgresql databases semi automatic script

Mats mats at
Fri Feb 23 09:19:45 UTC 2024


I have used pg_dump and pg_restore manually to move a database from one place to another.

Now I had the challenge to move many database to new locations: The first thing i thought of was to create a script in Omnis.
But as I had no idea how to do this and got no help from anywhere, so I looked at other solutions.

So instead I created (with some support from AI) a script based on pg_dump and pg_restore from pgAdmin using Go instead.
Here is a tutorial how I did it. It sure can be translated into Omnis or other languages.

I thought somebody else could get some ideas if and when the need for moving databases arises



More information about the omnisdev-en mailing list