Re: [GENERAL] pg_dump crashing ... solved

2016-03-20 Thread Matthias Schmitt
be a difference if the job is running as a “normal” user or a “system” user. So I modified my existing postgres user to be a system user usermod -u mmppostgres an now my backup is running. I cannot remember finding such a hint in the PostgreSQL documentation. It would be worth mentioning it.

Re: [GENERAL] pg_dump crashing

2016-03-20 Thread Matthias Schmitt
Hello, > On 16 Mar 2016, at 14:55, Adrian Klaver wrote: > > On 03/15/2016 08:10 AM, Matthias Schmitt wrote: >> Hello, >> >> since two weeks I am trying to get PostgreSQL 9.5.1 to run on Debian 8.3. >> Everything is fine except the daily backup. When calling

Re: [GENERAL] pg_dump crashing

2016-03-20 Thread Matthias Schmitt
nswer. But sorry, no, this does not change anything. Same server crash when executed in a cron job. It runs perfectly when executed manually from the shell. Best regards Matthias Schmitt magic moving pixel s.a. 23, Avenue Grande-Duchesse Charlotte L-3441 Dudelange Luxembourg Phone: +352 54 75 75 h

[GENERAL] pg_dump crashing

2016-03-15 Thread Matthias Schmitt
he same backup mechanism. I hate to consider a downgrade as a possible solution. May be an info, which might be useful: my machine has 64 GB RAM. Any ideas where to continue my search? Best regards Matthias Schmitt magic moving pixel s.a. 23, Avenue Grande-Duchesse Charlotte L-3441 Dudelange