Page History

...

The -N option specifies the name for the Windows Service. Make sure the name is unique. 

OSX

TODO

*nix

TODO

Performing backups

...

Manual backups

...

& restores

http://www.servoy.com/forum/viewtopic.php?f=5&t=15257#p81763

PostgreSQL stores it's data in a 'database cluster' which is a collection of files and directories that together make up the entire database. It's not recommended to backup these files, but instead use the backup utilities that come with PostgreSQL.

...

Manual backups

...

PostgreSQL provides a pg_dump and a pg_dumpall utility to make a backup file of a running database. In a default installation of Servoy, the utilities are located in ../application_server/postgres_db/bin/. These utilities can be used command-line, but also through the PgAdmin utility.

Backup a specific database

postgres_db\bin\pg_dump -Fc servoy_repository > servoy_repository.dump

Restore dump into a newly created database

postgres_db\bin\pg_restore -d new_servoy_repository  servoy_repository.dump

Backup all databases

postgres_db\bin\pg_dumpall > db.out

Reload all database dump

postgres_db\bin\psql -f db.out postgres

Note that the examples above are very minimalistic. The utilities provided by PostgreSQL offer many options. Check the PostgreSQL documentation on pg_dump, pg_dumpall, pg_restore and pg_sql for detailed information.

The samples above assume execution from the ../application_server/ directory.

Scheduled backups

TODO

PostgreSQL Database Admin tool

...