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

Поиск
Список
Период
Сортировка
От Juan Sueiro
Тема Re: PostgreSQL 7.4.16 is creating strange files under /var/lib/pgsql
Дата
Msg-id AANLkTikJde0QB7fce_gr3=GDWZO621anrhyqxVHRsk+4@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL 7.4.16 is creating strange files under /var/lib/pgsql  (Merlin Moncure <mmoncure@gmail.com>)
Ответы Re: PostgreSQL 7.4.16 is creating strange files under /var/lib/pgsql  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: PostgreSQL 7.4.16 is creating strange files under /var/lib/pgsql
Следующее
От: Greg Smith
Дата:
Сообщение: Re: pg_relation_size / could not open relation with OID #