From: Alvaro Herrera <alvherre@commandprompt.com>
To: Tena Sakai <tsakai@gallo.ucsf.edu>
Cc: Marcelo Martins <pglists@zeroaccess.org>
Cc: jeff@frostconsultingllc.com
Cc: pgsql-admin@postgresql.org
Subject: Re: restoring from dump
Date: Mon, 25 Aug 2008 22:34:06 -0400
Message-ID: <20080826023406.GF15097@alvh.no-ip.org> (raw)
In-Reply-To: <FE44E0D7EAD2ED4BB2165071DB8E328C0378F425@egcrc-ex01.egcrc.org>
References: <FE44E0D7EAD2ED4BB2165071DB8E328C0378F414@egcrc-ex01.egcrc.org>
<48AF9E8B.9020508@frostconsultingllc.com>
<48AFA015.2000909@frostconsultingllc.com>
<FE44E0D7EAD2ED4BB2165071DB8E328C0378F416@egcrc-ex01.egcrc.org>
<Pine.LNX.4.64.0808232228540.5906@discord.home.frostconsultingllc.com>
<FE44E0D7EAD2ED4BB2165071DB8E328C0378F417@egcrc-ex01.egcrc.org>
<22746678-86BF-4F63-9F3D-6B822B9FFC47@zeroaccess.org>
<FE44E0D7EAD2ED4BB2165071DB8E328C0378F41A@egcrc-ex01.egcrc.org>
<F4F56732-874A-4A10-A445-E43CBD49F971@zeroaccess.org>
<FE44E0D7EAD2ED4BB2165071DB8E328C0378F425@egcrc-ex01.egcrc.org>
Tena Sakai wrote:
> Hi,
>
> I downloaded the latest release (8.3.3), followed the
> instruction on the manual to install and restored the
> file I had made by pg_dumpall, thereby bypassing the
> trouble with files in pg_clog directory.
>
> I just read a bit about these files. They are made
> as a result of autovacuum. Does anybody have notion
> as to how long they should be kept, what recycling
> policy there ought to be, etc?
They are not created by autovacuum. They are a very central part of the
system. Autovacuum can cause them to be removed when they are no longer
needed (manual vacuuming can cause them to be deleted too). If they are
removed before every last bit that depends on them is, then we have a
bug.
This is very strange:
> > > I went into pg_clog directory and issued:
> > > ls -lt | head
> > > and it told me:
> > > -rw------- 1 postgres postgres 163840 Aug 24 09:57 0088
> > > drwx------ 11 postgres postgres 4096 Aug 22 13:56 ..
> > > drwx------ 2 postgres postgres 4096 Jun 30 16:03 .
> > > -rw------- 1 postgres postgres 262144 Jun 1 20:04 0084
> > > -rw------- 1 postgres postgres 262144 Apr 4 15:48 0083
> > > -rw------- 1 postgres postgres 262144 Mar 26 18:25 0082
> > > -rw------- 1 postgres postgres 262144 Mar 26 01:28 0081
> > > -rw------- 1 postgres postgres 262144 Mar 25 23:05 0080
> > > -rw------- 1 postgres postgres 262144 Mar 25 20:39 007F
> > >
> > > It seems that 0088 was generated at the time very close to
> > > my issuing dropdb.
When a file is deleted, all files prior to it must be deleted too. If
files prior to it remained, what it suggests is that the deletion did
not happen because of vacuum or autovacuum, but because of something
else that's not related to Postgres.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alvherre@commandprompt.com, tsakai@gallo.ucsf.edu, pglists@zeroaccess.org, jeff@frostconsultingllc.com
Subject: Re: restoring from dump
In-Reply-To: <20080826023406.GF15097@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox