Re: [HACKERS] pg_dump, formats & blobs

2001-04-14 Thread Philip Warner
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| __---_ Albatr

Re: [HACKERS] pg_dump, formats & blobs

2001-04-13 Thread Mathijs Brands
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.

Re: [HACKERS] pg_dump, formats & blobs

2001-04-13 Thread Philip Warner
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

[HACKERS] pg_dump, formats & blobs

2001-04-13 Thread Mathijs Brands
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. Unfortunat