Re: PostgreSQL 7.4.16 is creating strange files under /var/lib/pgsql

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(at)gmail(dot)com> wrote:

> On Thu, Oct 7, 2010 at 9:45 AM, Juan Sueiro <jmsueiro(at)gmail(dot)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
>