When I set archive_mode = on # allows archiving to be done # (change requires restart) archive_command = 'copy "%p" "C:\\archivedir\\%f"' # command to use to archive a logfile segment in postgres...WAL files are created. But I am not getting at which time they are moved to archive dir. I read in documentation that they are moved after certain number of files (6) are created in \PostgreSQL\8.4\data\pg_xlog\ What if I want to move them to archive dir once new file is created & not want to wait for the creation of 6 WAL files? Or I am wrong somewhere? -- View this message in context: http://www.nabble.com/WAL-handling-issue.-tp25867218p25867218.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
