Re: PostgreSQL 7.4.16 is creating strange files under /var/lib/pgsql - Mailing list pgsql-general

From Juan Sueiro
Subject Re: PostgreSQL 7.4.16 is creating strange files under /var/lib/pgsql
Date
Msg-id AANLkTikJde0QB7fce_gr3=GDWZO621anrhyqxVHRsk+4@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL 7.4.16 is creating strange files under /var/lib/pgsql  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: PostgreSQL 7.4.16 is creating strange files under /var/lib/pgsql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Merlin,
I'm not sure about the unix mode/owner, the server is:

Red Hat Enterprise Linux AS release 4 (Nahant Update 5)
Linux linuxbox 2.6.9-55.ELsmp #1 SMP Fri Apr 20 17:03:35 EDT 2007 i686 i686 i386 GNU/Linux

Currently there are no other server applications/software running there. I thought that maybe the postgresql could be creating the files because of the specific /var/lib/pgsql path.

Regards,


Juan Sueiro
(54911) 5663 9439



On Thu, Oct 7, 2010 at 11:53 AM, Merlin Moncure <mmoncure@gmail.com> wrote:
On Thu, Oct 7, 2010 at 9:45 AM, Juan Sueiro <jmsueiro@gmail.com> wrote:
> Hello all,
> I'm experiencing a weird issue where my postgresql is creating strange files
> (all with the same size ~200MB) under /var/lib/pgsql. The filenames are like
> "?" and "?default". Anyone knows if it's safe to remove those? because they
> are eating my disk space on the /var partition.
> Version: PostgreSQL 7.4.16 on i686-redhat-linux-gnu, compiled by GCC gcc
> (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3)
> Any advices would be really appreciated.

are you 100% sure the database made them? What's the unix mode/owner/etc?

merlin

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: PostgreSQL 7.4.16 is creating strange files under /var/lib/pgsql
Next
From: Greg Smith
Date:
Subject: Re: pg_relation_size / could not open relation with OID #