Move database from one server to another
Not sure about PG, but we do do this with FrontBase. But I think it is difficult with PG, and as always, there is someone here with a suitable strategy of course. 🙂
Mike Matthews, Managing Director, Lineal Software Solutions Ltd
Apple Reseller, Microsoft Partner, SQLWorks Business Partner
phone: 01271 375999 | web: lineal.co.uk <www.lineal.co.uk/> | email: firstname.lastname@example.org <mailto:email@example.com>
> On 17 Jul 2017, at 13:46, ADJob <firstname.lastname@example.org> wrote:
> 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 lists.omnis-dev.com
Manage your list subscriptions at lists.omnis-dev.com