From: | Kurt Roeckx <Q(at)ping(dot)be> |
---|---|
To: | Anjan Dave <adave(at)vantage(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org |
Subject: | Re: [PATCHES] file too large, segmentation fault |
Date: | 2003-11-28 18:43:18 |
Message-ID: | 20031128184318.GA29273@ping.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-patches |
On Sun, Nov 23, 2003 at 10:51:10PM -0500, Anjan Dave wrote:
> Hi All:
>
> I am trying to restore a database on a different machine (7.2.3 on Sol9 to 7.2.4 RH8), and i get the following error, that i haven't seen before:
>
> -bash-2.05b$ pg_restore -d access -Ft -a access.dump.tar
> pg_restore: [tar archiver] could not open TOC file for input: File too large
> Segmentation fault
> -bash-2.05b$
>
> -bash-2.05b$ ls -l
> total 2339148
> -rw-r--r-- 1 root root 2323785216 Nov 23 22:43 access.dump.tar
The problem is that your file is over 2 GB, your OS/libc has a
problem opening such big files (using fopen()).
Try cat access.dump.tar | pg_restore -d access -Ft -a
> I read somewhere that there's a patch for this:
> http://dbforums.com/arch/173/2003/1/675653
>
> Will this patch fix it? Where do i get it from and how do i apply it?
The patch only fixed that "segmentation fault", not the "File too
large".
Kurt
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-11-28 18:50:23 | Re: Misplaced modifier in Postgresql license |
Previous Message | Tom Lane | 2003-11-28 18:42:36 | Re: PGDUMP BLOB PROBLEM |
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2003-11-28 19:11:54 | pg_ctl |
Previous Message | Tom Lane | 2003-11-28 18:40:36 | Re: bug |