Re: [GENERAL] Problems with pg_dumpall

2004-03-23 Thread Paul Thomas
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 us

[GENERAL] Problems with pg_dumpall

2004-03-23 Thread javier garcia - CEBAS
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