pg_xlog question
От | Pam Wampler |
---|---|
Тема | pg_xlog question |
Дата | |
Msg-id | 2E4528861499D41199D200A0C9B15BC0017E308B@FRISTX обсуждение исходный текст |
Ответы |
Re: pg_xlog question
|
Список | pgsql-novice |
Questions on pg_xlog: 1. what parameter tells postgress to always keep 7 files in the pg_xlog directory? (see below) --this is test database we are learning on. (and it seems everytime that I look at this directory there are always 7 entries there) 2. What happens when the files increment and can no longer increment to a higher number (the file name)? 3. Is there a way to "reset" the number so that this won't happen? total 114800 -rw------- 1 pgsql pgsql 16777216 May 6 19:07 00000009000000CC -rw------- 1 pgsql pgsql 16777216 May 6 19:08 00000009000000CD -rw------- 1 pgsql pgsql 16777216 May 6 19:09 00000009000000CE -rw------- 1 pgsql pgsql 16777216 May 7 08:23 00000009000000CF -rw------- 1 pgsql pgsql 16777216 May 7 08:25 00000009000000D0 -rw------- 1 pgsql pgsql 16777216 May 22 10:32 00000009000000D1 -rw------- 1 pgsql pgsql 16777216 Jul 9 16:23 00000009000000CB $ pwd /usr/local/pgsql/data/pg_xlog $ Thank you Pam Wampler
В списке pgsql-novice по дате отправления: