Restore after pg_dumpall

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>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 …


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux