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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
