backup/restore postgresql data functionality

Classic Servoy
1

Hi!

I need to perform a database backup and restore functionality. This can be from a client or in server. The client can choose manual or automatic via windows scheduler. When a user_id parameter is passed it will only backup table data for that user, otherwise backup the whole database. I was thinking if I can invoke pg_dump through servoy but I do not think it can accept parameter like user_id. So am left with calling loadRecords per table and manually creating the INSERT SQL script for the record and append it to my SQL file. Is there a quicker way to do it?

Ideas are very much welcome.

Thanks!

2

Hi,

You can give application.executeProgram() parameters. Look at the help/specs.

Regards,

3

lwjwillemsen:
Hi,

You can give application.executeProgram() parameters. Look at the help/specs.

Regards,

Thanks!

I did use executeProgram to call pg_dump. Can a client create a local windows scheduler the will call my backup method that is in the server?

Here is the requirement. Allow user to backup data manually or automatically(by creating a windows scheduler) and save it to the local computer.

Thanks and Regards,
Rogel