Moving Postgresql databases semi automatic script
Mats
mats at adjob.se
Fri Feb 23 09:19:45 UTC 2024
Hi,
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
https://dump.go4webdev.org/
FWIW,
/Mats
More information about the omnisdev-en
mailing list