postgresql启用归档
来源:互联网 发布:淘宝红包口令在哪里 编辑:程序博客网 时间:2024/04/29 08:34
To enable WAL archiving, set the wal_level configuration parameter to archive or higher, archive_mode to on, and specify the shell command to use in the archive_command configuration parameter. In practice these settings will always be placed in the postgresql.conf file. In archive_command, %p is replaced by the path name of the file to archive, while %f is replaced by only the file name. (The path name is relative to the current working directory, i.e., the cluster's data directory.) Use %% if you need to embed an actual % character in the command. The simplest useful command is something like:
archive_command = 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/server/archivedir/%f' # Unix
archive_command = 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/server/archivedir/%f' # Unix
archive_command = 'copy "%p" "C:\\server\\archivedir\\%f"' # Windows
0 0
- postgresql启用归档
- Oracle启用归档模式
- RAC启用归档日志
- postgresql归档设置
- postgresql归档备份
- Postgresql 归档失败
- postgreSQL 启用远程访问
- postgresql启用日志记录
- 启用oracle自动归档模式
- 启用oracle自动归档模式
- oracle rac启用归档模式
- 启用远程用户访问PostgreSQL
- RAC启用归档步骤(10g)
- oracle查看是否启用归档日志
- postgresql连续归档及时间点恢复
- 如何启用或关闭数据库的归档(archivelog)模式
- SAP支持宝典:#MM#如何在归档后启用归档信息系统
- PostgreSQL备份恢复二:WAL归档--windows
- BZOJ-1901 Zju2112 Dynamic Rankings 函数式线段树 套 树状数组+离线处理
- poj1029 2010.4.14
- Ceph命令之ceph mon(Monitor管理)
- poj1112 2010.4.15
- City Game
- postgresql启用归档
- poj1143 2010.4.15
- 明锐共振 明显 解决方法
- iOS越狱插件编写 - 支付宝自动咻咻 (一)
- poj1160 2010.4.15
- em操作命令
- zoj1503 2010.7.28
- 登录窗体构件
- N皇后