Why doesn't pg_dump include blob by default? I understand that older
pg_dump didn't deal with blobs, and blobs are now kind of obsolete in
favor of BYTEA/TEXT, but blobs are every bit a part of a database.
Perhaps only exclude blobs when -t is specified? Then -b is required to
include blob.
At 04:10 14/04/01 +0200, Mathijs Brands wrote:
Sorry about the false alarm. I was convinced restoring blobs
didn't work correctly.
The tar problem is now fixed in CVS.
Philip Warner| __---_
Albatross
Hi
I've been experimenting with 7.1rc4 for a couple of hours. I was messing with
blobs, and the new toast setup worked quite nicely. One thing I especially
liked was the fact that by having pg_dump create a dumpfile in the custom or
tar format, I could also backup all blobs in one go.
At 01:14 14/04/01 +0200, Mathijs Brands wrote:
...
sol2:~$ pg_dump -b -Fc -f blaat.bk blaat
sol2:~$ pg_restore -l blaat.bk
...
;
; Archive created at Sat Apr 14 01:03:02 2001
...
This all looks fine.
sol2:~$ pg_dump -b -Ft -f blaat.tar blaat
zsh: segmentation fault (core dumped) pg_dump -b
On Sat, Apr 14, 2001 at 11:44:18AM +1000, Philip Warner allegedly wrote:
At 01:14 14/04/01 +0200, Mathijs Brands wrote:
...
sol2:~$ pg_dump -b -Fc -f blaat.bk blaat
sol2:~$ pg_restore -l blaat.bk
...
;
; Archive created at Sat Apr 14 01:03:02 2001
...
This all looks fine.
Hmm, I can