Re: pg_dump/restore problems

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <gkbrown22(at)gmail(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_dump/restore problems
Date: 2010-02-20 17:52:58
Message-ID: 4B7FCD1A020000250002F419@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Glen Brown wrote:

> When I dump this table using pg_dump -Fc it creates a 15 gb file. I
> am trying to restore in into a database that has 100gb of free disk
> space and it consumes it all and fails to finish the restore.

What is the platform? (I remember having problems with large file
handling in PostgreSQL on Windows, back when I used Windows.)

Can you see where the space is going when this happens?

-Kevin

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2010-02-20 17:53:37 Re: Backups
Previous Message Kevin Grittner 2010-02-20 17:44:27 Re: Backups