Re: Re: could not create lock file postmaster.pid: No such file or directory, but file does exist

From: Alban Hertroys <haramrae(at)gmail(dot)com>
To: "Rob Goethals / SNP" <Rob(dot)Goethals(at)snp(dot)nl>
Cc: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Re: could not create lock file postmaster.pid: No such file or directory, but file does exist
Date: 2014-02-17 14:40:57
Message-ID: CAF-3MvOeuohXwAde+OuWm4NO6mDnpgqpO=Y3Q_B8ifaicQ_w-A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

On 17 February 2014 14:42, Rob Goethals / SNP <Rob(dot)Goethals(at)snp(dot)nl> wrote:
> 2014-02-15 00:49:04 CET LOG: WAL writer process (PID 1127) was terminated by signal 6: Aborted

Signal 6 is usually caused by hardware issues.

Then again, you also say:

>I mounted a directory on a NTFS network-disk (because of the available size and considering the
> amount of OSM-data is pretty big). This is where I put all my database data, so also the pg_xlog.

That will cause problems as well. SMBFS does not support all the
necessary file flags, locks and such that the database needs to
operate on those files in a safe way. That's probably worse than
running with sciss... ehr... fsync=off

Alban Hertroys.
--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2014-02-17 15:09:38 Re: Re: could not create lock file postmaster.pid: No such file or directory, but file does exist
Previous Message Rob Goethals / SNP 2014-02-17 13:42:17 Re: could not create lock file postmaster.pid: No such file or directory, but file does exist

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2014-02-17 15:09:38 Re: Re: could not create lock file postmaster.pid: No such file or directory, but file does exist
Previous Message Rob Goethals / SNP 2014-02-17 13:42:17 Re: could not create lock file postmaster.pid: No such file or directory, but file does exist