Re: [GENERAL] PG_RESTORE and database size

2006-01-27 Thread Tom Lane
"Marcus Couto" <[EMAIL PROTECTED]> writes: > Here's a basic question. On working with backing up and restoring it = > seems like if I keep on doing it in a row, the backup file size keeps on = > increasing in size. It almost doubles in size for every backup/restore. = > I want the restore the backu

Re: [GENERAL] PG_RESTORE and database size

2006-01-27 Thread Richard Huxton
Marcus Couto wrote: Here's a basic question. On working with backing up and restoring it seems like if I keep on doing it in a row, the backup file size keeps on increasing in size. It almost doubles in size for every backup/restore. I want the restore the backup to overwrite the database and not

[GENERAL] PG_RESTORE and database size

2006-01-27 Thread Marcus Couto
Here's a basic question. On working with backing up and restoring it seems like if I keep on doing it in a row, the backup file size keeps on increasing in size. It almost doubles in size for every backup/restore. I want the restore the backup to overwrite the database and not add to it. Is