From: Thomas SIMON <tsimon@neteven.com>
To: pgsql-admin@postgresql.org
Subject: Re: Root partition full of files in /var/lib/postgresql/9.1/main/pg_xlog
Date: Mon, 26 Aug 2013 10:36:46 +0200
Message-ID: <521B139E.6000603@neteven.com> (raw)
In-Reply-To: <CANTCOwfpoZ_HWkifAtQq2gsYxA2PhiPZCec1-36XVVDW9g-qXw@mail.gmail.com>
References: <CANTCOwfpoZ_HWkifAtQq2gsYxA2PhiPZCec1-36XVVDW9g-qXw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi,
Have you defined an archive_command ?
What is your value for checkpoint_segments, checkpoint_timeout &
checkpoint_completion_target ?
Thomas
Le 26/08/2013 05:10, Ed Tarento a écrit :
> Hi admins
> I'm a newbie, I hope this is the right group and admit I have little
> postgres experience. I'm working on a VM I can easily re-install so
> killing it doesn't matter. The dir is full of 508 files, the last few
> of which look like:
>
> -rw------- 1 postgres postgres 16777216 Aug 25 02:19
> 0000000100000001000000FA
> -rw------- 1 postgres postgres 16777216 Aug 25 02:39
> 0000000100000001000000FB
> drwx------ 2 postgres postgres 4096 Jun 13 13:24 archive_status
> root@operations:/var/lib/postgresql/9.1/main/pg_xlog#
>
> I have root access to the machine but I don't have any postgres
> access, other than sudo of course. I've tried stopping my app,
> ensuring nothing postgres appears in ps and tried deleting the files
> but when I restarted my app, it didn't work. I've checked (Google) as
> many posts as possible but can't find exactly what I need, i.e. the
> method of removing the offending files cleanly.
>
> Here's as much as I can tell you
> Debian 64 bit running on ESXi
> postgres 9.1
>
> I have some *nix experience, can use vi and sudo and the like
>
> I hope you can help
> Thanks
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: tsimon@neteven.com
Subject: Re: Root partition full of files in /var/lib/postgresql/9.1/main/pg_xlog
In-Reply-To: <521B139E.6000603@neteven.com>
* 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