Skip site navigation (1) Skip section navigation (2)

BUG #2645: pg_restore crashes

From: "Thomas Verchow" <thomas(at)verchow(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2645: pg_restore crashes
Date: 2006-09-22 18:13:51
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2645
Logged by:          Thomas Verchow
Email address:      thomas(at)verchow(dot)de
PostgreSQL version: 8.1.4
Operating system:   GNU/Linux, Debian sarge
Description:        pg_restore crashes

pg_restore ends with ,,Segmentation fault'' or ,,out of memory'' while
trying to restore a large custom-archive-backup (~ 30 GB).

If i choose a table, witch is at the beginning of the backup (according to
pg_restore --list), it works fine.

With smalltable, at the end of the archive, it
ends with a SegFault. So does the same with a big table.
(pg_restore --table=smalltable backup > out.sql)

The Error ,,out of memory'' appears during a restore into the db (using

It seems, that pg_restore can't read data behind a limit (2 GB, 8 GB?).

I piped pg_restore through gzip. After a filesize of ~ 7 GB pg_restore
crashes with ,,out of memory''. If the custom archive has the same
compression level, the assumtion for a 8 GB restriction seems to be valid.

This is bad, because you can't use pg_dump & pg_restore for bigger dbs :(


pgsql-bugs by date

Next:From: Tom LaneDate: 2006-09-22 18:19:18
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale
Previous:From: Douglas ToltzmanDate: 2006-09-22 17:55:14
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group