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 |
+------------------------------+---------------------------------------------+
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
