Skip site navigation (1) Skip section navigation (2)

Re: postmaster stopps

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ashley Maher <ashley(dot)maher(at)didymodesigns(dot)com(dot)au>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: postmaster stopps
Date: 2004-10-12 03:54:54
Message-ID: 27628.1097553294@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Ashley Maher <ashley(dot)maher(at)didymodesigns(dot)com(dot)au> writes:
> I installed postgresql-7.4.3 about three months ago.

> Twice, with no known reason the postmaster has stopped.

The postmaster is not known for "just stopping".  There will certainly
be some evidence either in the postmaster's log (if it aborted for some
internal reason) or in the kernel log (if you got hit by the Linux OOM
killer) or at worst in a core dump file left by the postmaster (though
I really seriously doubt that one).

Now it's entirely possible that you're starting the postmaster in a way
that destroys the evidence.  Check to see if you are sending postmaster
stderr to /dev/null, and if so put it someplace more useful.  Also make
sure the postmaster is not being launched under "ulimit -c 0", and that
it's being started in a directory that postgres is allowed to write (so
that a core file can be created, if worst comes to worst).

When you've got some evidence to look at, we'll be glad to help you
interpret it, but there's no point in speculating without evidence.

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: alwinDate: 2004-10-12 14:18:01
Subject: case insensitive table names
Previous:From: Ashley MaherDate: 2004-10-12 03:29:37
Subject: postmaster stopps

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group