Обсуждение: pg_dump and blobs

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

"=?ISO-8859-13?Q?Ignas_=D0altis?=" <saltis.ignas@gmail.com> writes:
> How can I make dump without blobs?

Per the manual:

-b
--blobs

Include large objects in the dump. This is the default behavior except
when --schema, --table, or --schema-only is specified, so the -b switch
is only useful to add large objects to selective dumps.


            regards, tom lane