pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: gkbrown22@gmail.com
To: pgsql-admin@postgresql.org
Subject: Re: pg_dump/restore problems
Date: Sat, 20 Feb 2010 11:52:58 -0600
Message-ID: <4B7FCD1A020000250002F419@gw.wicourts.gov> (raw)

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





view thread (6+ messages)  latest in thread

Message-ID: <4B7FCD1A020000250002F419@gw.wicourts.gov>
Permalink:  ../4B7FCD1A020000250002F419@gw.wicourts.gov/
Also on:    postgresql.org/message-id/4B7FCD1A020000250002F419@gw.wicourts.gov

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: Kevin.Grittner@wicourts.gov, gkbrown22@gmail.com
  Subject: Re: pg_dump/restore problems
  In-Reply-To: <4B7FCD1A020000250002F419@gw.wicourts.gov>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox