Re: pg_restore returns always error if backup is greater than 2 GB

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrus Moor" <kobruleht2(at)hot(dot)ee>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_restore returns always error if backup is greater than 2 GB
Date: 2009-08-19 18:09:59
Message-ID: 26127.1250705399@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Andrus Moor" <kobruleht2(at)hot(dot)ee> writes:
> I noticed that backups created by pg_dump are not usable if backup file size
> is greater than 2 GB.

> Backups are create in 8.1

This is a known bug that was fixed more than two years ago ... but not
in 8.1, which was already considered unsupportable on Windows at the
time. You *really* need to get off of 8.1.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2009-08-19 18:31:17 Re: Unit conversion database (was: multiple paramters in aggregate function)
Previous Message Scott Marlowe 2009-08-19 17:57:45 Re: Postgre RAISE NOTICE and PHP