pg_dump's over 2GB

From: "Bryan White" <bryan(at)arcamax(dot)com>
To: "pgsql-general" <pgsql-general(at)postgreSQL(dot)org>
Subject: pg_dump's over 2GB
Date: 2000-09-29 16:15:26
Message-ID: 00d501c02a30$7a61cb00$2dd260d1@arcamax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

My current backups made with pg_dump are currently 1.3GB. I am wondering
what kind of headaches I will have to deal with once they exceed 2GB.

What will happen with pg_dump on a Linux 2.2.14 i386 kernel when the output
exceeds 2GB?
Currently the dump file is later fed to a 'tar cvfz'. I am thinking that
instead I will need to pipe pg_dumps output into gzip thus avoiding the
creation of a file of that size.

Does anyone have experince with this sort of thing?

Bryan White, ArcaMax.com, VP of Technology
You can't deny that it is not impossible, can you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Wolfe 2000-09-29 16:34:01 Re: pg_dump's over 2GB
Previous Message bmccoy 2000-09-29 16:14:53 Re: Redhat 7 and PgSQL