From: Bob Lunney <bob_lunney@yahoo.com>
To: pgsql-admin@postgresql.org, Glen Brown <gkbrown22@gmail.com>
Subject: Re: pg_dump/restore problems
Date: Tue, 26 Oct 2010 08:33:14 -0700 (PDT)
Message-ID: <336456.89598.qm@web39705.mail.mud.yahoo.com> (raw)
In-Reply-To: <fb9f1c031002151025u52dd27c7w344d5c9e7a65748f@mail.gmail.com>
Glen,
Did you drop the indexes prior to the restore? If not, try doing so and recreating the indexes afterwards. That will also speed up the data load.
Bob Lunney
--- On Mon, 2/15/10, Glen Brown <gkbrown22@gmail.com> wrote:
From: Glen Brown <gkbrown22@gmail.com>
Subject: [ADMIN] pg_dump/restore problems
To: pgsql-admin@postgresql.org
Date: Monday, February 15, 2010, 1:25 PM
I am not sure where I should post this but I am running into problems trying to restore a large table. I am running 8.4.1 on all servers. The table is about 25gb in size and most of that is toasted. It has about 2.5m records. 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. The table is not partitioned and has a few indexes on it. What can I do?
thanks
-glen
Glen Brown
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: bob_lunney@yahoo.com, gkbrown22@gmail.com
Subject: Re: pg_dump/restore problems
In-Reply-To: <336456.89598.qm@web39705.mail.mud.yahoo.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