pg_dump/restore problems

From: Glen Brown <gkbrown22(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_dump/restore problems
Date: 2010-02-15 18:25:04
Message-ID: fb9f1c031002151025u52dd27c7w344d5c9e7a65748f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bob Lunney 2010-02-15 20:20:50 Re: AIX - Out of Memory
Previous Message Kenneth Marshall 2010-02-15 16:18:23 Re: AIX - Out of Memory