From: Glen Brown <gkbrown22@gmail.com>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_dump/restore problems
Date: Sat, 20 Feb 2010 12:41:28 -0800
Message-ID: <fb9f1c031002201241x70181771x95a73c1d212950a4@mail.gmail.com> (raw)
In-Reply-To: <4B7FCD1A020000250002F419@gw.wicourts.gov>
References: <4B7FCD1A020000250002F419@gw.wicourts.gov>
I am using Ubuntu 8LTS on both systems. How can tell where the space is
going?
thanks for the help
-glen
Glen Brown
On Sat, Feb 20, 2010 at 9:52 AM, Kevin Grittner <Kevin.Grittner@wicourts.gov
> wrote:
> 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
>
>
>
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: gkbrown22@gmail.com, Kevin.Grittner@wicourts.gov
Subject: Re: pg_dump/restore problems
In-Reply-To: <fb9f1c031002201241x70181771x95a73c1d212950a4@mail.gmail.com>
* 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