Move database from one server to another

Hello Mats,

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

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: mike.matthews@lineal.co.uk <mailto:mike.matthews@lineal.co.uk>
> On 17 Jul 2017, at 13:46, ADJob <mats@adjob.se> wrote:
>
> Hi,
>
> 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.
>
> /Mats
> _____________________________________________________________
> Manage your list subscriptions at lists.omnis-dev.com

_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com