Hi,
I’m in need of performing a backup on my Servoy Server.
The workaround was to do a backup of the full server hosting the Servoy Server, but the ideal is to backup only the databases and the solutions running on the server.
To do a backup on the databases it should be enough to copy the database file or do a backup from sybase central or its counterpart in postgre.
The main issue is I don’t know how to perform a backup of the solutions loaded in my server.
Is there a way to get those solutions??
I wasn’t able to find any trace of .servoy files in the application server folder, just the example ones.
Could someone point me to the right folder??
Is there a better way of doing the backup other than copying files manualy??
nromeou:
To do a backup on the databases it should be enough to copy the database file or do a backup from sybase central or its counterpart in postgre.
Just be aware that in PostgreSQL (or call it Postgres since it was the successor of Ingres) you don’t have a database file like Sybase has. Instead it has a ‘database cluster’ which is in fact a collection of files and directories which holds all your databases. It’s not recommended to backup these files (or at least make sure Postgres is not running and you know what you’re doing) but use the commandline tools pg_dump/pg_dumpall to make a backup file. The DBA tool PgAdmin uses these tools as well but provides you an easy GUI for it.
Also I posted an easy shell script for backing up all your databases in your cluster with a dumpfile per database.