AW: Move database from one server to another

Rudolf Bargholz rudolf at
Mon Jul 17 09:41:17 EDT 2017

Hi Mats,

The easiest method would really be to script this outside of Omnis. You can write the script from Omnis, but scripting this will allow you to test the whole process outside of Omnis, and when it works the way you want, you can replace the IPs with placeholders, then from Omnis make a copy of the script file, replace the placeholders in your file with appropriate values, and then open the script file  from Omnis.


Rudolf Bargholz

-----Ursprüngliche Nachricht-----
Von: omnisdev-en [mailto:omnisdev-en-bounces at] Im Auftrag von ADJob
Gesendet: Montag, 17. Juli 2017 14:47
An: omnisdev-en at
Betreff: Move database from one server to another


Sometimes you have to move a database from one old postgresql server to new postgresql server. I have done this before with PGAdmin using pg_dump and pg_restore. 

My goal is however to do the move from within Omnis. Add new IP and click a button, sort of.

1. Can I do pg_dump / pg_restore from within Omnis?
2. Any tip how to do this in an other smart way? 

I have done something similar moving a native datafile into a Postgresql server, so I know it is possible. I have a solution, but I am searching for a smarter way.

Any advice or input appreciated.

Manage your list subscriptions at

More information about the omnisdev-en mailing list