Postgres Pro
Downloads
Home   >   mailing lists

Thread: file too large, segmentation fault

file too large, segmentation fault

From
"Anjan Dave"
Date:
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,
thati 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 only thing i did different in this restore is that i had created two groups in the template1 because the schema
neededit and the pg_dump of the schema would not do it..so i used pg_dumpall.
 
 
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?
 
 
Thanks in advance,
 
anjan

Re: [PATCHES] file too large, segmentation fault

From
Kurt Roeckx
Date:
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,
thati 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

Re: [PATCHES] file too large, segmentation fault

From
"Joshua D. Drake"
Date:
Hello,

   Did the dump come from those machines? If so, it is probably not a valid
 archive anyway because you hit the 2gig limit. My suggestion would be to
recompile PostgreSQL with the 64bit file access.

Sincerely,

Joshua D. Drake

Kurt Roeckx wrote:

>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,
thati 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
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL