Error trying to restore db with blobs

Поиск
Список
Период
Сортировка
От Evandro
Тема Error trying to restore db with blobs
Дата
Msg-id 009b01c1b556$fb512aa0$0d9ed6c8@evandro
обсуждение исходный текст
Ответы Re: Error trying to restore db with blobs
Список 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




В списке pgsql-general по дате отправления:

Предыдущее
От: Holger Marzen
Дата:
Сообщение: Re: pgaccess failed, used to work
Следующее
От: "Bjoern Metzdorf"
Дата:
Сообщение: Replication (sigh)