From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rob Goethals / SNP <Rob.Goethals@snp.nl>
Cc: 'Albe Laurenz' <laurenz.albe@wien.gv.at>
Cc: 'pgsql-general@postgresql.org' <pgsql-general@postgresql.org>
Subject: Re: Re: could not create lock file postmaster.pid: No such file or directory, but file does exist
Date: Mon, 17 Feb 2014 10:09:38 -0500
Message-ID: <16719.1392649778@sss.pgh.pa.us> (raw)
In-Reply-To: <ED8C42FD028EEC448A5E8B5D3DD4C6C601B18D105620@2003exchange.snp.pit.nl>
References: <ED8C42FD028EEC448A5E8B5D3DD4C6C601B18D10561E@2003exchange.snp.pit.nl>
<A737B7A37273E048B164557ADEF4A58B17CA7E02@ntex2010i.host.magwien.gv.at>
<ED8C42FD028EEC448A5E8B5D3DD4C6C601B18D10561F@2003exchange.snp.pit.nl>
<A737B7A37273E048B164557ADEF4A58B17CA7E88@ntex2010i.host.magwien.gv.at>
<ED8C42FD028EEC448A5E8B5D3DD4C6C601B18D105620@2003exchange.snp.pit.nl>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
Rob Goethals / SNP <Rob.Goethals@snp.nl> writes:
> When it is trying to startup again this is the logfile output:
> ...
> 2014-02-15 00:50:05 CET PANIC: could not create file "pg_xlog/xlogtemp.5390": Input/output error
The above PANIC is the reason for the abort that happens immediately
thereafter.
On local storage I'd think this meant disk hardware problems, but since
you say you've got the database on an NTFS volume, what it more likely
means is that there's a bug in the kernel's NTFS support. Anyway, it's
fruitless to try to get Postgres going again until you have a stable
filesystem underneath it.
Generally speaking, longtime Postgres users are very suspicious of running
Postgres atop any kind of networked filesystem. We find that network
filesystems are invariably less stable than local ones. NTFS seems likely
to be a particularly unfortunate choice from this standpoint, as you get
to benefit from Windows' bugs along with Linux's.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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: tgl@sss.pgh.pa.us, Rob.Goethals@snp.nl, laurenz.albe@wien.gv.at, pgsql-general@postgresql.org
Subject: Re: Re: could not create lock file postmaster.pid: No such file or directory, but file does exist
In-Reply-To: <16719.1392649778@sss.pgh.pa.us>
* 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