WAL handling issue.

Поиск
Список
Период
Сортировка
От Mitesh51
Тема WAL handling issue.
Дата
Msg-id 25867218.post@talk.nabble.com
обсуждение исходный текст
Список 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.


В списке pgsql-general по дате отправления:

Предыдущее
От: Mitesh51
Дата:
Сообщение: Cannot start the postgres service
Следующее
От: Christophe Pettus
Дата:
Сообщение: Re: Are there only 4 weights in PostgreSQL fulltext search?