Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 6BCEC9FBAD1 for ; Fri, 9 Mar 2007 04:05:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 12228-06 for ; Fri, 9 Mar 2007 04:05:26 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from matrix.gatewaynet.com (host2.dynacom.ondsl.gr [62.103.35.210]) by postgresql.org (Postfix) with ESMTP id D14199FA197 for ; Fri, 9 Mar 2007 04:05:27 -0400 (AST) Received: from host3.dynacom.ondsl.gr ([62.103.35.211] helo=ip216.internal.net) by matrix.gatewaynet.com with esmtp (Exim 4.62) (envelope-from ) id 1HPa6P-0007HZ-08 for pgsql-admin@postgresql.org; Fri, 09 Mar 2007 10:05:25 +0200 From: Achilleas Mantzios Organization: Dynacom Tankers Mgmt To: pgsql-admin@postgresql.org Subject: Re: Pg_dump and bytaA Date: Fri, 9 Mar 2007 10:05:24 +0200 User-Agent: KMail/1.9.3 References: <53561.85.206.198.223.1173384127.squirrel@fmf.vtu.lt> In-Reply-To: <53561.85.206.198.223.1173384127.squirrel@fmf.vtu.lt> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200703091005.24820.achill@matrix.gatewaynet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.173 tagged_above=0 required=5 tests=AWL, BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200703/31 X-Sequence-Number: 24855 =CE=A3=CF=84=CE=B9=CF=82 =CE=A0=CE=AD=CE=BC=CF=80=CF=84=CE=B7 08 =CE=9C=CE= =AC=CF=81=CF=84=CE=B9=CE=BF=CF=82 2007 22:02, =CE=BF/=CE=B7 Lukas =CE=AD=CE= =B3=CF=81=CE=B1=CF=88=CE=B5: > 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... This isnt directly possible. You could have a mirror of the database, and nullify these bytea columns in the mirror db before=20 taking the dump of this mirror db. > > Now we are using it like this: > pg_dump -f /home/backup/DB.sql -d -Fp -v DB > > thx > Lukas =2D-=20 Achilleas Mantzios