| From: | Diogo Biazus <diogo(at)ikono(dot)com(dot)br> |
|---|---|
| To: | PgSQL General ML <pgsql-general(at)postgresql(dot)org> |
| Subject: | Problems with pg_restore |
| Date: | 2003-08-12 08:32:39 |
| Message-ID: | 3F38A627.3020205@ikono.com.br |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi everybody,
I'm having a problem while trying to recover a database with pg_restore.
I'm using the command:
pg_restore -Fc -U ikono -d sistemalivros -v pgdump_sistemalivros
and it terminates abnormaly with the message:
pg_restore: restoring data for table editoras
pg_restore: restoring data for table itensagente
pg_restore: [archiver (db)] error returned by PQputline
pg_restore: *** aborted because of error
the PgSQL version is 7.3.3 running on a FreeBSD 4.8
Is there any way to recover or to fix the backup file?
Could anybody help me?
Thanks in advance.
--
Diogo Biazus
diogo(at)ikono(dot)com(dot)br
http://www.ikono.com.br
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2003-08-12 08:35:25 | Re: Help! Can't pg_dump anything: handler procedure for procedural language plpgsql not found |
| Previous Message | Ron Johnson | 2003-08-12 08:08:44 | Re: types of constraint deferment |