pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRoot partition full of files in /var/lib/postgresql/9.1/main/pg_xlog
3+ messages / 3 participants
[nested] [flat]
* Root partition full of files in /var/lib/postgresql/9.1/main/pg_xlog
@ 2013-08-26 03:10 Ed Tarento <etarento@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Ed Tarento @ 2013-08-26 03:10 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Root partition full of files in /var/lib/postgresql/9.1/main/pg_xlog
@ 2013-08-26 08:36 Thomas SIMON <tsimon@neteven.com>
parent: Ed Tarento <etarento@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Thomas SIMON @ 2013-08-26 08:36 UTC (permalink / raw)
To: pgsql-admin
Hi,
Have you defined an archive_command ?
What is your value for checkpoint_segments, checkpoint_timeout &
checkpoint_completion_target ?
Thomas
Le 26/08/2013 05:10, Ed Tarento a écrit :
> 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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Root partition full of files in /var/lib/postgresql/9.1/main/pg_xlog
@ 2013-08-26 08:44 Albe Laurenz <laurenz.albe@wien.gv.at>
parent: Ed Tarento <etarento@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Albe Laurenz @ 2013-08-26 08:44 UTC (permalink / raw)
To: Ed Tarento *EXTERN* <etarento@gmail.com>; pgsql-admin
Ed Tarento wrote:
> 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
In addition to Thomas' questions (most of all, check "archive_mode"
and "archive_command" and see if there are any error messages in the
database server log) let me add the following:
You have probably damaged your database by randomly deleting files
it needs to run (the log will tell you details).
The first thing you should do is to make a backup of *all* the files
that you didn't delete yet.
Most likely you will have to use "pg_resetxlog" to get the cluster into
a state where it can start. Then *immediately* take a full logical
backup with pg_dumpall and import that into a new database cluster.
Keep your fingers crossed that there is not too much inconsistency
for this to work. It might take some fiddling with pg_resetxlog's
options to make it work.
Do *not* continue working with the cluster after pg_resetxlog has been run.
Read the documentation.
Yours,
Laurenz Albe
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-08-26 08:44 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-08-26 03:10 Root partition full of files in /var/lib/postgresql/9.1/main/pg_xlog Ed Tarento <etarento@gmail.com>
2013-08-26 08:36 ` Thomas SIMON <tsimon@neteven.com>
2013-08-26 08:44 ` Albe Laurenz <laurenz.albe@wien.gv.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox