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

2010-10-08 Thread Scott Ribe
On Oct 7, 2010, at 9:02 PM, Craig Ringer wrote: > Where? They can't be in /var/lib/pgsql if there are four of them, so they > must be in subdirectories, right? Which ones? Or they're created with odd characters which the user's shell/terminal/UI cannot display. -- Scott Ribe scott_r...@elevat

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

2010-10-07 Thread Craig Ringer
On 7/10/2010 10:28 PM, Juan Sueiro wrote: Tom, Files are located under /var/lib/pgsql: 4 files with filename: "?" Where? They can't be in /var/lib/pgsql if there are four of them, so they must be in subdirectories, right? Which ones? 1 file with filename: "??" 1 file with filename: "?defa

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

2010-10-07 Thread Tom Lane
Juan Sueiro writes: > 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 runnin

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

2010-10-07 Thread Juan Sueiro
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

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

2010-10-07 Thread Merlin Moncure
On Thu, Oct 7, 2010 at 9:45 AM, Juan Sueiro 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 the

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

2010-10-07 Thread Juan Sueiro
Tom, Files are located under /var/lib/pgsql: 4 files with filename: "?" 1 file with filename: "??" 1 file with filename: "?default" 1 file with filename: "HELP?" 1 file with filename: "TNMP?" Regards, On Thu, Oct 7, 2010 at 11:17 AM, Tom Lane wrote: > Juan Sueiro writes: > > I'm experiencing

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

2010-10-07 Thread Tom Lane
Juan Sueiro writes: > 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". Please be a little more explicit about what the filenames are, and where they are. I presume the

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

2010-10-07 Thread Peter Geoghegan
On 7 October 2010 14:45, Juan Sueiro wrote: > Any advices would be really appreciated. You should upgrade to a version of Postgres that is currently supported right away. -- Regards, Peter Geoghegan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

[GENERAL] PostgreSQL 7.4.16 is creating strange files under /var/lib/pgsql

2010-10-07 Thread Juan Sueiro
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: