Thread: 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
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