Servoy Server Backup

[nromeou]

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??

Thanks for your time.

Cheers

[ngervasi]

The solutions are stored in the Repository database so if you include that db in your backup you should be fine.

[ROCLASI]

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.

Hope this helps.

[Thomas Parry]

Robert, your script looks useful - any tips on how to make it work on win7?

[nromeou]

Thanks to all, this info was really helpful.