Best Practise for Servoy/Postgres Backup
Posted: 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.
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.