Re: PG_RESTORE and database size - Mailing list pgsql-general

From Richard Huxton
Subject Re: PG_RESTORE and database size
Date
Msg-id 43DA29A9.1050402@archonet.com
Whole thread Raw
In response to PG_RESTORE and database size  ("Marcus Couto" <marcus_couto@hotmail.com>)
List pgsql-general
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 add to it. Is there another procedure I'm missing or
> a parameter I'm not using right with pg_restore and pg_dump?

If I were to ask you about vacuum-ing would you know what I was talking
about? If not, check the manuals and read up on the topic.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "John D. Burger"
Date:
Subject: Re: Finding missing records
Next
From: Alexander Presber
Date:
Subject: Re: TSearch2 / German compound words / UTF-8