Re: Performing backup from VB.NET

Original Message -From: "RPK" <rohitprakash123(at)indiatimes(dot)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