Обсуждение: Restore after pg_dumpall

Поиск
Список
Период
Сортировка

Restore after pg_dumpall

От
Asmus Reinhard
Дата:

>pg_dumpall > alldb.sql (store)

>and

>psql -f alldb.sql postgres (restore)

>is it necessary to drop existing objects (for example roles, ...) ?

>Any help is appreciated.

 

Last days i’m looking tot he options of pg_dumpall and I think the answer of my question is using option –c.

 

Using this option pg_dumpall generates at first drop commands for existing objects …