Re: pg_dump crashing

From: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
To: Matthias Schmitt <matthias(dot)schmitt(at)mmp(dot)lu>
Cc: rob stone <floriparob(at)gmail(dot)com>, Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump crashing
Date: 2016-03-21 02:42:35
Message-ID: CAEepm=2CtGRKQSyCbMwA7-SeE=K3Ciuje41c6zgHB2Oe_B3abA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Mar 21, 2016 at 4:18 AM, Matthias Schmitt
<matthias(dot)schmitt(at)mmp(dot)lu> wrote:
> 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.

Is this related?

http://www.postgresql.org/message-id/CAK7tEys9-O4BTERbs3Xuk2BfFNNd55u2sM9j5R2Fi7v6BHjrQw@mail.gmail.com

--
Thomas Munro
http://www.enterprisedb.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Matthias Schmitt 2016-03-21 06:34:41 Re: pg_dump crashing ... solved
Previous Message Adrian Klaver 2016-03-20 15:56:18 Re: pg_dump crashing