X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id EA40D9F9B76 for ; Thu, 4 May 2006 12:53:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 76623-08 for ; Thu, 4 May 2006 12:53:18 -0300 (ADT) X-Greylist: delayed 00:06:39.037501 by SQLgrey- Received: from smtp103.plus.mail.re2.yahoo.com (smtp103.plus.mail.re2.yahoo.com [206.190.53.28]) by postgresql.org (Postfix) with SMTP id DD19A9F9AFD for ; Thu, 4 May 2006 12:53:16 -0300 (ADT) Received: (qmail 39753 invoked from network); 4 May 2006 15:46:36 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:Message-ID:Date:From:User-Agent:MIME-Version:To:CC:Subject:References:In-Reply-To:Content-Type; b=2Cfg7TwIvbJ38bTW8ZLGnzpNULf7AWB+aYlx4k0kvmCT5gjx11e8ZwMnoMNe9JLNf44DvKVu0pYQHGccYR8M6HagFW+8Zzuw1xHLtuYPNzO9EP1OAaBRBtc2U4mMY425sXB2dH2bRgQ6Hb6d784IsfW6iHLZ0pq7fzQnopuSKcw= ; Received: from unknown (HELO ?192.168.20.104?) (renneyt@68.81.191.20 with plain) by smtp103.plus.mail.re2.yahoo.com with SMTP; 4 May 2006 15:46:36 -0000 Message-ID: <445A21C7.1050905@yahoo.com> Date: Thu, 04 May 2006 11:46:15 -0400 From: "renneyt@yahoo.com" User-Agent: Thunderbird 1.5.0.2 (Windows/20060308) MIME-Version: 1.0 To: Jyry Kuukkanen CC: Rodrigo Sakai , pgsql-admin@postgresql.org Subject: Re: backup problem References: <000d01c66f8d$04650900$4700a8c0@TREEZANTHUS> In-Reply-To: Content-Type: multipart/alternative; boundary="------------040905060204060003000007" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/38 X-Sequence-Number: 21570 This is a multi-part message in MIME format. --------------040905060204060003000007 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Jyry Kuukkanen wrote: > On Thu, 4 May 2006, Rodrigo Sakai wrote: > > >> Hi, I'm trying to do a backup of a database that is larger then 4 GB. But it gets an error when the file size gets 1.2 GB! I think its an Operational System problem (linux)! So, I want to know if exists some solution to backup my database?? >> >> The command that I used was= >> >> pg_dump -U postgres -d dbdeveloper -a -v -D -f 'backup.sql' >> >> The operational system is linux with etx filesystem, and the version of postgres is 7.4!! >> > > > You can try: > > pg_dump -U postgres -d dbdeveloper -a -v -D |bzip2 -c >backup.sql.bz2 > > bzip2 compresses better than gzip. > > Restoration: > > bzcat backup.sql.bz2|psql - postgres -d dbdeveloper > > > Cheers, > I use the same but use the bzip2 '--best' parameter for best compression or is that the default? Also for the OP Rodrigo Sakai, have your tried Solaris 10 x86? It is a rock solid OS from Sun that I have used for 12 years - 6 of them with Postgres. The two have coexisted together without incident. It can be d/led for free at the Sun site. --------------040905060204060003000007 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Jyry Kuukkanen wrote:
On Thu, 4 May 2006, Rodrigo Sakai wrote:

  
  Hi, I'm trying to do a backup of a database that is larger then 4 GB. But it gets an error when the file size gets 1.2 GB! I think its an Operational System problem (linux)! So, I want to know if exists some solution to backup my database??

  The command that I used was=

  pg_dump -U postgres -d dbdeveloper -a -v -D -f 'backup.sql'

  The operational system is linux with etx filesystem, and the version of postgres is 7.4!!
    


You can try:

pg_dump -U postgres -d dbdeveloper -a -v -D |bzip2 -c >backup.sql.bz2

bzip2 compresses better than gzip.

Restoration:

bzcat backup.sql.bz2|psql - postgres -d dbdeveloper


Cheers,
  


I use the same but use the bzip2 '--best' parameter for best compression or is that the default? Also for the OP Rodrigo Sakai, have your tried Solaris 10 x86? It is a rock solid OS from Sun that I have used for 12 years - 6 of them with Postgres. The two have coexisted together without incident. It can be d/led for free at the Sun site.




--------------040905060204060003000007--