Best Practise for Servoy/Postgres Backup

Questions and Answers on installation, deployment, management, locking, tranasactions of Servoy Application Server

Best Practise for Servoy/Postgres Backup

Postby Bernd.N » Wed Feb 25, 2015 10:39 pm

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.
Bernd Korthaus
Servoy 7.4.9 SC postgreSQL 9.4.11 Windows 10 Pro
User avatar
Posts: 507
Joined: Mon Oct 21, 2013 5:57 pm
Location: Langenhorn, North Friesland, Germany

Re: Best Practise for Servoy/Postgres Backup

Postby joe26 » Tue Aug 21, 2018 5:04 pm

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.

Posts: 95
Joined: Wed Jun 19, 2013 10:30 pm

Return to Servoy Server

Who is online

Users browsing this forum: No registered users and 1 guest