Pam Wampler wrote: > Being fairly new to postgresql, I have a couple of questions on pg_xlog > We are on 7.2.1 > > 1. How does one properly administer the pg_xlogs? -- How long to retain > them? > Is it ok to delete them after a period of time? If so, what period of > time?
It is auto-cleaned up. > 2. I understand that the numbering scheme does not wrap around -- is there > a way > to set the numbering scheme back to 1? we are still in testing mode, > and our > xlogs are up to: > -rw------- 1 pgsql pgsql 16777216 Jun 12 17:03 0000000900000097 > -rw------- 1 pgsql pgsql 16777216 Jun 12 16:57 0000000900000098 > -rw------- 1 pgsql pgsql 16777216 Jun 12 16:56 0000000900000099 > -rw------- 1 pgsql pgsql 16777216 Jun 12 16:56 000000090000009A > -rw------- 1 pgsql pgsql 16777216 Jun 12 16:58 000000090000009B > -rw------- 1 pgsql pgsql 16777216 Jun 12 16:57 000000090000009C > -rw------- 1 pgsql pgsql 16777216 Jun 12 16:57 000000090000009D Don't worry about it. An initdb will reset it, as I remember. > 3. There is normally only 7 of these logs on our system -- so I am assuming > that > "something" is deleteing them -- Is there an option to "not" delete > them, until > I want to delete them. Why? > If there is more documentation somewhere on these questions, please point me > there. You have read the official documentation on the WAL system? -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
