Original Message -From: "RPK" <[EMAIL PROTECTED]>

I want to perform database backup (pgdump) from within VB.NET. Can it be
done?

I have an application developed using VB.NET that backs up the database every 12 hours using a small batch file containing both a vacuum and pg_dump backup script. I execute the batch file using the SHELL function (Microsoft.VisualBasic namespace). In my case I run the command in a separate thread in the background. I also provide the user with the ability to initiate this backup process via the menu system so that they can make a backup at any time (e.g. thunder storm approaching...).

I timestamp the backup file name, and have the process keep only the last three backups - deleting the oldest backup each time a backup is successfully completed.

HTH.

Regards,
George


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to