girish R G peetle wrote: > After executing pg_start_backup, we will generate a file 'Backup file' which will contain list of all > the folders n files under DATA directory. > > Then we read entry from 'Backup file' sequentially and use copy command/script to move it to backup > media. > > When network encounters copy script will fail stating couldn't backup the file. > > Say copy command throws error at 20th file entry. When backup is resumed copy command resumes from > 20th file entry. That should work just fine. I'd still test the result by restoring such a backup and running "pg_dump -f /dev/null" on it, just to be sure and because you cannot test your backups often enough. Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin