Pam Wampler <Pam_Wampler@taylorwhite.com> writes:
> 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)
It's basically 2 * checkpoint_segments + 1. See
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/wal-configuration.html
> 2. What happens when the files increment and can no longer increment to a
> higher number (the file name)?
Trouble, which is why we use a 64-bit counter.
> 3. Is there a way to "reset" the number so that this won't happen?
initdb. However, you're not gonna have to worry about it in your
lifetime. Do the math...
regards, tom lane
