Re: [ADMIN] Postgres Backup Questions

2006-06-03 Thread Kenneth Marshall
John, We accomplished this using an inline filter to capture the checksum and size for the entire dump to tape. Then we re-read the tape to see if the tape generated the same checksum and size. That is probably about a good as you are going to get. Ken On Thu, Jun 01, 2006 at 01:57:07PM -0400, J

Re: [ADMIN] Postgres Backup Questions

2006-06-01 Thread John R. Allgood
Hey That sounds like what I would need to do. Could you provide a few more details about how this was accomplished. Thanks John Allgood - ESC Kenneth Marshall wrote: John, We accomplished this using an inline filter to capture the checksum and size for the entire dump to tape. Then we re

Re: [ADMIN] Postgres Backup Questions

2006-06-01 Thread John R. Allgood
Hey Again Thanks for the input. but what I am wanting to check for is CRC errors and block errors. The backups are written to tape and I would like a way to verify the data on the tape as compared to the data on the server. I may be way off here but I just want to be sure I am getting reli

Re: [ADMIN] Postgres Backup Questions

2006-06-01 Thread Scott Marlowe
On Thu, 2006-06-01 at 10:15, John R. Allgood wrote: > Hello > > I have a question regarding backups on Postgresql 7.4.7-2. We are > currently using a Progress database and will be moving over to Postgres > this month. In Progress there is a way to verify your backups does > Postgres have an