Re: Problems with pg_dumpall
От | Paul Thomas |
---|---|
Тема | Re: Problems with pg_dumpall |
Дата | |
Msg-id | 20040323094814.A25198@bacon обсуждение исходный текст |
Ответ на | Problems with pg_dumpall (javier garcia - CEBAS <rn001@cebas.csic.es>) |
Список | pgsql-general |
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 | +------------------------------+---------------------------------------------+
В списке pgsql-general по дате отправления: