| From: | Pam Wampler <Pam_Wampler(at)taylorwhite(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | pg_xlog question |
| Date: | 2002-07-12 14:03:08 |
| Message-ID: | 2E4528861499D41199D200A0C9B15BC0017E308B@FRISTX |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Al Arduengo | 2002-07-12 14:33:30 | removing specific duplicates |
| Previous Message | Elsa LARREUR | 2002-07-12 12:27:36 | CREATE DB --> How create virgin db?? |