Re: Problem do backup/restore for empty database

> >I tried to do backup/restore of empty database.
> >And get the following error:
> >
> >Archiver(db): Could not execute query. Code = 7. Explanation from backend:
> >'ERROR: OperatorDef: operator "=" already defined
> >'.
> >
> >Another funny thing is that dump of empty database occupies 657614 bytes.
> >It is quite much...
>
> Works fine for me. What command are you using? What does

pg_dump --blob -Fc test3 -f test3.tar -v
pg_restore test3.tar --db=test4 -v

> pg_restore archive-file-name

pg_restore test3.tar produces 688634 bytes length.

pg_restore -l test3.tar produces long list. Here there are some first lines:

;
; Archive created at Sat Oct 21 18:05:33 2000
; dbname: test3
; TOC Entries: 2899
; Compression: -1
; Dump Version: 1.4-17
; Format: CUSTOM
;
;
; Selected TOC Entries:
;
2338; 15 OPERATOR = postgres

> produce?
>
> Have you done anything nasty to template1?

Just initdb.

--
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp(at)perchine(dot)com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------