Problems with pg_dumpall
Hi;
I'm using postgres7.3.4 and I have tried to use pg_dumpall to copya a
database from one computer to another. I remember I used it once with no
problem, but now I've found a lot of error.
I've run the restore as the "postgres" superuser, and it seem that when a
table exists previously, or a language or another element, this creates an
error.
Please. How could I resolve this? Perhaps should I DROP all tables previously
to the restoration?
Thanks, and best regards,
Javier
On 23/03/2004 09:23 javier garcia - CEBAS wrote:
Hi;
I'm using postgres7.3.4 and I have tried to use pg_dumpall to copya a
database from one computer to another. I remember I used it once with no
problem, but now I've found a lot of error.
pg_dumpall dumps all databases in a cluster. You want to use pg_dump
instead.
I've run the restore as the "postgres" superuser, and it seem that when a
table exists previously, or a language or another element, this creates
an
error.
Please. How could I resolve this? Perhaps should I DROP all tables
previously
to the restoration?
man pg_dump
look at the -c option.
HTH
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+