Rob Goethals wrote:
> OK, clear. I hereby send this reply also to the list.

Cool.

>> Interesting.
>> How did you get PostgreSQL into this state?  Did you set fsync=off or 
>> similar?
>> Which storage did you put pg_xlog on?

> 2014-02-15 00:49:04 CET  LOG:  WAL writer process (PID 1127) was terminated 
> by signal 6: Aborted

Ouch.

> Furthermore I checked my conf-file and my fsync is indeed set to off.

Well, that is one reason why crash recovery is not working.

> 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.

Double ouch.
CIFS is not a supported file system.

At least that explains your problems.
Try with a local file system or NFS with hard foreground mount.

Yours,
Laurenz Albe

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to