From: | "Evandro" <evandro(at)horizontenet(dot)com(dot)br> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Cc: | "Cristiano Reis Monteiro" <cristmon(at)ufba(dot)br> |
Subject: | Error trying to restore db with blobs |
Date: | 2002-02-14 12:56:12 |
Message-ID: | 009b01c1b556$fb512aa0$0d9ed6c8@evandro |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi everyone,
This is the command for dump I´m using:
pg_dump -Ft -b -o $DB | bzip2 > $ARQ
This is the command for restore:
pg_restore -h $SRV -vOd $DB -u $BUNZIPARQ
This error occurs both in 7.12 and 7.13 I didn´t tested in 7.2
I´m getting this error:
Archiver: ******** WARNING ********
Data restoration may fail since any defined triggers
can not be disabled (no superuser username specified).
This is only a problem for restoration into a database
with triggers already defined.
Creating <Init> Max OID
Archiver(db): Could not execute query. No result from backend.
any hint??
Thanks!
Atenciosamente,
Evandro Júnior
Analista de Sistemas
Desenvolvedor Web
http://www.horizontenet.com.br
From | Date | Subject | |
---|---|---|---|
Next Message | Erwin Ambrosch | 2002-02-14 13:27:22 | PRIMARY KEY and UNIQUE |
Previous Message | Bjoern Metzdorf | 2002-02-14 12:32:23 | Replication (sigh) |