环境: windows sever 2003 , postgresql 8.4
在PostgreSQL的安装目录下找到postgresql.conf文件,将其中的archive_mode , archive_command 修改为如下:
# - Archiving -
archive_mode = on # allows archiving to be done
# (change requires restart)
archive_command = 'copy "%p" D:\\program\\postgresql_archivedlog\\"%f"' # command to use to archive a logfile segment
archive_timeout = 600 # force a logfile segment switch after this
# number of seconds; 0 disables
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16582684/viewspace-622519/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16582684/viewspace-622519/