postgresql 备份恢复(一)

备 份恢复对于每个数据来说都是非常重要的。一般的数据库都支持冷备份的方式，冷备份可以保证数据库在此刻的完整性。但是其缺点也非常的明显，为保持数据一致 性。冷备份期间数据库中相关数据是不能够使用的，就大大影响的系统的可用性。不管怎样冷备份在很多的情况下还是很有用的。

数据库的冷备份一般支持两种方式：

1,操作系统级别的命令备份(cp,copy)

2,数据库工具备份(pg_dump)

针对postgresql数据库的pg_dump工具进行了一下测试(还碰到一个小问题)。

pg_dump工具命令与参数的参考：

 

代码

   
   
   

    
    
    pg_dump dumps a database as a text file or to other formats.



Usage:

  pg_dump [OPTION]... [DBNAME]



General options:

  -f, --file=FILENAME      output file name

  -F, --format=c|t|p       output file format (custom, tar, plain text)

  -i, --ignore-version     proceed even when server version mismatches

                           pg_dump version

  -v, --verbose            verbose mode

  -Z, --compress=0-9       compression level for compressed formats

  --help                   show this help, then exit

  --version                output version information, then exit



Options controlling the output content:

  -a, --data-only             dump only the data, not the schema

  -b, --blobs                 include large objects in dump

  -c, --clean                 clean (drop) schema prior to create

  -C, --create                include commands to create database in dump

  -d, --inserts               dump data as INSERT commands, rather than COPY

  -D, --column-inserts        dump data as INSERT commands with column names

  -E, --encoding=ENCODING     dump the data in encoding ENCODING

  -n, --schema=SCHEMA         dump the named schema(s) only

  -N, --exclude-schema=SCHEMA do NOT dump the named schema(s)

  -o, --oids                  include OIDs in dump

  -O, --no-owner              skip restoration of object ownership

                              in plain text format