From: Theodotos Andreou <theo@theo-andreou.org>
To: pgsql-admin@postgresql.org
Subject: Error: pid file is invalid, please manually kill the stale server process.
Date: Wed, 12 Feb 2014 07:59:22 +0200
Message-ID: <52FB0DBA.2010907@theo-andreou.org> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi all,
I am using postgres on Ubuntu 12.04 64 bit server. The version is 9.1.10
and I used the stock postgres from Ubuntu repos.
I have a weird problem. Sometimes when the machine is restarted, there
is no $PGDATA/postmaster.pid file. So when I try to restart postgres
(service postgresql restart) I get the following error:
Error: pid file is invalid, please manually kill the stale server process.
An even scarier side-effect of this is that the data, when this happens,
are older than the most recent data in the database.
It may be important to know that postgres runs under monit non sysv init
or upstart.
Also postgres is installed on a customer appliance that may experience
frequent reboots and even abrupt poweroffs! Is postgres in general ideal
for this situation? Is there an optimal configuration for this scenario?
Regards
theo
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: theo@theo-andreou.org
Subject: Re: Error: pid file is invalid, please manually kill the stale server process.
In-Reply-To: <52FB0DBA.2010907@theo-andreou.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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