pg_dump and blobs - Mailing list pgsql-admin

From Ignas Šaltis
Subject pg_dump and blobs
Date
Msg-id 3fa710c50801020753h46fb0473rfe5d7c270cf9f5d9@mail.gmail.com
Whole thread Raw
Responses Re: pg_dump and blobs  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Tino Schwarze
Date:
Subject: Re: Performance tuning...
Next
From: Tom Lane
Date:
Subject: Re: Shutting down warm standby server? "