Re: pg_dump crashing

From: Matthias Schmitt <matthias(dot)schmitt(at)mmp(dot)lu>
To: rob stone <floriparob(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump crashing
Date: 2016-03-20 15:18:07
Message-ID: 57D61707-AE23-4673-A2EB-0C700FCBF1E6@mmp.lu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

sorry for the late response.

> On 15 Mar 2016, at 18:59, rob stone <floriparob(at)gmail(dot)com> wrote:
>
> I'm running Debian 4.3.5-1 (2016-02-06) x86_64 GNU/Linux.
>
> Backups are done via a shell script using double hyphen syntax, as in
> e.g.:-
>
> pg_dump --port=5433 --dbname=mydatabase_1_0_0 --username=mmppostgres
> --file=/my_backup_path/mydatabase_1_0_0.dump
>
> We do it twice. First with --data_only and the second time with
> --format=custom
>
> Hasn't failed yet. Don't know if this helps at all but worth a try.

Thank you for your answer. 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
http://www.mmp.lu

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthias Schmitt 2016-03-20 15:24:13 Re: pg_dump crashing
Previous Message Yi, Yi 2016-03-20 14:04:47 Re: Confused by the behavior of pg_basebackup with replication slot