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 <gkbrow...@gmail.com> wrote:
From: Glen Brown <gkbrow...@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
