Move database from one server to another

hi mats:

As Bas said.
you go find it on your postregql installation (if postgres is not on your curent machine). It will be in the ‘bin’ directory of wherever you installed postgres

then copy pg_Dump and pg_restoer to your omnis installation… (i’d suggest beside the omnis.exe so you can use the sys() functions to find the local directory for the omnis program)

then you i’ll know where it is.

Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug@artsman.com
www.artsman.com
Phone (403) 650-1978

> On Jul 25, 2017, at 8:20 AM, ADJob <mats@adjob.se> wrote:
>
> Hej,
>
>> Launch program pg_dump -d=databasename -h=ipaddress -U=backupuser
>> -f=mybackup.backup << password (Do not quit Omnis) >> or
>> Start program normal {pg_dump -d=databasename -h=ipaddress -U=backupuser
>> -f=mybackup.backup << password} >>
>> Just need to add paths probably and make sure pg_dump is included with
>> you install.
>
> This does not work:
>
> Launch program pg_dump [gv_DB] > [gv_DB].sql (Do not quit Omnis)
> Start program normal {{pg_dump [gv_DB] > [gv_DB].sql}
>
> Nothing happens. No error etc
>
> This works, so I guess I have to add path to the pg_dump:
>
> Launch program :Applications:TextEdit.app (Do not quit Omnis)
> Start program normal {:Applications:TextEdit.app}
>
> how do I get the path to pg_dump?
>
> /Mats
>
>
>
>
>
>
>
>
>
>
> _____________________________________________________________
> Manage your list subscriptions at lists.omnis-dev.com

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