Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 1258E2E2F35 for ; Wed, 2 Jan 2008 11:53:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 09945-05-2 for ; Wed, 2 Jan 2008 11:53:33 -0400 (AST) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.191]) by postgresql.org (Postfix) with ESMTP id 19BAC2E2F27 for ; Wed, 2 Jan 2008 11:53:38 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id f5so335872nfh.23 for ; Wed, 02 Jan 2008 07:53:37 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=gS6jXaL4nhKOWib2WKYhzIifIyV1TlNDtpFBtHF/ihQ=; b=km+Q8nBKixrq7xz3Y2Nf77Wxw/mlTQoc4JSaBYdsRAl4bBlXikiKFwO3Znx1AD9pBH0Lk9XC6j7qGY8Omb7fXQzKNX8ggRr66M6+w6pZU+4ctOibJgRTHNg5Oeo1/mhFrvDzhkDRtqJaVCGE7eLVRns7m9IHNDxyF0RaHjvVW68= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=hS/neRtAuBQv6pjXi+Sv2+yhznJX7itrEBE8kqh4dSBbtjPFOVDYNDZVoychGLgvV8nzysXrKz7U3F6p1dLGXqygqjoZ8AO+jgVkHcRLiLXLhRI/4BSZi/xFlQO+l91nScqDaXW52F4kF/HGlNqpY8356LQXkz6e06DC58KjWOw= Received: by 10.78.21.7 with SMTP id 7mr16771912huu.5.1199289216482; Wed, 02 Jan 2008 07:53:36 -0800 (PST) Received: by 10.78.32.4 with HTTP; Wed, 2 Jan 2008 07:53:36 -0800 (PST) Message-ID: <3fa710c50801020753h46fb0473rfe5d7c270cf9f5d9@mail.gmail.com> Date: Wed, 2 Jan 2008 17:53:36 +0200 From: "=?ISO-8859-13?Q?Ignas_=D0altis?=" To: pgsql-admin@postgresql.org Subject: pg_dump and blobs MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_21130_16496047.1199289216473" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/16 X-Sequence-Number: 27790 ------=_Part_21130_16496047.1199289216473 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hello, I have upgraded from postgreSQL version 7.3.6 to 8.2.4 few days ago. Everything works perfectly, but I have strange problem with backup. My database contains blob's, but i was not doing backup with blobs every day. I am doing daily backup with command : pg_dump -U user_name database_name > filename it was making backup without blobs, but now it includes blobs to the backup and I get huge file. How can I make dump without blobs? Thanks in advance. Ignas ------=_Part_21130_16496047.1199289216473 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hello,

I have upgraded from postgreSQL version 7.3.6 to 8.2.4 few days ago. Everything works perfectly, but I have strange problem with backup.

My database contains blob's, but i was not doing backup with blobs every day. I am doing daily backup with command : pg_dump -U user_name database_name > filename

it was making backup without blobs, but now it includes blobs to the backup and I get huge file.

How can I make dump without blobs?

Thanks in advance.

Ignas
------=_Part_21130_16496047.1199289216473--