Root partition full of files in /var/lib/postgresql/9.1/main/pg_xlog

Поиск
Список
Период
Сортировка
От Ed Tarento
Тема Root partition full of files in /var/lib/postgresql/9.1/main/pg_xlog
Дата
Msg-id CANTCOwfpoZ_HWkifAtQq2gsYxA2PhiPZCec1-36XVVDW9g-qXw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Root partition full of files in /var/lib/postgresql/9.1/main/pg_xlog  (Thomas SIMON <tsimon@neteven.com>)
Re: Root partition full of files in /var/lib/postgresql/9.1/main/pg_xlog  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список pgsql-admin
Дерево обсуждения
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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: postgres crashes on insert in 40 different threads
Следующее
От: Patrick Dung
Дата:
Сообщение: Re: several questions about pg_dumpall, pg_start_backup, pg_basebackup and WAL