| From: | Mitesh51 <mit_bca1(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | WAL handling issue. |
| Date: | 2009-10-13 05:03:13 |
| Message-ID: | 25867218.post@talk.nabble.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2009-10-13 05:11:42 | Re: Nested transactions |
| Previous Message | Gaini Rajeshwar | 2009-10-13 04:59:41 | Are there only 4 weights in PostgreSQL fulltext search? |