postgresql数据库的备份和还原

  1. 将文件备份还原
    C:\Program Files\PostgreSQL\9.0\bin>pg_dump -U postgres -h localhost -p 5432 tlcdata> output_file.sql

    C:\Program Files\PostgreSQL\16\bin>psql -U postgres -h localhost -p 5432 -d tlcdata -f output_file.sql

     

  2. 包含角色 -C
    C:\Program Files\PostgreSQL\9.0\bin>pg_dump -U postgres -h localhost -p 5432 -C tlcdata > output_file1.sql

    C:\Program Files\PostgreSQL\16\bin>psql -U postgres -h localhost -p 5432 -d tlcdata -f output_file1.sql

     

  3. 整个集 
    C:\Program Files\PostgreSQL\9.0\bin>pg_dumpall -U postgres -h localhost -p 5432 -f cluster_dump.sql

C:\Program Files\PostgreSQL\16\bin>psql -U postgres -h localhost -p 5432 -f cluster_dump.sql

     

posted @ 2024-03-01 15:04  elegydance  阅读(56)  评论(0)  编辑  收藏  举报