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

Re: Large file support needed? Trying to identify root of error.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kris Kiger <kris(at)musicrebellion(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Large file support needed? Trying to identify root of error.
Date: 2004-07-19 20:00:21
Message-ID: 25097.1090267221@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Kris Kiger <kris(at)musicrebellion(dot)com> writes:
> I've got a database that is a single table with 5 integers, a timestamp 
> with time zone, and a boolean.  The table is 170 million rows in length. 
>  The contents of the tar'd dump file it produced using:
>     pg_dump -U postgres -Ft test > test_backup.tar
> is: 8.dat (approximately 8GB), a toc, and restore.sql.  

Try -Fc instead.  I have some recollection that tar format has a
hard-wired limit on the size of individual members.

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2004-07-19 20:06:53
Subject: Re: VACUUM ANALYZE and REINDEX
Previous:From: Kris KigerDate: 2004-07-19 19:28:48
Subject: Large file support needed? Trying to identify root of error.

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