Original Message -From: "RPK" <rohitprakash123@indiatimes.com>
> 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