I would like to ask about recommendations regarding best practice to backup a Servoy solution running with Postgres:
a) how often do you run pg_dump during the day, and do you also backup changes between those full dumps, and how?
b) can you recommend physical server snapshots that are atomic, additionally to pg_dump?
Our environment consists of two virtual Windows 2012 Servers for DB and AppServer, with Postgres 9.4.0 and Servoy 7.4.2 with about 400 concurrent users.
Did you ever get resolution on postgres backup?
Currently have a button to execute a backup within the servoy app, but on the server, I cannot get the pgdump program to complete execution.
It creates a batch file locally from the smart client, streams the batch file to the server, and then uses UserManger.Server().executePrograms(backupBatchPath) on the server.
Works in developer, but permissions may not be possible within Servoy on the server, as the pg_dump process just sits there and hangs the UI.
Thanks!
–Joe.