Re: Dump and Restore
От | Paul Thomas |
---|---|
Тема | Re: Dump and Restore |
Дата | |
Msg-id | 20040824162956.D17786@bacon обсуждение исходный текст |
Ответ на | Dump and Restore ("Eduardo S. Fontanetti" <dufuzzy@yahoo.com.br>) |
Ответы |
Re: [ADMIN] Dump and Restore
Re: Dump and Restore |
Список | pgsql-general |
On 24/08/2004 14:40 Eduardo S. Fontanetti wrote: > How can I do a test if my dumping is really working, I > can't apply the dump in my database, because it will > overwrite a lot of data. I was thinking about restore > in another database name, but I can't, it always > restore on the original database. > > Somebody have a cooking recipe about to test if my > backup is working fine, and will help if I need > sometime? Are you using pg_dump or pg_dumpall? I just use pg_dump on individual databases (pg_dumpall works on the whole cluster) and can restore that to any database. HTH -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+
В списке pgsql-general по дате отправления: