规划一张图备份、恢复脚本

//onemap数据备份
    pg_dump -h 127.0.0.1 -U postgres onemap > D:\onemap-230725.bak
    psql.exe -h 127.0.0.1 -U postgres -d onemap < D:\onemap-230725.bak
    
    //tddck调查库备份
    pg_dump -h 127.0.0.1 -U postgres tddck > D:\tddck-230725.bak
    psql.exe -h 127.0.0.1 -U postgres -d tddck < D:\tddck-230725.bak
    
    //tddjk登记库备份
    pg_dump -h 127.0.0.1 -U postgres tddjk > D:\tddjk-230725.bak
    psql.exe -h 127.0.0.1 -U postgres -d tddjk < D:\tddjk-230725.bak
    
    //tdlyxz2018土地利用现状2018备份
    pg_dump -h 127.0.0.1 -U postgres tdlyxz2018 > D:\tdlyxz2018-230725.bak
    psql.exe -h 127.0.0.1 -U postgres -d tdlyxz2018 < D:\tdlyxz2018-230725.bak
    
    tdlyxz2019土地利用现状2019备份
    pg_dump -h 127.0.0.1 -U postgres tdlyxz2019 > D:\tdlyxz2019-230725.bak
    psql.exe -h 127.0.0.1 -U postgres -d tdlyxz2019 < D:\tdlyxz2019-230725.bak
    
    tdlyxz2020土地利用现状2020备份
    pg_dump -h 127.0.0.1 -U postgres tdlyxz2020 > D:\tdlyxz2020-230725.bak
    psql.exe -h 127.0.0.1 -U postgres -d tdlyxz2020 < D:\tdlyxz2020-230725.bak
    
    tdlyxz2021土地利用现状2021备份
    pg_dump -h 127.0.0.1 -U postgres tdlyxz2021 > D:\tdlyxz2021-230725.bak
    psql.exe -h 127.0.0.1 -U postgres -d tdlyxz2021 < D:\tdlyxz2021-230725.bak
    
    wpbxfk部下发卫片
    pg_dump -h 127.0.0.1 -U postgres wpbxfk > D:\wpbxfk-230725.bak
    psql.exe -h 127.0.0.1 -U postgres -d wpbxfk < D:\wpbxfk-230725.bak
    
    wpsxfkwfyd省下发违法用地
    pg_dump -h 127.0.0.1 -U postgres wpsxfkwfyd > D:\wpsxfkwfyd-230725.bak
    psql.exe -h 127.0.0.1 -U postgres -d wpsxfkwfyd < D:\wpsxfkwfyd-230725.bak
    
    wpsxfkwfyh省下发违法用海
    pg_dump -h 127.0.0.1 -U postgres wpsxfkwfyh > D:\wpsxfkwfyh-230725.bak
    psql.exe -h 127.0.0.1 -U postgres -d wpsxfkwfyh < D:\wpsxfkwfyh-230725.bak
    
    wpsxfkwfyk省下发违法用矿
    pg_dump -h 127.0.0.1 -U postgres  wpsxfkwfyk > D:\wpsxfkwfyk-230725.bak
    psql.exe -h 127.0.0.1 -U postgres -d  wpsxfkwfyk < D:\wpsxfkwfyk-230725.bak

An's Blog

Navigation

Recent Posts

Friend Links