Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id BEC439FBEDC; Thu, 8 Mar 2007 16:02:13 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 54949-04; Thu, 8 Mar 2007 16:02:10 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from fmf.vtu.lt (fmf.vtu.lt [193.219.145.206]) by postgresql.org (Postfix) with ESMTP id 2B78D9FBEDA; Thu, 8 Mar 2007 16:02:10 -0400 (AST) Received: from fmf.vtu.lt (localhost [127.0.0.1]) by fmf.vtu.lt (Postfix) with ESMTP id 959D81802A; Thu, 8 Mar 2007 22:02:07 +0200 (EET) Received: from 85.206.198.223 (SquirrelMail authenticated user nso) by fmf.vtu.lt with HTTP; Thu, 8 Mar 2007 22:02:07 +0200 (EET) Message-ID: <53561.85.206.198.223.1173384127.squirrel@fmf.vtu.lt> Date: Thu, 8 Mar 2007 22:02:07 +0200 (EET) Subject: Pg_dump and bytaA From: "Lukas" To: pgsql-novice@postgresql.org Cc: pgsql-admin@postgresql.org User-Agent: SquirrelMail/1.4.8 MIME-Version: 1.0 Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-VGTU-MailScanner-OpenProtect-Information: Please contact the ISP for more information X-VGTU-MailScanner-OpenProtect: Found to be clean X-MailScanner-OpenProtect-MCPCheck: X-MailScanner-OpenProtect-From: lukas@fmf.vtu.lt X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.909 tagged_above=0 required=5 tests=AWL, BAYES_50 X-Spam-Level: X-Archive-Number: 200703/27 X-Sequence-Number: 24851 Hello, we have one table in database (db has over 200 tables), which has one byteA filed for storing user photos. We are making backup every night, but it is now too large because of photos. We do not need to make backup of photos every night, but the question is how to backup database without this field? I tried to look at keys of pgdump, but found nothing... Now we are using it like this: pg_dump -f /home/backup/DB.sql -d -Fp -v DB thx Lukas -- This message has been scanned for viruses and dangerous content, and is believed to be clean.