Обсуждение: pg_dump/restore problems
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
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
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:What is the platform? (I remember having problems with large file
> 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.
handling in PostgreSQL on Windows, back when I used Windows.)
Can you see where the space is going when this happens?
-Kevin
Glen Brown wrote: > I am using Ubuntu 8LTS on both systems. How can tell where the > space is going? Maybe someone has a more sophisticated way, but I'd be poking around with "du -shx" requests against the contents of various directories during the run. Maybe run "vmstat 1" in another shell, piping the results to a file. -Kevin
On Sat, Feb 20, 2010 at 6:59 PM, Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote: > Glen Brown wrote: > >> I am using Ubuntu 8LTS on both systems. How can tell where the >> space is going? > > Maybe someone has a more sophisticated way, but I'd be poking around > with "du -shx" requests against the contents of various directories > during the run. Maybe run "vmstat 1" in another shell, piping the > results to a file. Also look at iotop. Pretty sure it'll work on an up to date ubuntu 8.04 LTS.
| 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:
|