Instance-level Import and Export
gs_dumpall can be used to logically back up database instances and export data of all databases in an instance, including data in the default database, data in user-defined databases, and definitions of global objects shared by all databases.
For details about how to use the gs_dumpall tool, see "Data Import and Export Tools > gs_dumpall for Exporting All Database Information" in Tool Reference.

- gs_dumpall does not back up parameters for running databases.
- gs_dumpall supports only plain-text format export. Therefore, only gsql can be used to restore a file exported using gs_dumpall.
- After restoration, you are advised to run ANALYZE on each database to provide useful statistics for the optimizer.
nohup gs_dumpall -U root -W ******** -f /data/backup/bkp2.sql -p 8000 > /data/backup/dumpall_backup.log &
nohup gsql -d postgres -p 8000 -U root -W ******** -f /data/backup/bkp2.sql -a > /data/backup/dumpall_restore.log &
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot