Hello, thank you for your answers.
> On 20 Mar 2016, at 16:56, Adrian Klaver <[email protected]> wrote: > > So what happens if you either?: > > 1) In the root crontab, change the command to: > > /Users/…/bin/pg_dump -p 5433 mydatabase_1_0_0 -U mmpostgres > > /my_backup_path/mydatabase_1_0_0.dump This will make no difference. > On 21 Mar 2016, at 03:42, Thomas Munro <[email protected]> wrote: > > Is this related? > > http://www.postgresql.org/message-id/cak7teys9-o4bterbs3xuk2bffnnd55u2sm9j5r2fi7v6bhj...@mail.gmail.com Yes, this is related. I tried to set RemoveIPC=no, but it made no difference. Finally I found a solution with the hint given here: http://www.postgresql.org/message-id/[email protected] Systemd defaults to remove all IPC (including SYSV memory) when a user "fully" logs out. This seems to be happen when running the cron job. It seems to 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 <id below 1000> mmppostgres an now my backup is running. I cannot remember finding such a hint in the PostgreSQL documentation. It would be worth mentioning it. Best regards Matthias Schmitt magic moving pixel s.a. 23, Avenue Grande-Duchesse Charlotte L-3441 Dudelange Luxembourg Phone: +352 54 75 75 http://www.mmp.lu -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
