Thread: file too large, segmentation fault
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
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
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