PG_DUMP

tengo mi DB en Postgres llamada BITACORA:

hice la siguiente instruccion :

$ pg_dump bitacora > bitacora.pgdump

luego se creó el archivo "bitacora.pgdump"

Quise recuperar el archivo con:

$ cat bitacora.pgdump | psql bitacora

pero me salio errores :

bash-2.05b$ cat bitacora.pgdump | psql bitacora
You are now connected as new user postgres.
SET
ERROR: function plpgsql_call_handler already exists with same argument
types
ERROR: Language plpgsql already exists
ERROR: Relation 'model' already exists
ERROR: Relation 'usuario' already exists
ERROR: Relation 'actividad_usuario' already exists
NOTICE: CREATE TABLE will create implicit sequence 'evento_id_evento_seq'
for SERIAL column 'evento.id_evento'
ERROR: Relation 'evento_id_evento_seq' already exists
ERROR: Relation 'ocupaciones' already exists
ERROR: Relation 'cod_cias' already exists
ERROR: Relation 'areas' already exists
ERROR: Relation 'grados' already exists
ERROR: Relation 'status' already exists
ERROR: Relation 'opciones' already exists
ERROR: Relation 'estados' already exists
ERROR: function pl10 already exists with same argument types
ERROR: copy: line 1, Cannot insert a duplicate key into unique index
usuario_pkey
se perdió la sicronización con el servidor, reiniciando la conexión
owed
NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: constraint "rest7" already exists for relation "evento"
ERROR: ALTER TABLE / PRIMARY KEY multiple primary keys for table
'ocupaciones'
are not allowed
ERROR: ALTER TABLE / PRIMARY KEY multiple primary keys for table 'cod_cias'
are not allowed
ERROR: ALTER TABLE / PRIMARY KEY multiple primary keys for table 'areas'
are not allowed
ERROR: ALTER TABLE / PRIMARY KEY multiple primary keys for table 'grados'
are not allowed
ERROR: ALTER TABLE / PRIMARY KEY multiple primary keys for table 'status'
are not allowed
ERROR: ALTER TABLE / PRIMARY KEY multiple primary keys for table 'opciones'
are not allowed
ERROR: ALTER TABLE / PRIMARY KEY multiple primary keys for table 'estados'
are
not allowed
ERROR: CreateTrigger: trigger t10 already defined on relation evento
setval
--------
34
(1 row)

Espero me puedan ayudar. GRACIAS

_________________________________________________________________
Charla con tus amigos en línea mediante MSN Messenger:
http://messenger.latam.msn.com/