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
pgsql-admin by date
|Next:||From: Scott Marlowe||Date: 2004-07-19 20:06:53|
|Subject: Re: VACUUM ANALYZE and REINDEX|
|Previous:||From: Kris Kiger||Date: 2004-07-19 19:28:48|
|Subject: Large file support needed? Trying to identify root of error.|